Changes to make Centralized data smaller: Difference between revisions

Line 21:

}}

=== Postal_Code_Master table ===

=== [[Postal_Code_Master table]] ===

~~Further, we have~~ a [[Postal_Code_Master table]] in ~~there~~. It’s in ~~Centralized Data only~~ because Pagasa maintains it, so if it was in CFE it would get lost if ~~I make~~ an update to that file. ~~But~~ there is ~~no reason~~ it ~~couldn’t live in~~ a different file, ~~that~~ would just have to be added to the push pull machinery for Pagasa. ~~Removing this table further shrinks the file to 0.721GB~~

There is a [[Postal_Code_Master table]] in [[Centralized data.mdb]]. It’s in this file because Pagasa maintains it, so if it was in [[CFE]] it would get lost if Tina made an update to that file. Removing this table would further shrink the file to 0.721GB .

{{DJ |

* Do you actually use this table? If so we might need to keep it in Centralized so you get any updates Pagasa makes. [[User:Ttenbergen|Ttenbergen]] 16:38, 2022 August 10 (CDT)

* The table has a lot of fields that are only populated for MB, an not even consistenly there. Do you use any of these fields for aggregation? Do you use this table at all when you do geographic analysis, or do you have a different one? They are all 255char fields, so if there are any we don't use we should consider eliminating them. There are also some erratic entries in there, eg. latitudes and longitudes missing their decimal points, or rhacode and province blank... do we need to review this? [[User:Ttenbergen|Ttenbergen]] 16:38, 2022 August 10 (CDT)

}}

If Pagasa is the only user of this table we could move it into a different file, which would just have to be added to the push pull and reconnect machinery for Pagasa.

==== Next Steps ====

Line 29:

Line 36:

| todo_added = 2022-08-10

| todo_action = 2022-08-10

| question =

| question = _after

* ~~Tina to figure~~ out

* Waiting for info from Julie:

** Can we move the file out? [[User:Ttenbergen|Ttenbergen]] 16:38, 2022 August 10 (CDT)

** Can we reduce field sizes? [[User:Ttenbergen|Ttenbergen]] 16:38, 2022 August 10 (CDT)

}}

==== Log ====

== Related articles ==

@@ Line 21: / Line 21: @@
 }}
-=== Postal_Code_Master table ===
+=== [[Postal_Code_Master table]] ===
-Further, we have a [[Postal_Code_Master table]] in there. It’s in Centralized Data only because Pagasa maintains it, so if it was in CFE it would get lost if I make an update to that file. But there is no reason it couldn’t live in a different file, that would just have to be added to the push pull machinery for Pagasa. Removing this table further shrinks the file to 0.721GB
+There is a [[Postal_Code_Master table]] in [[Centralized data.mdb]]. It’s in this file because Pagasa maintains it, so if it was in [[CFE]] it would get lost if Tina made an update to that file. Removing this table would further shrink the file to 0.721GB .
+{{DJ |
+* Do you actually use this table? If so we might need to keep it in Centralized so you get any updates Pagasa makes. [[User:Ttenbergen|Ttenbergen]] 16:38, 2022 August 10 (CDT)
+* The table has a lot of fields that are only populated for MB, an not even consistenly there. Do you use any of these fields for aggregation? Do you use this table at all when you do geographic analysis, or do you have a different one? They are all 255char fields, so if there are any we don't use we should consider eliminating them. There are also some erratic entries in there, eg. latitudes and longitudes missing their decimal points, or rhacode and province blank... do we need to review this? [[User:Ttenbergen|Ttenbergen]] 16:38, 2022 August 10 (CDT)
+}}
+If Pagasa is the only user of this table we could move it into a different file, which would just have to be added to the push pull and reconnect machinery for Pagasa.
 ==== Next Steps ====
@@ Line 29: / Line 36: @@
   | todo_added = 2022-08-10
   | todo_action = 2022-08-10
-  | question =
+  | question =  _after
-* Tina to figure out
+* Waiting for info from Julie:
+** Can we move the file out? [[User:Ttenbergen|Ttenbergen]] 16:38, 2022 August 10 (CDT)
+** Can we reduce field sizes? [[User:Ttenbergen|Ttenbergen]] 16:38, 2022 August 10 (CDT)
 }}
 ==== Log ====
 == Related articles ==