Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Hot answers tagged

12

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, Apt. 39, and 1221-102 CANYON ROCK CT would be 1221 Canyon Rock Ct, Apt. 102. It's not a very good way to denote an apartment/room/suite number but I've seen it ...


11

From the Google Maps help on how to Fix an error on Google Maps: Help us make Maps better Community edits allow you to modify the information you see on Google Maps, making it more accurate for everyone. To let us know about a point of interest other than a business, use the Report a Problem link and follow these instructions: Drag the ...


10

I don't think regular expressions will help you here, because its designed for pattern matching rather than semantic interpretation, so your string.split() function will probably do as well. But without a database to compare each token against, it'd be pretty hard to determine what level a token represents. If, for instance the right-most token is Zealand, ...


10

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[word] if word in d else word for word in names.split()]) Call with: replacename( !names!, !new_names!)


9

Yes, always anticipate coordinates to fluctuate. Though the building is not likely to shift on the earth's surface, using coordinates as identifiers/keys for addresses is a bad idea because the data set is going to move from underneath you: Accuracy a matter of definition. Is an address most accurately pinned at its mailbox, or its largest structure, or ...


7

you can try gisgraphy. it includes an address parser, a geocoder, and a reverse geocoder. (dont use the free service for batch, but install it on your server). fulltextsearch with synomyms, spellchecking can probably helps too. there is no problems if you need high volumes, because gisgraphy is available as webservices with several format (XML, JSON, PHP, ...


7

I've spent a lot of time experimenting with this, I think it's better to post separately since they are from different angle. This is really a complex topic, see more details in my blog post about the geocoding server setup and the script I used., here is just some brief summaries: A server with only 2 States data is always faster than a server loaded with ...


7

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): if StNa == "BEND": return STDir+" "+StNa elif StNa == "CEDAR GARDEN": return StNa.replace(" ", "") else: return StNa


6

Reverse Geocode (Geocoding) Creates addresses from point locations in a feature class. The reverse geocoding process searches for the nearest address or intersection for the point location based on the specified search distance. In ArcMap, the tool is located under Geocoding Tools. Note that you'll need to have an address locator to reverse ...


6

I have some experience with this. At SmartyStreets (where I work), we make address verification software called LiveAddress. (It's actually all web-based; no need to download or install it.) The challenges of validating and standardizing addresses are plenty, I assure you. It gets even trickier when you attempt to parse the address into particular ...


6

Let me point out first that there are also addresses that the US Post Office doesn't deliver to at all. Not even to a common mail receptacle or group of mailboxes. Certainly anyone can get a PO box at the nearest Post Office. Many times, a remote, or extremely rural address will still be serviced by UPS or Fedex. The USPS designates each ZIP Code with a "...


6

I think you will find numerous answers to similar questions on our site by searching the geocode tag. A few that stick out are: Geocoding API Comparison Bulk Geocode 20 million records What reliable GeoCoding service would you recommend me? Is there an open source Geocoding tool which can be used commercially? Geocoding that's anonymous, good, and free - ...


6

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 expression strpos finds the position of the first white space in the string (i.e. 5, the result is "1250 "); then it saves the left part of the string from the position 4: the result is ...


6

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 addressParser(inString): returnType = "House Number" #returnType = "Street Name" splitString = inString.split(' ',1) houseNumber = splitString[0]...


6

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 free batch geocoder here : https://adresse.data.gouv.fr/csv If you use it, you'll obtain a csv with xy coordinates (ESPG:4326) for each of your adresses. ...


5

Google's Terms of Use does not permit commercial (esp. automated) use of the data. Yes, Google appears to parse single-line street addresses and geocodes them, but it is not appropriate for commercial purposes as Mapperz has noted. Also, standardizing addresses will be a bit of a bugger with Google's API. Google Maps is an address approximation service, not ...


5

There is this site Openaddresses.org (BETA) http://www.openaddresses.org/?northing=4974674.7020191&easting=-8241342.5166015&zoom=16&overlayOpacity=0.7 http://wiki.openstreetmap.org/wiki/TIGER_to_OSM_Attribute_Map#Address_Ranges


5

I used to work at SmartyStreets, a licensed CASS™ vendor of USPS address data. What you want to do sounds exactly like what they do. The USPS ZIP+4 file is available from many sellers, but you're right: it only contains about 30-40 million records. We sometimes called it the "ranges" file because it contains address data at a range level only. In ...


5

All of the world's postal code formats are tabulated here: http://www.grcdi.nl/gsb/world%20postal%20code%20formats.html Some countries may precede their postal codes with a country code, as you describe in your question; and where codes contain spaces or punctuation they may be found written without, but even then there are only a few hundred possible ...


5

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> <html> <head><title>Leaflet</title> <link rel="stylesheet" href="https://unpkg.com/leaflet@1.3.1/dist/leaflet.css" /> <script src="...


4

In light of my comment on MerseyViking's answer, I thought I'd elaborate just for clarity and completeness. I used to work in the address parsing/verification industry for SmartyStreets. What you're trying to do, I think, is called "Single-line address processing" (we call it SLAP). It's a complicated task, though, because addresses will inevitably be very, ...


4

Paid for EZ-Locate (TeleAtlas - owned by TomTom) http://www.geocode.com/index.cfm?module=download NAVmart (NavTeq owned by Nokia) http://www.navmart.com/geocoding.php http://www.navmart.com/geocoding_services.php Free Via Michelin (API and better coverage in Europe rather than globally) http://dev.viamichelin.com/ Geonames (good open-source - patchy ...


4

QGIS has a 'line intersections' tool that will create a point at all intersections. I'm not sure about getting an address at the intersection--I see a few issues with that. Which road would you pick to pull the address from? Since intersections generally don't have addresses, is it even meaningful? I realize that a single line street network with ranges ...


4

Someone in a similar situation to you posted here: https://productforums.google.com/d/msg/maps/WJeY25YbFSo/n8hA_LZMEokJ Go to Google.com click on "About Google" at the bottom click on "Contact us" at the bottom At the first drop down box where it says Or, jump straight to specific product contact options - SELECT "Maps contact options" ...


4

in attribute table, doesnt Look For option work for you? or you can use Find by Attribute plugin too. An update to the Find by Attribute plugin providing useful functionality for finding and zooming to single or multiple features. i hope it helps you...


4

You can create a Composite Address Locator using ArcCatalog that has this functionality. You first create your individual locators, then add them to the Composite locator. You set the order of the individual locators in the composite locator setup. If the address does not find a match in the first locator in the list, it is passed to the next locator in ...


4

What you need are indexes. You may have indexes on your tables right now but since you're using ST_TRANSFORM they're not being used. Indexing on transform is even mentioned on the function's page: http://postgis.net/docs/ST_Transform.html CREATE INDEX idx_address_3112 ON address_list USING gist (ST_Transform(wkb_geometry, 3112)) CREATE INDEX ...


4

This may vary depending on where in the US you are, but typically as part of the development process addresses are assigned by the city/county assessor around the time the plat is recorded. I don't think it's so much a case of 'validating' as getting updated data, just like your geocoding vendor. It sounds like the post office has more recently updated their ...


4

The Google Places API might be useful here: The Google Places API is a service that returns information about Places — defined within this API as establishments, geographic locations, or prominent points of interest — using HTTP requests. Place requests specify locations as latitude/longitude coordinates. It returns the type of establishment: ...


4

Update you roads direction using a formula something like if (45 <= (360 + math.atan2((!Shape.lastpoint.X! - !Shape.firstpoint.X!),(!Shape.lastpoint.Y! - !Shape.firstpoint.Y!)) * (180 / math.pi)) % 360 % 180) < 135): dir = 'W-E' else: dir = 'N-S' Then for each direction group number them in order using the first opposite ordinate to sort. ...


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