trees
334 rows where qSpecies_id = 59 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 126030 | 140081 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104 Saint Joseph's Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6000726.184 | 2112472.3974 | 37.7804867177527 | -122.441109224562 | (37.7804867177527, -122.441109224562) | 15 | 5 | 1 | 29490 | 41 | |||
| 135590 | 195990 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6018348.89198 | 2099575.3229 | 37.7460620845153 | -122.379247231793 | (37.7460620845153, -122.379247231793) | 10 | 3 | 8 | 58 | 1 | ||||
| 136935 | 196026 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 10ft | 6017039.21913 | 2097067.45785 | 37.7391036871735 | -122.383601388517 | (37.7391036871735, -122.383601388517) | 10 | 3 | 8 | 58 | 1 | |||
| 138606 | 135664 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5996336.60886 | 2114624.27331 | 37.7861441909595 | -122.456450393471 | (37.7861441909595, -122.456450393471) | 11 | 6 | 1 | 54 | 31 | |||
| 140069 | 212849 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1201 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992374.69215 | 2098410.70315 | 37.7413977704887 | -122.468977090726 | (37.7413977704887, -122.468977090726) | 1 | 8 | 4 | 59 | 40 | |||
| 145439 | 116093 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
| 147228 | 244262 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005612.7252 | 2110055.5318 | 37.7741277163216 | -122.424032433594 | (37.7741277163216, -122.424032433594) | 7 | 9 | 11 | 28852 | 10 | |||
| 153309 | 119768 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 173532 | 195957 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 3 | Back Yard : Yard | Tree | Private 2 | 12 | 6015667.37966 | 2100340.53223 | 37.7480149542209 | -122.388573036834 | (37.7480149542209, -122.388573036834) | 10 | 3 | 8 | 58 | 1 | ||||
| 191905 | 248123 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 3 | Front Yard : Yard | Tree | Private 2 | 13 | 6010392.06783 | 2099413.07866 | 37.7451746083214 | -122.406749590819 | (37.7451746083214, -122.406749590819) | 2 | 7 | 7 | 28859 | 2 | ||||
| 66019 | 249894 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 230 Greenwich St | 30 | Back Yard : Yard | Tree | Private 2 | 24 | Width 0ft | 6011403.76038 | 2120447.63681 | 37.8029872221404 | -122.404731874586 | (37.8029872221404, -122.404731874586) | 3 | 1 | 10 | 28860 | 6 | |||
| 98514 | 249895 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 230 Greenwich St | 31 | Back Yard : Yard | Tree | Private 2 | 18 | Width 0ft | 6011395.76102 | 2120447.38073 | 37.8029860719045 | -122.404759538639 | (37.8029860719045, -122.404759538639) | 3 | 1 | 10 | 28860 | 6 | |||
| 109416 | 212850 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 32 Malta Dr | 32 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 3ft | 5999489.82188 | 2096117.1264 | 37.7355086796695 | -122.444210754429 | (37.7355086796695, -122.444210754429) | 9 | 7 | 4 | 63 | 40 | |||
| 142161 | 249896 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 230 Greenwich St | 32 | Back Yard : Yard | Tree | Private 2 | 24 | Width 0ft | 6011386.30387 | 2120437.51769 | 37.8029584618196 | -122.404791570676 | (37.8029584618196, -122.404791570676) | 3 | 1 | 10 | 28860 | 6 | |||
| 413 | 119686 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 10567 | 263621 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 4 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
| 16277 | 119724 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 21347 | 201996 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1799 Carroll Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6013312.67339 | 2092499.74696 | 37.7263550129554 | -122.396166145968 | (37.7263550129554, -122.396166145968) | 10 | 3 | 8 | 58 | 1 | ||||
| 32582 | 196000 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6016029.90141 | 2110710.35403 | 37.7765083446095 | -122.38804297462 | (37.7765083446095, -122.38804297462) | 14 | 3 | 9 | 310 | 20 | ||||
| 39892 | 244430 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005657.927 | 2109705.6102 | 37.7731694680478 | -122.423851185605 | (37.7731694680478, -122.423851185605) | 7 | 9 | 11 | 28852 | 10 | |||
| 40830 | 248124 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 4 | Front Yard : Yard | Tree | Private 2 | 10 | 6010394.26479 | 2099420.04988 | 37.7451938726969 | -122.406742485274 | (37.7451938726969, -122.406742485274) | 2 | 7 | 7 | 28859 | 2 | ||||
| 44966 | 244263 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005610.4338 | 2110073.0988 | 37.7741758216851 | -122.424041609468 | (37.7741758216851, -122.424041609468) | 7 | 9 | 11 | 28852 | 10 | |||
| 64778 | 109377 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 4 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
| 67742 | 246560 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 4 | Median : Yard | Tree | DPW 1 | 5 | Width 7ft | 6005720.56075 | 2109380.70244 | 37.772280885298 | -122.423611422347 | (37.772280885298, -122.423611422347) | 7 | 9 | 11 | 28852 | 10 | |||
| 73440 | 116094 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
| 74379 | 246918 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 845 Shrader St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 3ft | 5997638.10514 | 2107510.95773 | 37.7666875068428 | -122.451434340243 | (37.7666875068428, -122.451434340243) | 15 | 5 | 11 | 29492 | 9 | |||
| 78015 | 135666 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3001 Divisadero St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 42 | Width 9ft | 6000472.49775 | 2118651.89467 | 37.7974395562567 | -122.442430617479 | (37.7974395562567, -122.442430617479) | 13 | 9 | 1 | 57 | 17 | |||
| 83859 | 139060 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1455 Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 39 | Width 0ft | 5999670.4186 | 2113895.7324 | 37.7843346353185 | -122.444863945857 | (37.7843346353185, -122.444863945857) | 15 | 6 | 11 | 29490 | 31 | |||
| 89186 | 248114 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 4 | Side Yard : Yard | Tree | Private 2 | 15 | 6010381.0463 | 2099434.05906 | 37.7452315992509 | -122.406789179902 | (37.7452315992509, -122.406789179902) | 2 | 7 | 7 | 28859 | 2 | ||||
| 93753 | 195995 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2101 Newcomb Ave | 4 | Side Yard : Yard | Tree | Private 2 | 23 | Width 3ft | 6012483.54441 | 2097715.89022 | 37.7406312890986 | -122.399398452383 | (37.7406312890986, -122.399398452383) | 10 | 3 | 8 | 58 | 1 | |||
| 97525 | 234890 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 4 | Front Yard : Yard | Tree | Private 2 | 14 | 6010623.85334 | 2100666.44158 | 37.7486290355994 | -122.406036393361 | (37.7486290355994, -122.406036393361) | 2 | 7 | 7 | 28859 | 2 | ||||
| 99139 | 195989 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6018358.23149 | 2099573.02507 | 37.7460562901585 | -122.379214777067 | (37.7460562901585, -122.379214777067) | 10 | 3 | 8 | 58 | 1 | ||||
| 111134 | 234874 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | 6010703.27515 | 2100855.87105 | 37.7491536092595 | -122.40577509356 | (37.7491536092595, -122.40577509356) | 10 | 4 | 7 | 28859 | 19 | ||||
| 113742 | 119769 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 150253 | 234896 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 10ft | 6007240.7393 | 2101963.94083 | 37.7520018736867 | -122.417827151095 | (37.7520018736867, -122.417827151095) | 2 | 4 | 7 | 28859 | 19 | |||
| 153530 | 196036 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 6017046.41048 | 2096978.72928 | 37.738860453849 | -122.383570348389 | (37.738860453849, -122.383570348389) | 10 | 3 | 8 | 58 | 1 | |||
| 154598 | 135665 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 3ft | 5996326.40952 | 2114621.95963 | 37.7861372526689 | -122.456485512902 | (37.7861372526689, -122.456485512902) | 11 | 6 | 1 | 54 | 31 | |||
| 166467 | 125725 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | Width 4ft | 6003533.81623 | 2118024.94741 | 37.7958921341649 | -122.431792874238 | (37.7958921341649, -122.431792874238) | 13 | 9 | 1 | 57 | 17 | |||
| 171267 | 96981 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
| 176690 | 195958 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 4 | Back Yard : Yard | Tree | Private 2 | 10 | 6015649.24062 | 2100340.89834 | 37.7480149542299 | -122.388635787013 | (37.7480149542299, -122.388635787013) | 10 | 3 | 8 | 58 | 1 | ||||
| 179780 | 234900 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6009696.65795 | 2096435.22954 | 37.7369591476365 | -122.40894414348 | (37.7369591476365, -122.40894414348) | 10 | 7 | 7 | 28859 | 2 | ||||
| 12617 | 249797 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 199 Chestnut St | 5 | Front Yard : Yard | Tree | Private 2 | 13 | Width 0ft | 6010839.41961 | 2121064.72571 | 37.8046500380318 | -122.406728311085 | (37.8046500380318, -122.406728311085) | 3 | 1 | 10 | 308 | 23 | |||
| 19786 | 248125 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 5 | Front Yard : Yard | Tree | Private 2 | 7 | 6010397.04877 | 2099427.00914 | 37.7452131370768 | -122.406733349058 | (37.7452131370768, -122.406733349058) | 2 | 7 | 7 | 28859 | 2 | ||||
| 55799 | 195988 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6018362.60368 | 2099564.59582 | 37.7460333862374 | -122.379199073078 | (37.7460333862374, -122.379199073078) | 10 | 3 | 8 | 58 | 1 | ||||
| 61534 | 195959 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 5 | Back Yard : Yard | Tree | Private 2 | 10 | 6015616.60441 | 2100338.74984 | 37.7480072461368 | -122.388748492749 | (37.7480072461368, -122.388748492749) | 10 | 3 | 8 | 58 | 1 | ||||
| 62466 | 119770 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 66581 | 234875 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6010693.4536 | 2100854.39807 | 37.7491490155229 | -122.405808953037 | (37.7491490155229, -122.405808953037) | 10 | 4 | 7 | 28859 | 19 | ||||
| 76548 | 234891 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 5 | Front Yard : Yard | Tree | Private 2 | 12 | 6010619.31212 | 2100642.55964 | 37.7485632070257 | -122.406050414705 | (37.7485632070257, -122.406050414705) | 2 | 7 | 7 | 28859 | 2 | ||||
| 80147 | 116095 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
| 80514 | 248115 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 5 | Side Yard : Yard | Tree | Private 2 | 7 | 6010382.66989 | 2099427.30215 | 37.7452131370921 | -122.406783089664 | (37.7452131370921, -122.406783089664) | 2 | 7 | 7 | 28859 | 2 | ||||
| 83892 | 244431 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6005656.5567 | 2109717.2576 | 37.7732013716398 | -122.423856754026 | (37.7732013716398, -122.423856754026) | 7 | 9 | 11 | 28852 | 10 | |||
| 84264 | 246561 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 5 | Median : Yard | Tree | DPW 1 | 8 | Width 7ft | 6005718.25772 | 2109387.68034 | 37.7722999149342 | -122.423619884948 | (37.7722999149342, -122.423619884948) | 7 | 9 | 11 | 28852 | 10 | |||
| 91372 | 96982 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 41 | Permit Number 25529 | 6003530.13563 | 2118059.26209 | 37.7959861448054 | -122.431808061115 | (37.7959861448054, -122.431808061115) | 13 | 9 | 1 | 57 | 17 | |||
| 97183 | 201993 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1799 Carroll Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6013314.35101 | 2092488.44605 | 37.7263240762942 | -122.396159554816 | (37.7263240762942, -122.396159554816) | 10 | 3 | 8 | 58 | 1 | ||||
| 115902 | 195996 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2101 Newcomb Ave | 5 | Side Yard : Yard | Tree | Private 2 | 14 | Width 3ft | 6012499.27572 | 2097703.95349 | 37.7405993901482 | -122.399343221431 | (37.7405993901482, -122.399343221431) | 10 | 3 | 8 | 58 | 1 | |||
| 122830 | 234901 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6009690.97834 | 2096436.62736 | 37.7369626675976 | -122.408963879105 | (37.7369626675976, -122.408963879105) | 10 | 7 | 7 | 28859 | 2 | ||||
| 124042 | 196027 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6017034.20589 | 2097061.66689 | 37.7390875092666 | -122.383618319135 | (37.7390875092666, -122.383618319135) | 10 | 3 | 8 | 58 | 1 | |||
| 127892 | 244264 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005607.3787 | 2110087.6108 | 37.7742154956389 | -122.424053209833 | (37.7742154956389, -122.424053209833) | 7 | 9 | 11 | 28852 | 10 | |||
| 135794 | 119725 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 137112 | 196001 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6016008.12939 | 2110708.52586 | 37.7765021186104 | -122.388118163334 | (37.7765021186104, -122.388118163334) | 14 | 3 | 9 | 310 | 20 | ||||
| 137889 | 109378 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 5 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
| 145827 | 6098 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 106X Saint Joseph's Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6000733.8426241 | 2112435.5369559 | 37.7803859446112 | -122.44108008458 | (37.7803859446112, -122.44108008458) | 15 | 5 | 1 | 29490 | 41 | |||
| 150059 | 249897 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1497 Montgomery St | 5 | Side Yard : Yard | Tree | Private 2 | 20 | Width 0ft | 6011384.61876 | 2120458.08201 | 37.8030148322229 | -122.404798850701 | (37.8030148322229, -122.404798850701) | 3 | 1 | 10 | 28860 | 6 | |||
| 154261 | 140083 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Saint Joseph's Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 6000722.7998 | 2112497.1022 | 37.7805543580623 | -122.441122705034 | (37.7805543580623, -122.441122705034) | 15 | 5 | 1 | 29490 | 41 | |||
| 159585 | 119687 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 24737 | 246562 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 6 | Median : Yard | Tree | DPW 1 | 16 | Width 7ft | 6005708.50416 | 2109443.88838 | 37.7724536981194 | -122.423657620518 | (37.7724536981194, -122.423657620518) | 7 | 9 | 11 | 28852 | 10 | |||
| 27833 | 249798 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 199 Chestnut St | 6 | Front Yard : Yard | Tree | Private 2 | 14 | Width 0ft | 6010832.73906 | 2121063.1197 | 37.8046452545423 | -122.406751316639 | (37.8046452545423, -122.406751316639) | 3 | 1 | 10 | 308 | 23 | |||
| 59791 | 96983 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800X Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 38 | Permit Number 25529 | 6003522.34271 | 2118089.29041 | 37.796068153086 | -122.431837171257 | (37.796068153086, -122.431837171257) | 13 | 9 | 1 | 57 | 17 | |||
| 72063 | 196028 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 10ft | 6017030.63637 | 2097056.65947 | 37.7390735625998 | -122.383630312507 | (37.7390735625998, -122.383630312507) | 10 | 3 | 8 | 58 | 1 | |||
| 86942 | 103067 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 255 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2014 12:00:00 AM | 3 | 6x6 | Permit Number 769997 | 6012256.1 | 2118721.6 | 37.7982955442476 | -122.401660929382 | (37.7982955442476, -122.401660929382) | 3 | 1 | 10 | 28860 | 6 | |
| 93639 | 91056 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 750 FOLSOM ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x4 | 6012569 | 2113092 | 37.7828554456154 | -122.400182606689 | (37.7828554456154, -122.400182606689) | 6 | 2 | 9 | 28853 | 34 | ||||
| 98268 | 196037 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6017049.14343 | 2096982.73756 | 37.7388716108342 | -122.383561177999 | (37.7388716108342, -122.383561177999) | 10 | 3 | 8 | 58 | 1 | |||
| 99978 | 234895 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3255x 24th St | 6 | Side Yard : Cutout | Tree | Private 2 | 40 | Width 10ft | 6007298 | 2102020 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | 2 | 4 | 7 | 28859 | 19 | |||
| 104444 | 248116 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 6 | Side Yard : Yard | Tree | Private 2 | 9 | 6010379.57479 | 2099419.47211 | 37.745191464328 | -122.406793240314 | (37.745191464328, -122.406793240314) | 2 | 7 | 7 | 28859 | 2 | ||||
| 111007 | 234892 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 6 | Front Yard : Yard | Tree | Private 2 | 18 | 6010653.55518 | 2100656.49907 | 37.7486033968442 | -122.40593298392 | (37.7486033968442, -122.40593298392) | 2 | 7 | 7 | 28859 | 2 | ||||
| 112727 | 244265 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6005602.0322 | 2110112.8157 | 37.7742844003359 | -122.42407349717 | (37.7742844003359, -122.42407349717) | 7 | 9 | 11 | 28852 | 10 | |||
| 119609 | 119771 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 126751 | 119726 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 145571 | 248126 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 6 | Front Yard : Yard | Tree | Private 2 | 6 | 6010387.78953 | 2099433.6295 | 37.7452307970734 | -122.406765832574 | (37.7452307970734, -122.406765832574) | 2 | 7 | 7 | 28859 | 2 | ||||
| 150696 | 244432 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6005649.0202 | 2109761.1065 | 37.7733213446724 | -122.423885942412 | (37.7733213446724, -122.423885942412) | 7 | 9 | 11 | 28852 | 10 | |||
| 152488 | 234902 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6009698.63441 | 2096418.94153 | 37.7369145349811 | -122.408936161078 | (37.7369145349811, -122.408936161078) | 10 | 7 | 7 | 28859 | 2 | ||||
| 154885 | 116096 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
| 176786 | 195987 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6018466.53487 | 2099573.76457 | 37.7460642923433 | -122.378840325441 | (37.7460642923433, -122.378840325441) | 10 | 3 | 8 | 58 | 1 | ||||
| 185058 | 196002 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6015985.51722 | 2110706.09628 | 37.7764941946745 | -122.388196216398 | (37.7764941946745, -122.388196216398) | 14 | 3 | 9 | 310 | 20 | ||||
| 189536 | 119688 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 192137 | 195960 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 6 | Back Yard : Yard | Tree | Private 2 | 8 | 6015597.7328 | 2100337.72732 | 37.7480033925609 | -122.388813679213 | (37.7480033925609, -122.388813679213) | 10 | 3 | 8 | 58 | 1 | ||||
| 12956 | 119689 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 13169 | 20051 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 100 STAIRWAY52 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | |||||||||||||
| 19126 | 234903 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6009692.65358 | 2096419.54828 | 37.7369158659624 | -122.408956882348 | (37.7369158659624, -122.408956882348) | 10 | 7 | 7 | 28859 | 2 | ||||
| 23378 | 234893 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 7 | Front Yard : Yard | Tree | Private 2 | 17 | 6010664.01336 | 2100659.8191 | 37.7486130978165 | -122.405897053323 | (37.7486130978165, -122.405897053323) | 2 | 7 | 7 | 28859 | 2 | ||||
| 28533 | 195986 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6018468.61509 | 2099561.76349 | 37.7460314544851 | -122.378832298987 | (37.7460314544851, -122.378832298987) | 10 | 3 | 8 | 58 | 1 | ||||
| 35055 | 196038 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6017052.09274 | 2096987.35134 | 37.7388844423585 | -122.38355130167 | (37.7388844423585, -122.38355130167) | 10 | 3 | 8 | 58 | 1 | |||
| 37570 | 248117 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 7 | Side Yard : Yard | Tree | Private 2 | 6 | 6010378.29952 | 2099414.5285 | 37.7451778188963 | -122.406797301657 | (37.7451778188963, -122.406797301657) | 2 | 7 | 7 | 28859 | 2 | ||||
| 75461 | 119727 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 85065 | 244266 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6005600.5046 | 2110125.0362 | 37.7743178686238 | -122.424079650665 | (37.7743178686238, -122.424079650665) | 7 | 9 | 11 | 28852 | 10 | |||
| 106853 | 119772 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 117263 | 244433 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6005647.6499 | 2109776.1795 | 37.7733626541324 | -122.423891754495 | (37.7733626541324, -122.423891754495) | 7 | 9 | 11 | 28852 | 10 | |||
| 121735 | 196003 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015962.95079 | 2110705.93329 | 37.7764924967751 | -122.388274269443 | (37.7764924967751, -122.388274269443) | 14 | 3 | 9 | 310 | 20 | ||||
| 123430 | 96984 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
| 126542 | 248127 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 7 | Front Yard : Yard | Tree | Private 2 | 18 | 6010399.6226 | 2099438.06548 | 37.7452436393873 | -122.406725228187 | (37.7452436393873, -122.406725228187) | 2 | 7 | 7 | 28859 | 2 |
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) );