Modification to GEO Code Field
-
- New Member
- Posts: 3
- Joined: Wed Jul 23, 2008 6:30 pm
Modification to GEO Code Field
Currently there is a Unit GEO Code Field edited at the Unit, and a Stake GEO Code Field, edited at the Stake level. Looks like they hold 6 characters each. For Stake boundary and other analysis purposes we export the MLS Membership data and then Geo Code it in a spreadsheet. Having that LAT/LON data we have nowhere to maintain it in the system, since we don't have enough characters in the field. (Need 8 each for lattitude and longitude)
My request for consideration is that LAT/LON fields be created at the Unit Level and included in the Membership.csv export.
Thanks.
My request for consideration is that LAT/LON fields be created at the Unit Level and included in the Membership.csv export.
Thanks.
- mkmurray
- Senior Member
- Posts: 3266
- Joined: Tue Jan 23, 2007 9:56 pm
- Location: Utah
- Contact:
I think having LAT and LON fields is a great idea.kmmoss wrote:Currently there is a Unit GEO Code Field edited at the Unit, and a Stake GEO Code Field, edited at the Stake level. Looks like they hold 6 characters each. For Stake boundary and other analysis purposes we export the MLS Membership data and then Geo Code it in a spreadsheet. Having that LAT/LON data we have nowhere to maintain it in the system, since we don't have enough characters in the field. (Need 8 each for lattitude and longitude)
My request for consideration is that LAT/LON fields be created at the Unit Level and included in the Membership.csv export.
Thanks.
As for the charcter limit, we have been able to fit 8 characters in those fields and are currently using an 8 character-length Geocode. We have been doing this for some time. (Perhaps I'm mistaken...)
Also, the unit is able to populate the Stake Geocode if desired, as we fill in both Geocodes at the moment whenever we have a new move in.
-
- Senior Member
- Posts: 1345
- Joined: Wed Jun 11, 2008 9:52 pm
- Location: Austin TX
- Contact:
kmmoss wrote: My request for consideration is that LAT/LON fields be created at the Unit Level and included in the Membership.csv export.
You are not alone in wishing for that, or something similar. We know the Church is working on geographic applications centrally, butwe don't have a roadmap of what that means for MLS.
Meanwhile, units seek their own temporary solutions. In our ward we store the coordinates in separate database files. Another workaround, which I personally do not care for, is to write the coordinates into the street address fields themselves.
There has to be a better solution, and I think we will get it someday.
-
- Senior Member
- Posts: 856
- Joined: Thu Mar 13, 2008 6:17 pm
- Location: Las Vegas, NV
Like this cumbersome one:boomerbubba wrote:Meanwhile, units seek their own temporary solutions.
1. From the menu bar, navigate to Edit > System Options > Members > Custom Fields > Add.
2a. In the Name field type Latitude & Longitude; set Value Type to String; add a Description if you want or leave it blank; then click Save.
2b. Alternatively, in the Name field type Latitude; set Value Type to String; add a Description if you want or leave it blank; click Save; click the Add link again; in the Name field type Longitude; set Value Type to String; add a Description if you want or leave it blank; then click Save.
3. Click Close.
4. From the menu bar, navigate to Membership > Custom Member Fields > select and open a membership record > Custom Fields.
5. Click the Add link; select the field you added in 2a or 2b above; enter the data you want for that field; click Save.
6. Use the arrow icons in the upper-right-hand-side of the window on either side of the magnifying glass icon to navigate to the next desired record, then repeat step 5 as needed.
7. (Optional) Because you are a programming genius, write compile and debug a Perl script in .NET and Java to sync these MLS fields with the GPS data you have collected on your G3 iPhone and then upload the resulting app to the iTunes App Store for the benefit of G3-iPhone-totin'-MLS-Users everywhere.
-
- Community Administrator
- Posts: 34485
- Joined: Sat Jan 20, 2007 2:53 pm
- Location: U.S.
Now, what steps do you take to make sure your Lat & Lon stay in sync with the address changes? If a family moves within the ward, the Lat & Lon will have to be updated, but it's easy to forget to do that. At least the Geo code clears upon change which draws attention to the need to update it.jbh001 wrote:Like this cumbersome one:
Have you searched the Help Center? Try doing a Google search and adding "site:churchofjesuschrist.org/help" to the search criteria.
So we can better help you, please edit your Profile to include your general location.
So we can better help you, please edit your Profile to include your general location.
- aebrown
- Community Administrator
- Posts: 15153
- Joined: Tue Nov 27, 2007 8:48 pm
- Location: Draper, Utah
RussellHltn wrote:Now, what steps do you take to make sure your Lat & Lon stay in sync with the address changes? If a family moves within the ward, the Lat & Lon will have to be updated, but it's easy to forget to do that. At least the Geo code clears upon change which draws attention to the need to update it.
That's really not hard -- you have a checklist. In the relatively rare occurrence where a family moves within the ward, you already need to do several things that aren't triggered by MLS right now:
- Fast offerings Routes
- Home Teaching
- Visiting Teaching
- etc.
Sometimes we get hung up on having the software take care of everything for us, but it's not hard to have a good old fashioned checklist -- that's how we operated before we clerks had software to help us, and it's still a good idea.
Given all the work involved in capturing, verifying, and storing Lat/Lon, an occasional move within the ward seems like the least of your problems in this area.
-
- Community Administrator
- Posts: 34485
- Joined: Sat Jan 20, 2007 2:53 pm
- Location: U.S.
Occasional? You've never clerked in a singles/student ward, have you? :pAlan_Brown wrote:Given all the work involved in capturing, verifying, and storing Lat/Lon, an occasional move within the ward seems like the least of your problems in this area.
Moves were frequent, we didn't have a fast offering route, and HT/VT was based on personalities rather then who lived nearby. In our case we would have had to create a workflow to make sure we stayed on track.
This might be a good topic for another thread, but what is a good workflow to use when you have a move to deal with any of the above issues?
Have you searched the Help Center? Try doing a Google search and adding "site:churchofjesuschrist.org/help" to the search criteria.
So we can better help you, please edit your Profile to include your general location.
So we can better help you, please edit your Profile to include your general location.
- aebrown
- Community Administrator
- Posts: 15153
- Joined: Tue Nov 27, 2007 8:48 pm
- Location: Draper, Utah
Actually, I have (both as a membership clerk and as a high councilor responsible for clerks), so I speak from actual experience. Moves into and out of the ward happened all the time. Moves within the ward were relatively (note the word "relatively") rare.RussellHltn wrote:Occasional? You've never clerked in a singles/student ward, have you? :p
However, I still stand by my statement that a simple checklist or workflow is all that is needed, and it is needed anyway (particularly for wards such as the singles/student wards you mentioned). So adding one little step to that checklist is trivial. I was simply responding to the claim that somehow neglecting to update the custom field containing lat/lon for intra-ward moves was a problem of any significance compared with all the other work that goes on.
Questions that can benefit the larger community should be asked in a public forum, not a private message.