trees
1,121 rows where qSpecies_id = 6 sorted by qLegalStatus_id
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id ▼ | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17284 | 81630 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 Paulding St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5999996.8419 | 2093367.66723 | 37.7279882186648 | -122.44226048643 | (37.7279882186648, -122.44226048643) | 9 | 7 | 6 | 28861 | 25 | |||
| 17357 | 116552 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 8 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001598.03525 | 2088202.06693 | 37.7138957693564 | -122.436355582838 | (37.7138957693564, -122.436355582838) | 9 | 7 | 6 | 28861 | 5 | |||
| 17413 | 112021 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
| 17459 | 24778 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5982415.49737 | 2112552.2939 | 37.7796461080741 | -122.504459379242 | (37.7796461080741, -122.504459379242) | 11 | 6 | 2 | 55 | 26 | |||
| 17639 | 260223 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2201x 22nd Ave | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
| 17693 | 259347 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450x Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | ||||||||||||
| 17874 | 170661 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 301X San Juan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | Width 3ft | 6000920.86362 | 2092466.57168 | 37.7255666366796 | -122.439001572678 | (37.7255666366796, -122.439001572678) | 9 | 7 | 6 | 28861 | 25 | ||
| 17906 | 219682 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 250 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2019 12:00:00 AM | 3 | 3x3 | 6008245.78846 | 2097431.26822 | 37.7396126728914 | -122.414030905009 | (37.7396126728914, -122.414030905009) | 2 | 7 | 7 | 28859 | 2 | ||
| 18371 | 27202 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 302 Silver Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003502.33889 | 2093475.71167 | 37.7284840526724 | -122.430149591636 | (37.7284840526724, -122.430149591636) | 9 | 7 | 6 | 28861 | 5 | ||
| 19156 | 259400 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1649 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | ||||||||||||
| 19297 | 58021 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4026 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2017 12:07:00 PM | 3 | Permit Number 16988 | 5983218.6194 | 2106316.5419 | 37.7625717348083 | -122.50121971657 | (37.7625717348083, -122.50121971657) | 1 | 8 | 3 | 56 | 35 | ||
| 19327 | 262176 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 620 Rutland St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | ||||||||||||
| 19468 | 95897 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1700 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767603 | 5989075.8995 | 2103638.8826 | 37.7555618218669 | -122.480765700813 | (37.7555618218669, -122.480765700813) | 1 | 8 | 3 | 56 | 35 |
| 19579 | 71337 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 734 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5982620.59121 | 2110750.54443 | 37.7747110919712 | -122.503616418137 | (37.7747110919712, -122.503616418137) | 11 | 6 | 2 | 55 | 26 | |||
| 19808 | 207047 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 654 Joost Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997739.24902 | 2095008.66176 | 37.7323650733825 | -122.450183245677 | (37.7323650733825, -122.450183245677) | 9 | 7 | 4 | 59 | 40 | |||
| 19865 | 227149 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 530 Crescent Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007719.36141 | 2095678.53729 | 37.7347704774588 | -122.415726995823 | (37.7347704774588, -122.415726995823) | 2 | 7 | 7 | 28859 | 2 | |||
| 19993 | 182699 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1659 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5989088.7291 | 2103739.8915 | 37.7558399109499 | -122.480728726959 | (37.7558399109499, -122.480728726959) | 1 | 8 | 3 | 56 | 35 | |||
| 20055 | 206989 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1304 11th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5992723.56277 | 2106565.73006 | 37.7638095171187 | -122.468363979738 | (37.7638095171187, -122.468363979738) | 1 | 8 | 11 | 56 | 12 | |||
| 20503 | 129384 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 91 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008749.2926 | 2112454.62361 | 37.7808916402666 | -122.413352154294 | (37.7808916402666, -122.413352154294) | 7 | 10 | 9 | 28852 | 36 | |||
| 20622 | 251003 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 250 Point Lobos Ave | 2 | : | Tree | Private 2 | 3 | Width 3ft | 5981957.64195 | 2112675.64357 | 37.7799578490271 | -122.506052420011 | (37.7799578490271, -122.506052420011) | 11 | 6 | 2 | 55 | 26 | |||
| 20629 | 51532 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3155 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2005 12:00:00 AM | 2 | Permit Number 47834 | 5999712.30266 | 2115373.43094 | 37.78839440084 | -122.44482529806 | (37.78839440084, -122.44482529806) | 13 | 6 | 1 | 29490 | 27 | ||
| 20742 | 47826 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4350 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/13/2002 12:00:00 AM | 2 | Permit Number 45588 | 5982100.44481 | 2110341.38072 | 37.7735570529717 | -122.505385345551 | (37.7735570529717, -122.505385345551) | 11 | 6 | 2 | 55 | 26 | |
| 21393 | 87031 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52524 | 5994278.21944 | 2115255.72364 | 37.7877595955023 | -122.463617666169 | (37.7877595955023, -122.463617666169) | 11 | 6 | 1 | 54 | 11 | |
| 21404 | 129375 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 454 Walnut St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998637.858 | 2115126.26996 | 37.7876543864995 | -122.448524881439 | (37.7876543864995, -122.448524881439) | 13 | 6 | 1 | 54 | 31 | |||
| 21439 | 227577 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 18 Dehon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 6003773.27056 | 2106456.0684 | 37.7641404406581 | -122.430138593823 | (37.7641404406581, -122.430138593823) | 8 | 4 | 5 | 28862 | 3 | |||
| 21462 | 201816 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021143.08428 | 2093327.21502 | 37.7290596700622 | -122.369153577473 | (37.7290596700622, -122.369153577473) | 10 | 3 | 8 | 58 | 1 | ||
| 21599 | 129376 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2500 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6002240.59165 | 2116825.10443 | 37.7925242837291 | -122.436181762774 | (37.7925242837291, -122.436181762774) | 13 | 9 | 1 | 29490 | 27 | |||
| 21610 | 83554 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 117X Peru Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769748 | 6003920.58239 | 2093359.59743 | 37.7281889086723 | -122.428695428367 | (37.7281889086723, -122.428695428367) | 9 | 7 | 6 | 28861 | 5 |
| 21651 | 27207 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 302 Silver Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003623.95003 | 2093470.28644 | 37.7284760433174 | -122.429728788952 | (37.7284760433174, -122.429728788952) | 9 | 7 | 6 | 28861 | 5 | ||
| 21976 | 26983 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1395 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2009 12:00:00 AM | 3 | 3X3 | 6009622.93574 | 2094432.56882 | 37.7314561402837 | -122.409057769215 | (37.7314561402837, -122.409057769215) | 9 | 3 | 7 | 309 | 28 | ||
| 22543 | 227116 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 133 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6006472.0378 | 2105330.58155 | 37.761202600143 | -122.420724416907 | (37.761202600143, -122.420724416907) | 2 | 4 | 7 | 28859 | 19 | |||
| 22554 | 88615 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 521 03rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51567 | 5994972.63478 | 2111950.42136 | 37.7787241118896 | -122.460975481067 | (37.7787241118896, -122.460975481067) | 11 | 6 | 2 | 54 | 11 | |
| 22726 | 191234 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1600 Newhall St | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6014153.11677 | 2095403.12134 | 37.7343738170818 | -122.393463850493 | (37.7343738170818, -122.393463850493) | 10 | 3 | 8 | 58 | 1 | |||
| 22775 | 27008 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1430 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1999 12:00:00 AM | 3 | 3X3 | 6009940.18408 | 2094497.75014 | 37.7316528813564 | -122.407965571349 | (37.7316528813564, -122.407965571349) | 10 | 3 | 7 | 309 | 28 | ||
| 23262 | 51411 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1578 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51340 | 5989038.1128 | 2104597.9638 | 37.7581930050331 | -122.480966595693 | (37.7581930050331, -122.480966595693) | 1 | 8 | 3 | 56 | 35 | |
| 23429 | 176881 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3303 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011991.79808 | 2090250.44255 | 37.7201052985 | -122.400574440964 | (37.7201052985, -122.400574440964) | 10 | 7 | 8 | 309 | 28 | |||
| 24170 | 41808 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Anzavista Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 3 | Permit Number 42201 | 5999945.6987 | 2112165.7027 | 37.7796001259133 | -122.443787242166 | (37.7796001259133, -122.443787242166) | 15 | 5 | 1 | 29490 | 16 | |
| 24569 | 176914 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1300 Silver Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009346.09367 | 2094283.90387 | 37.7310324255937 | -122.41000437762 | (37.7310324255937, -122.41000437762) | 9 | 3 | 7 | 309 | 28 | |||
| 24739 | 84659 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 187 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5996845.0781 | 2111686.6666 | 37.7781074773999 | -122.454478948332 | (37.7781074773999, -122.454478948332) | 15 | 6 | 2 | 54 | 16 | |||
| 24824 | 227123 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 483 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002011.92527 | 2100876.50462 | 37.7487203851357 | -122.435831325762 | (37.7487203851357, -122.435831325762) | 2 | 4 | 5 | 28862 | 22 | |||
| 25168 | 83917 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1484 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50173 | 5981576.71105327 | 2104986.37444115 | 37.7588229209977 | -122.506799717054 | (37.7588229209977, -122.506799717054) | 1 | 8 | 3 | 56 | 35 | |
| 25262 | 227146 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 266 Rivoli St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5997461.46496 | 2105891.36034 | 37.7622303876487 | -122.451928448466 | (37.7622303876487, -122.451928448466) | 15 | 5 | 11 | 29492 | 9 | |||
| 25283 | 3523 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 201X Cargo Way | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 11:28:00 AM | 3 | 3X3 | 6018216.35215 | 2097958.49501 | 37.7416152904271 | -122.379593238756 | (37.7416152904271, -122.379593238756) | 10 | 3 | 8 | 58 | 1 | ||
| 25340 | 176908 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1053 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6007885.16277 | 2093698.95374 | 37.7293442892945 | -122.415013692231 | (37.7293442892945, -122.415013692231) | 9 | 3 | 7 | 309 | 28 | |||
| 25424 | 176901 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 167 Madison St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6005600.43917 | 2092849.05844 | 37.7268820102711 | -122.422851823466 | (37.7268820102711, -122.422851823466) | 9 | 7 | 7 | 309 | 5 | |||
| 25751 | 182700 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1651 Moraga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5989102.9459 | 2103739.8915 | 37.7558407372502 | -122.480679561224 | (37.7558407372502, -122.480679561224) | 1 | 8 | 3 | 56 | 35 | |||
| 26064 | 227132 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 200 Portola Dr | 5 | : | Tree | Private 2 | 3 | Width 3ft | 5999561.91472 | 2100471.96222 | 37.7474701323504 | -122.444274349099 | (37.7474701323504, -122.444274349099) | 2 | 4 | 5 | 63 | 38 | |||
| 26675 | 207018 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 466 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5997114.73821 | 2093838.00202 | 37.7291149630685 | -122.452257872798 | (37.7291149630685, -122.452257872798) | 9 | 7 | 4 | 28861 | 40 | |||
| 26995 | 227570 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 287 Hartford St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002738.3349 | 2104276.75984 | 37.7580979146911 | -122.433562376711 | (37.7580979146911, -122.433562376711) | 2 | 4 | 5 | 28862 | 3 | |||
| 27064 | 182564 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2122 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | Permit Number 783239 | 5989402.8067 | 2098365.7306 | 37.7411021315374 | -122.479249432397 | (37.7411021315374, -122.479249432397) | 1 | 8 | 3 | 29491 | 35 | ||
| 27543 | 83558 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 483 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52321 | 6001949.50225 | 2090800.06366 | 37.7210492547906 | -122.435326507535 | (37.7210492547906, -122.435326507535) | 9 | 7 | 6 | 28861 | 5 | |
| 27595 | 63507 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 574 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/1987 12:00:00 AM | 4 | Permit Number 24113 | 6001588.8915 | 2090307.92108 | 37.7196774559426 | -122.436537823274 | (37.7196774559426, -122.436537823274) | 9 | 7 | 6 | 28861 | 5 | ||
| 27719 | 250553 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 130 El Camino Del Mar | 1 | : | Tree | Private 2 | 8 | Width 4ft | 5988175.48547 | 2115367.76095 | 37.7877136895948 | -122.484739928202 | (37.7877136895948, -122.484739928202) | 11 | 6 | 1 | 55 | 33 | |||
| 28327 | 162331 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 26 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:09:00 PM | 3 | Width 0ft | 5996526.61739 | 2090076.51041 | 37.7187530886569 | -122.454019490912 | (37.7187530886569, -122.454019490912) | 9 | 8 | 6 | 28861 | 24 | ||
| 28445 | 3667 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 103 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/02/2017 03:19:00 PM | 3 | 3X3 | 6017116.62756 | 2098928.27448 | 37.7442173915214 | -122.383463247242 | (37.7442173915214, -122.383463247242) | 10 | 3 | 8 | 58 | 1 | ||
| 28544 | 159338 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 517 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:04:00 AM | 3 | Width 0ft | 5998112.9338 | 2087183.20699 | 37.7108995709325 | -122.448328017142 | (37.7108995709325, -122.448328017142) | 9 | 7 | 6 | 28861 | 25 | ||
| 28945 | 157260 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1059 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781960 | 5995594.16193 | 2098091.79633 | 37.7407076181758 | -122.457822284089 | (37.7407076181758, -122.457822284089) | 9 | 7 | 4 | 59 | 40 | |
| 29101 | 176889 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 277 Athens St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004392.5622 | 2091665.65248 | 37.7235644112504 | -122.426943181195 | (37.7235644112504, -122.426943181195) | 9 | 7 | 6 | 28861 | 5 | |||
| 29174 | 183692 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1341 42nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2017 12:00:00 AM | 3 | Width 0ft | 5983047.3598 | 2105912.7714 | 37.761453037237 | -122.501782156698 | (37.761453037237, -122.501782156698) | 1 | 8 | 3 | 56 | 35 | ||
| 29195 | 34680 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1904 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52535 | 6003705.30059 | 2119372.14104 | 37.7996008996227 | -122.431295719127 | (37.7996008996227, -122.431295719127) | 13 | 9 | 1 | 57 | 17 | |
| 29210 | 176917 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 9 | Median : Yard | Tree | DPW 1 | 3 | 6001514.03799 | 2088123.65893 | 37.7136757052349 | -122.436640299224 | (37.7136757052349, -122.436640299224) | 9 | 7 | 6 | 28861 | 5 | ||||
| 29272 | 129388 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2507 Larkin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006666.99925 | 2119949.93729 | 37.8013547799481 | -122.421088199869 | (37.8013547799481, -122.421088199869) | 5 | 9 | 1 | 28858 | 32 | |||
| 29694 | 248531 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 800 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997658.268 | 2107761.8815 | 37.7673776340728 | -122.451382700243 | (37.7673776340728, -122.451382700243) | 15 | 5 | 11 | 29492 | 9 | |||
| 29761 | 176907 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 769 Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006492.03782 | 2093629.408 | 37.7290749477448 | -122.419824929392 | (37.7290749477448, -122.419824929392) | 9 | 7 | 7 | 309 | 5 | |||
| 29952 | 137671 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 756 LYON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000049.6788 | 2111547.4906 | 37.7779086039439 | -122.443383113797 | (37.7779086039439, -122.443383113797) | 15 | 5 | 11 | 29490 | 16 | |||
| 30044 | 254525 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 09/07/2012 12:00:00 AM | 3x3 | 5982400 | 2105639 | 37.7606632919303 | -122.504000789622 | (37.7606632919303, -122.504000789622) | 1 | 8 | 3 | 56 | 35 | ||
| 30229 | 251001 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 232 Point Lobos Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5982033.34511 | 2112665.09757 | 37.7799333487875 | -122.505789751407 | (37.7799333487875, -122.505789751407) | 11 | 6 | 2 | 55 | 26 | |||
| 30373 | 184599 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1795 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983770.6594 | 2102984.6576 | 37.7534557168171 | -122.499064248064 | (37.7534557168171, -122.499064248064) | 1 | 8 | 3 | 56 | 35 | |||
| 30385 | 181018 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 197 Rolph St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 11:31:00 AM | 3 | Width 4ft | 6001005.57228 | 2088396.04691 | 37.7143947132291 | -122.43841724089 | (37.7143947132291, -122.43841724089) | 9 | 7 | 6 | 28861 | 5 | ||
| 30581 | 252889 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 301x Howth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2019 08:45:00 AM | 3 | 3x3 | 5997131 | 2090234 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | 9 | 8 | 6 | 28861 | 24 | ||
| 30582 | 183121 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2327 41st Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983581.7952 | 2099373.3538 | 37.7435289932417 | -122.49945051311 | (37.7435289932417, -122.49945051311) | 1 | 8 | 3 | 29491 | 35 | |||
| 30613 | 227099 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 75 Montcalm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010635.77556 | 2100089.10311 | 37.7470444571367 | -122.405954501114 | (37.7470444571367, -122.405954501114) | 2 | 7 | 7 | 28859 | 2 | |||
| 30949 | 176888 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 13 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002306.40089 | 2092528.29831 | 37.7258148612434 | -122.434216303453 | (37.7258148612434, -122.434216303453) | 9 | 7 | 6 | 28861 | 25 | |||
| 31518 | 201833 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 350 Friedell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020733.63229 | 2092847.87799 | 37.7277210345753 | -122.370535976659 | (37.7277210345753, -122.370535976659) | 10 | 3 | 8 | 58 | 1 | |
| 31525 | 251509 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 51 Commonwealth Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996476 | 2114178 | 37.7849268449454 | -122.455935865939 | (37.7849268449454, -122.455935865939) | 11 | 6 | 1 | 54 | 31 | ||||
| 31538 | 113355 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2 Point Lobos Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 3X3 | 5982766.03998 | 2112575.4615 | 37.7797303315274 | -122.503248436763 | (37.7797303315274, -122.503248436763) | 11 | 6 | 2 | 55 | 26 | |||
| 31711 | 227556 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Seward St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000674.34081 | 2104608.13246 | 37.7588904593411 | -122.440724304978 | (37.7588904593411, -122.440724304978) | 2 | 4 | 5 | 28862 | 38 | |||
| 31769 | 227126 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1689 Noe St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 4ft | 6003395.21055 | 2098417.4445 | 37.742046857971 | -122.430872467617 | (37.742046857971, -122.430872467617) | 2 | 7 | 5 | 63 | 22 | |||
| 31921 | 191247 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1453 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 6016461.47366 | 2096825.22247 | 37.7384066073881 | -122.385582111127 | (37.7384066073881, -122.385582111127) | 10 | 3 | 8 | 58 | 1 | |||
| 32050 | 92441 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1368 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52832 | 5982163.8853 | 2105798.2136 | 37.7610865595393 | -122.504829187778 | (37.7610865595393, -122.504829187778) | 1 | 8 | 3 | 56 | 35 |
| 32250 | 90735 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4519 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981584.56948 | 2110265.78848 | 37.7733191284439 | -122.507164194881 | (37.7733191284439, -122.507164194881) | 11 | 6 | 2 | 55 | 26 | ||
| 32976 | 207036 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1645 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5990861.16949 | 2098351.90974 | 37.7411487751831 | -122.474205983836 | (37.7411487751831, -122.474205983836) | 1 | 8 | 4 | 29491 | 40 | |||
| 33310 | 27006 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1420 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/13/1999 12:00:00 AM | 3 | 3X3 | 6009885.43307 | 2094479.90043 | 37.73160080432 | -122.408153598922 | (37.73160080432, -122.408153598922) | 10 | 3 | 7 | 309 | 28 | ||
| 33446 | 191235 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1600 Newhall St | 2 | : | Tree | Private 2 | 3 | Width 2ft | 6014141.54444 | 2095385.83675 | 37.7343257141509 | -122.393502650848 | (37.7343257141509, -122.393502650848) | 10 | 3 | 8 | 58 | 1 | |||
| 33674 | 27102 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 669 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2009 12:00:00 AM | 3 | 3X3 | 6005822.11431 | 2093583.57584 | 37.7289113394767 | -122.422137656546 | (37.7289113394767, -122.422137656546) | 9 | 7 | 6 | 28861 | 5 | ||
| 34235 | 207024 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 85 Williar Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997067.34432 | 2090557.59428 | 37.7201050223995 | -122.452185117661 | (37.7201050223995, -122.452185117661) | 9 | 8 | 6 | 28861 | 24 | |||
| 34355 | 80237 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1675 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5985295.5529 | 2103816.7715 | 37.7558298048279 | -122.493852234736 | (37.7558298048279, -122.493852234736) | 1 | 8 | 3 | 56 | 35 | |||
| 34356 | 90275 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4300X Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982191.02218 | 2111027.01163 | 37.775444924896 | -122.505122852448 | (37.775444924896, -122.505122852448) | 11 | 6 | 2 | 55 | 26 | ||
| 34441 | 227139 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 280 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997445.29759 | 2106455.57152 | 37.7637786424842 | -122.452025073424 | (37.7637786424842, -122.452025073424) | 15 | 5 | 11 | 29492 | 9 | |||
| 34639 | 93188 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1675 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/18/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53196 | 6014934.44131 | 2097265.12572 | 37.7395298812852 | -122.39089262491 | (37.7395298812852, -122.39089262491) | 10 | 3 | 8 | 58 | 1 | |
| 35156 | 26976 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 504X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3 | 3x3 | 6004631.39194 | 2093482.01374 | 37.7285652398765 | -122.426246843332 | (37.7285652398765, -122.426246843332) | 9 | 7 | 6 | 28861 | 5 | ||
| 35535 | 106607 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1392 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/12/2014 12:00:00 AM | Permit Number 770777 | 5989327.7 | 2105878.6 | 37.7617261163081 | -122.480058809907 | (37.7617261163081, -122.480058809907) | 1 | 8 | 3 | 56 | 35 | ||
| 35620 | 227157 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3330 20th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007941.59674 | 2104465.0078 | 37.7589086508255 | -122.41558053851 | (37.7589086508255, -122.41558053851) | 2 | 4 | 7 | 28859 | 19 | |||
| 35644 | 117055 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 762 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2016 12:00:00 AM | 3 | Permit Number 778404 | 5985439.6 | 2110687.7 | 37.7747038750392 | -122.493860404631 | (37.7747038750392, -122.493860404631) | 11 | 6 | 2 | 55 | 26 | |||
| 35869 | 140696 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 162 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5997358.0622 | 2109907.9029 | 37.7732528619693 | -122.452575957146 | (37.7732528619693, -122.452575957146) | 15 | 5 | 11 | 29492 | 16 | |||
| 36433 | 227134 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 200 Portola Dr | 10 | : | Tree | Private 2 | 3 | Width 3ft | 5999484.90108 | 2100375.94772 | 37.747202105595 | -122.444533756725 | (37.747202105595, -122.444533756725) | 2 | 4 | 5 | 63 | 38 | |||
| 36462 | 227586 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 494 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003707.36504 | 2095900.15245 | 37.7351526308975 | -122.429613645169 | (37.7351526308975, -122.429613645169) | 2 | 7 | 5 | 63 | 7 | |||
| 36793 | 95431 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1938 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767296 | 5988810.2856 | 2102122.1786 | 37.7513819161329 | -122.481573187512 | (37.7513819161329, -122.481573187512) | 1 | 8 | 3 | 29491 | 35 |
| 37185 | 83309 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1519 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50153 | 5982468.6778 | 2104743.2959 | 37.7582079811023 | -122.503696933051 | (37.7582079811023, -122.503696933051) | 1 | 8 | 3 | 56 | 35 | |
| 37187 | 227140 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 266 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997729.62744 | 2105927.06337 | 37.7623437750648 | -122.451003555094 | (37.7623437750648, -122.451003555094) | 15 | 5 | 11 | 29492 | 9 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );