Technical communities · SINGAPORE
Singapore mapping workshops: distinguish a missing building name from a missing location
Inspect field-level missing values before deleting location records or inventing names to make a map look complete.
By Boardzip · Published · Updated
Boardzip uses AI-assisted guide research, writing and review. Read how we research guides and check sources →
Start with these checks
- A data-cleaning or mapping exercise with row-level examples
- Time to discuss missing fields separately from invalid locations
- A workshop accepting a small synthetic table instead of private address records
The problem
A Singapore analyst removes every location row without a building name, although some rows still contain usable coordinates and address fields, changing what the resulting map represents.
Define the question the map should answer
Write whether the task needs a point, an address label or a named building. A map of coordinate observations may tolerate an absent name, while a named-destination directory has a different requirement. State the required fields for that task before cleaning. Otherwise, a convenient rule such as dropping blank names can silently select a different set of locations.
Identify the documented missing-value forms
OneMap's reverse-geocoding documentation distinguishes missing fields and unnamed buildings with NIL or null representations. Check which field contains the marker and preserve the source value before normalising it. The word null is not a building name, but it also does not by itself prove that every other field in that record is unusable.
- OneMap: Reverse Geocode ↗ · Source checked
Review a small set of contrasting rows
Bring examples with a missing name but coordinates present, a name without the required coordinate fields and a fully populated row. Use invented or public locations. Ask which records support the intended task and how excluded records should be accounted for. Keep a rejected row visible in a review table with its reason rather than quietly deleting it from the working file.
Choose a truthful display rule
If a record can be plotted but not named, decide whether to use a verified address field, show that the name is unavailable or omit the label. Do not generate a plausible building name to fill the gap. Record the inclusion rule and remaining limitations. A hands-on data session can help test those choices against the actual mapping question.
Questions and answers
Can I replace every missing name with the road name?
Only if the display is clearly a road or address label supported by that field. Relabelling it as a building name would change the meaning of the data. Decide what information the interface needs and retain the distinction between source fields.
Is keeping more rows always better?
Keep records that support the task's stated requirements. More rows are not automatically more accurate, and fewer rows are not automatically cleaner. Explain the inclusion rule and the unresolved fields so another reader can understand what the map represents.
Sources and further reading
These references provide the guide’s source context and further reading. They do not confirm a current event, admission or an available place; check each listing’s organiser terms for those conditions.
- OneMap: Reverse Geocode ↗Source checked
Each date belongs to the linked source check. These references provide source context; a recorded date does not by itself establish a completed independent review. Current event admission is checked separately in each listing. How to read the source dates →
Current listings to check
Topic matches from the verified Singapore feed. A matching topic does not confirm audience suitability, accessibility or available places; read the organiser’s terms.
No current verified listings match this guide’s search terms. Try a broader search or suggest an organiser we should check.
Browse the broader event category →Suggest a relevant organiser →