Skip to main content
12 votes
Accepted

Meaning of dash in house address number in USA?

In my experience, it usually means what you think it means: a range of address numbers. I've also seen it used as a way of writing an apartment or suite number, so 136-39 37 AVE would be 136 37th Ave, ...
Dan C's user avatar
  • 12.2k
11 votes
Accepted

Address searching/geocoding using Leaflet

I tried too and failed. Here is an option that uses OSM and has other options. https://github.com/perliedman/leaflet-control-geocoder and a HTML page that works using it. <!DOCTYPE html> <...
Bill Chappell's user avatar
11 votes
Accepted

Converting full road names to abbreviation using ArcGIS field calculator?

Use a dictionary and if/else with list comprehension to replace the words: Pre-logic: def replacename( names, new_names): d = {'Lane':'Ln', 'Road':'Rd', 'Street':'St'} return ' '.join([d[...
BERA's user avatar
  • 73.8k
9 votes
Accepted

Extracting only number from address in QGIS Attribute Table

If the addresses are all formatted similarly as in your example, you may try this expression: left("1250 Main Street", strpos("1250 Main Street", '\\s') - 1) Firstly, the ...
mgri's user avatar
  • 16.2k
8 votes

Getting longitude/latitude coordinates from Addresses

So you want to geocode your file ("translate" adresses to xy coordinates). You can search by yourself using this "geocode" keywords and you'll find plenty information. However, in France, there is a ...
Antoine Watrelot's user avatar
8 votes
Accepted

QGIS remove number from the string doesn't work as expected

To remove the numbers at the beginning of the string and its optional following space, you can use regexp_replace(address,'^\\d*\\s?','') ^: beginning of the string \\d: followed by any digit *: ...
JGH's user avatar
  • 42.1k
7 votes

Fixing address errors using Python Parser of ArcGIS Field Calculator?

You have a lot of unnecessary and one unclosed parentheses. The unclosed one in line 5 is causing the syntax error to be thrown in line 6. To correct and clean up, try this: def AddSN2(StNa, STDir): ...
mr.adam's user avatar
  • 3,224
7 votes
Accepted

Field Calculator: Split address into house number, street name

This python script seems to do the trick. It allows the user to choose whether to return the house number or the street name to the field (by commenting-out the non-applicable ReturnType line). def ...
User1974's user avatar
  • 1,132
6 votes

Extracting number with letter from the address string in QGIS

Execute (the number and letter must come first): string_to_array("field", ' ', ' ')[0] Result:
Comrade Che's user avatar
  • 7,161
6 votes
Accepted

Inserting space between address and cardinal direction in QGIS

Regex case assertion is what you need, use this expression in the Field Calculator: regexp_replace("field_name", '(?<=[0-9])(?=[N,W,S,E])', ' ') Replace field_name with a field ...
Mayo's user avatar
  • 3,922
5 votes

Geocoding addresses to coordinates in QGIS

For QGIS versions QGIS 3.20 and higher Starting from QGIS 3.20 it is possible to geocode addresses to coordinates by means of the native tool "Batch Nominatim geocoder", can be found under ...
Taras's user avatar
  • 33k
5 votes

Add/Use geolocation search function in QGIS

If one has access to the Google Maps Platform, please proceed with the following workflow: Install the "Google Maps Geocoder" plugin Proceed with Settings > Options... > Google Maps, ...
Taras's user avatar
  • 33k
5 votes

Add/Use geolocation search function in QGIS

QGIS has a built in functionality, it's the QGIS locator bar, it let you search an address using the nominatim geocoder. It wont be as efficient as a search in google map (no autocompletion or trying ...
J.R's user avatar
  • 16.3k
4 votes
Accepted

How to download all addresses of some area from openstreet maps?

while looking for OSM download functions, I once came across the "overpass-turbo" tool (see http://overpass-turbo.eu/). Although it requires quite some time to get into it and all necessary query ...
ADorsch's user avatar
  • 205
4 votes
Accepted

Understanding U.S. Census MSA to place relationships?

According to the U.S. Census, "Counties or equivalent entities form the geographic 'building blocks' for metropolitan and micropolitan statistical areas throughout the United States and Puerto Rico." ...
syre's user avatar
  • 407
4 votes

Meaning of dash in house address number in USA?

Some localities use a grid-based addressing scheme, for example Fair Lawn, NJ: https://en.wikipedia.org/wiki/Fair_Lawn,_New_Jersey#Grid-based_address_system Fair Lawn uses a street address ...
Joe's user avatar
  • 141
4 votes

Getting longitude/latitude coordinates from Addresses

Sounds like you need some Geocoding. There are several ways that I may refer you to. Using QGIS Plugins, e.g. MMQGIS, GeoCoding, and others (check the list) There is even one especially for France, ...
Taras's user avatar
  • 33k
4 votes

What are last four columns in Royal Mail CSV PAF data used for?

I contacted Royal Mail about this, the additional fields (in order are): Address Key Organisation Key Number of Households Locality Key More information about Address and Organisation Keys can be ...
Leigh's user avatar
  • 141
4 votes

Add a missing address to Google Maps?

When logged in to Google you can "Add a missing place" from the sidebar: Where you can add in the address details:
HeikkiVesanto's user avatar
4 votes
Accepted

Calculating Min and Max Across fields while skipping Zeros

Maybe there are easier ways, but here's one using Python. In the Field Calculator window, select the Python parser Check Show Codeblock The Pre-logic Script code defines a method that returns only ...
Berend's user avatar
  • 4,737
4 votes
Accepted

Changing abbreviations in address column without changing the street names using QGIS

If the abbreviations are at the end of the text, the expression could be something like: regexp_replace( nume,' st$',' street')
Cezar B's user avatar
  • 1,466
3 votes

COUNTY WebService API lookup from valid street address

YAddress API gives you county name, county FP code and many other data fields for an address. Here is a sample response in JSON: Address Line 1: 506 4TH AVE APT 1 Address Line 2: ASBURY PARK, NJ ...
Michael Diomin's user avatar
3 votes

Difference between address geocoding and geocoding

The basic idea of geocoding is taking a human understandable representation of location (ex: 123 W Main St) and using a geocoding tool or service to transform that into a digitally understandable ...
John's user avatar
  • 3,853
3 votes

How to address the alias of a sub-query in the where-clause in PostgreSQL/PostGIS?

You can only reference xy if it were a CTE. The reason is because it's born at the same time as you main query. So for reference you'd have to do do this: WITH xy AS( (SELECT ST_Distance(ha.geom,...
Regina Obe's user avatar
  • 10.5k
3 votes

Using What3Words addresses for 911 addressing in US?

Some platforms and organisations are using it for first response and security from the World Humanitarian Summit to SuperBowl50 - http://what3words.com/using-what3words/emergency-response/ We have ...
Giles Rhys Jones's user avatar
3 votes

Fixing address errors using Python Parser of ArcGIS Field Calculator?

The existing answer certainly addresses your syntax errors. But just from a "code review" perspective that I always found useful when I was learning how to program, here's a more advanced way to write ...
alphabetasoup's user avatar
3 votes
Accepted

How does OpenStreetMap specify underspecified addresses?

Google maps definitely takes into account your estimated location, therefore it will try to give you meaningful answer dedicated for you (general Google policy - personalization of results). I am not ...
Michał Okulewicz's user avatar
3 votes

Address Prefix Strip Using Python

You could use regular expressions in field calculator. I believe this would work given your description. Expression: update_address(!FIELD_NAME!) Code Block: import re def update_street(address):...
ddivittorio's user avatar
3 votes

Converting full road names to abbreviation using ArcGIS field calculator?

If you only want to use the abbreviations for labelling then you could investigate Using an abbreviation dictionary and the About abbreviating and truncating words page: Abbreviation dictionaries ...
PolyGeo's user avatar
  • 65.2k
3 votes
Accepted

Converting abbreviation street type names to full names using dictionary for Python script tool?

1. Make it Case Insensitive Change your dictionary to use all lower-case keys. (eg, 'dr': 'Drive' ). Then change your assignment statement to use the lowercase version of the value as the key to ...
Son of a Beach's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible