Santa Rosa, California
Data license: © OpenStreetMap contributors — ODbL 1.0
83,282 rows
This data as json, CSV (advanced)
| Link | rowid ▼ | House number | Street name | Postal code | Latitude | Longitude |
|---|---|---|---|---|---|---|
| 1 | 1 | 715 | Rae Street | 95404 | 38.4379675 | -122.7091530 |
| 2 | 2 | 729 | Sonoma Avenue | 95404 | 38.4365559 | -122.7119040 |
| 3 | 3 | 1667 | West Steele Lane | 95403 | 38.4606294 | -122.7345913 |
| 4 | 4 | 1665 | West Steele Lane | 95403 | 38.4604782 | -122.7336847 |
| 5 | 5 | 2301 | Hardies Lane | 95403 | 38.4602345 | -122.7357170 |
| 6 | 6 | 1667 | West Steele Lane | 95403 | 38.4606168 | -122.7342372 |
| 7 | 7 | 535 | Summerfield Road | 95405 | 38.4538527 | -122.6714321 |
| 8 | 8 | 100 | Brush Creek Road | 95404 | 38.4548570 | -122.6809468 |
| 9 | 9 | 603 | Santa Rosa Avenue | 95404 | 38.4325844 | -122.7117560 |
| 10 | 10 | 1760 | Piner Road | 95403 | 38.4688321 | -122.7435391 |
| 11 | 11 | 2681 | Cleveland Avenue | 95403 | 38.4639790 | -122.7288340 |
| 12 | 12 | 1899 | Mendocino Avenue | 95401 | 38.4589053 | -122.7174474 |
| 13 | 13 | 3635 | Montgomery Drive | 95405 | 38.4522884 | -122.6756548 |
| 14 | 14 | 3637 | Montgomery Drive | 95405 | 38.4523273 | -122.6756922 |
| 15 | 15 | 3639 | Montgomery Drive | 95405 | 38.4523663 | -122.6757223 |
| 16 | 16 | 3641 | Montgomery Drive | 95405 | 38.4524155 | -122.6757655 |
| 17 | 17 | 3643 | Montgomery Drive | 95405 | 38.4524682 | -122.6758119 |
| 18 | 18 | 3645 | Montgomery Drive | 95405 | 38.4525098 | -122.6758512 |
| 19 | 19 | 3651 | Montgomery Drive | 95405 | 38.4525667 | -122.6759022 |
| 20 | 20 | 3748 | Montgomery Drive | 95405 | 38.4521637 | -122.6746490 |
| 21 | 21 | 3750 | Montgomery Drive | 95405 | 38.4522101 | -122.6745713 |
| 22 | 22 | 3752 | Montgomery Drive | 95405 | 38.4520485 | -122.6745482 |
| 23 | 23 | 3855 | Montgomery Drive | 95405 | 38.4523059 | -122.6752292 |
| 24 | 24 | 3857 | Montgomery Drive | 95405 | 38.4524279 | -122.6752082 |
| 25 | 25 | 3859 | Montgomery Drive | 95405 | 38.4524914 | -122.6752619 |
| 26 | 26 | 3861 | Montgomery Drive | 95405 | 38.4525416 | -122.6753273 |
| 27 | 27 | 3863 | Montgomery Drive | 95405 | 38.4525939 | -122.6753810 |
| 28 | 28 | 3865 | Montgomery Drive | 95405 | 38.4526411 | -122.6754294 |
| 29 | 29 | 3867 | Montgomery Drive | 95405 | 38.4526872 | -122.6754805 |
| 30 | 30 | 3633 | Montgomery Drive | 95405 | 38.4521981 | -122.6755639 |
| 31 | 31 | 4575 | Badger Road | 95409 | 38.4825199 | -122.6753724 |
| 32 | 32 | 1577 | Guerneville Road | 95403 | 38.4529583 | -122.7459267 |
| 33 | 33 | 3175 | Sebastopol Road | 95407 | 38.4273126 | -122.7542049 |
| 34 | 34 | 1835 | West Steele Lane | 95403 | 38.4607276 | -122.7369180 |
| 35 | 35 | 4325 | Mayette Avenue | 95405 | 38.4429411 | -122.6701189 |
| 36 | 36 | 2600 | Bennett Valley Road | 95404 | 38.4326736 | -122.6908394 |
| 37 | 37 | 1650 | West 3rd Street | 95401 | 38.4334128 | -122.7409834 |
| 38 | 38 | 303 | Stony Point Road | 95401 | 38.4345514 | -122.7427107 |
| 39 | 39 | 1315 | Pacific Avenue | 95404 | 38.4533884 | -122.7063391 |
| 40 | 40 | 1135 | Farmers Lane | 95405 | 38.4404166 | -122.6887535 |
| 41 | 41 | 545 | White Oak Drive | 95409 | 38.4402675 | -122.6073378 |
| 42 | 42 | 390 | Coddingtown Mall | 95401 | 38.4580607 | -122.7315092 |
| 43 | 43 | 950 | Coddingtown | 95401 | 38.4571172 | -122.7298590 |
| 44 | 44 | 1181 | Yulupa Avenue | 95405 | 38.4423572 | -122.6745352 |
| 45 | 45 | 44 | West College Avenue | 95401 | 38.4454844 | -122.7290520 |
| 46 | 46 | 4761 | Hoen Avenue | 95405 | 38.4432327 | -122.6638512 |
| 47 | 47 | 2570 | Corby Avenue | 95407 | 38.4149866 | -122.7168320 |
| 48 | 48 | 2527 | Guerneville Road | 95401 | 38.4532695 | -122.7712169 |
| 49 | 49 | 2551 | Guerneville Road | 95401-4000 | 38.4533684 | -122.7715229 |
| 50 | 50 | 2550 | Guerneville Road | 95403 | 38.4520878 | -122.7711300 |
| 51 | 51 | 2550 | Guerneville Road | 95403 | 38.4520872 | -122.7713270 |
| 52 | 52 | 2550 | Guerneville Road | 95403 | 38.4520869 | -122.7714250 |
| 53 | 53 | 2550 | Guerneville Road | 95403 | 38.4520866 | -122.7715130 |
| 54 | 54 | 2550 | Guerneville Road | 95403 | 38.4520860 | -122.7716960 |
| 55 | 55 | 2550 | Guerneville Road | 95403 | 38.4520857 | -122.7717920 |
| 56 | 56 | 217 | Iowa St | 95401 | 38.4337941 | -122.7244353 |
| 57 | 57 | 100 | East Street | 95404 | 38.4409500 | -122.7096866 |
| 58 | 58 | 900 | Sanford Road | 95401 | 38.4258349 | -122.8219210 |
| 59 | 59 | 95 | Montgomery Drive | 95404 | 38.4432869 | -122.7059380 |
| 60 | 60 | 685 | West 3rd Street | 95401 | 38.4336678 | -122.7311992 |
| 61 | 61 | 804 | Coddingtown Center | 95401 | 38.4575084 | -122.7311949 |
| 62 | 62 | 2055 | Range Avenue | 95401 | 38.4562769 | -122.7346427 |
| 63 | 63 | 800 | Coddingtown Center | 95401 | 38.4570220 | -122.7315511 |
| 64 | 64 | 3721 | Santa Rosa Avenue | 95407 | 38.4123370 | -122.7132706 |
| 65 | 65 | 58 | Haworth Way | 95407 | 38.4314028 | -122.7204845 |
| 66 | 66 | 1250 | Sebastopol Road | 95472 | 38.4276652 | -122.7336339 |
| 67 | 67 | 4009 | Sebastopol Road | 95407 | 38.4252427 | -122.7666971 |
| 68 | 68 | 589 | Mendocino Avenue | 95401 | 38.4446416 | -122.7172706 |
| 69 | 69 | 733 | 4th Street | 95404 | 38.4417992 | -122.7114179 |
| 70 | 70 | 650 | 4th Street | 95404 | 38.4409948 | -122.7124383 |
| 71 | 71 | 589 | Mendocino Avenue | 95401 | 38.4445810 | -122.7173135 |
| 72 | 72 | 589 | Mendocino Avenue | 95401 | 38.4446242 | -122.7173265 |
| 73 | 73 | 589 | Mendocino Avenue | 95401 | 38.4446670 | -122.7173424 |
| 74 | 74 | 2183 | Santa Rosa Avenue | 95407 | 38.4178792 | -122.7124510 |
| 75 | 75 | 1435 | Santa Rosa Avenue | 95401 | 38.4235772 | -122.7138745 |
| 76 | 76 | 311 | D Street | 95404 | 38.4415699 | -122.7128203 |
| 77 | 77 | 309 | D Street | 95404 | 38.4414674 | -122.7127159 |
| 78 | 78 | 307 | D Street | 95404 | 38.4414140 | -122.7126894 |
| 79 | 79 | 428 | Mendocino Avenue | 95404 | 38.4418847 | -122.7148827 |
| 80 | 80 | 490 | Mendocino Avenue | 95404 | 38.4423753 | -122.7152541 |
| 81 | 81 | 2068 | Santa Rosa Avenue | 95407 | 38.4180944 | -122.7120070 |
| 82 | 82 | 745 | Coddingtown Center | 95401 | 38.4572227 | -122.7309502 |
| 83 | 83 | 336A;336 | Guerneville Road;Coddingtown | 95401 | 38.4583771 | -122.7301390 |
| 84 | 84 | 2365 | Midway Drive | 95405 | 38.4465054 | -122.6870415 |
| 85 | 85 | 1000 | Farmers Lane | 95405 | 38.4416141 | -122.6868425 |
| 86 | 86 | 415 | Humboldt Street | 95404 | 38.4421383 | -122.7136120 |
| 87 | 87 | 418 | Riley Street | 95404 | 38.4419493 | -122.7139601 |
| 88 | 88 | 1007 | West College Avenue | 95401 | 38.4457380 | -122.7397477 |
| 89 | 89 | 1001 | West College Avenue | 95401 | 38.4462617 | -122.7398699 |
| 90 | 90 | 1007 | West College Avenue | 95401 | 38.4459003 | -122.7397580 |
| 91 | 91 | 1037 | West College Avenue | 95401 | 38.4463807 | -122.7405706 |
| 92 | 92 | 1007 | West College Avenue | 95401 | 38.4456226 | -122.7397491 |
| 93 | 93 | 1009 | West College Avenue | 95401 | 38.4463001 | -122.7403293 |
| 94 | 94 | 1211 | West College Avenue | 95401 | 38.4463273 | -122.7414687 |
| 95 | 95 | 1055 | West College Avenue | 95401 | 38.4457464 | -122.7408630 |
| 96 | 96 | 1039 | West College Avenue | 95401 | 38.4462158 | -122.7405029 |
| 97 | 97 | 1055 | West College Avenue | 95401 | 38.4456368 | -122.7408587 |
| 98 | 98 | 1005 | West College Avenue | 95401 | 38.4463081 | -122.7402229 |
| 99 | 99 | 1040 | North Dutton Avenue | 95401 | 38.4441050 | -122.7299754 |
| 100 | 100 | 2280 B-5 | Mendocino Avenue | 95401 | 38.4620353 | -122.7168641 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [Santa Rosa, California] ( [House number] TEXT, [Street name] TEXT, [Postal code] TEXT, [Latitude] TEXT, [Longitude] TEXT );