trees
7,157 rows where qSpecies_id = 36 sorted by SiteOrder descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 352 | 98788 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6003538.80686 | 2121150.47161 | 37.804474295204 | -122.431998903525 | (37.804474295204, -122.431998903525) | 13 | 9 | 1 | 57 | 17 | |||
| 2676 | 194649 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1800 20th St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 6012472.71707 | 2104722.42647 | 37.759869121389 | -122.399927785234 | (37.759869121389, -122.399927785234) | 10 | 3 | 8 | 28856 | 29 | |||
| 3179 | 8036 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005091.683 | 2111605.7953 | 37.7783549305744 | -122.425945187873 | (37.7783549305744, -122.425945187873) | 7 | 9 | 11 | 28852 | 10 | |||
| 7682 | 76663 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 148X Paris St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6002979.0601 | 2092519.08061 | 37.725827707182 | -122.431890313086 | (37.725827707182, -122.431890313086) | 9 | 7 | 6 | 28861 | 5 | ||
| 8322 | 50693 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 3 | Permit Number 47259 | 6015899.29772 | 2115328.09963 | 37.7891803984034 | -122.388817224359 | (37.7891803984034, -122.388817224359) | 6 | 2 | 9 | 28855 | 6 | |
| 11162 | 194818 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6015745.50684 | 2114096.95158 | 37.785791421082 | -122.389263322262 | (37.785791421082, -122.389263322262) | 6 | 2 | 9 | 28856 | 6 | |||
| 16042 | 256809 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1098x Geary St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006524 | 2114353 | 37.7859789268864 | -122.421185386363 | (37.7859789268864, -122.421185386363) | 13 | 9 | 9 | 28858 | 36 | ||||
| 18134 | 133248 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 221 Jackson St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012761.91766 | 2118178.24274 | 37.796831827677 | -122.399872461643 | (37.796831827677, -122.399872461643) | 3 | 1 | 10 | 28860 | 6 | |||
| 22258 | 133152 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 240 Vallejo St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 10ft | 6012234.00402 | 2119168.15298 | 37.7995204381723 | -122.401768793705 | (37.7995204381723, -122.401768793705) | 3 | 1 | 10 | 28860 | 6 | |||
| 22538 | 194837 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 541 Delancey St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6015273.81203 | 2113648.91518 | 37.784535053803 | -122.390863943721 | (37.784535053803, -122.390863943721) | 6 | 2 | 9 | 28856 | 6 | |||
| 23579 | 255888 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 50 Columbia Square St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | ||||
| 24998 | 194906 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 401 Mission Rock St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015306.95007 | 2109382.42409 | 37.7728220640133 | -122.390451083864 | (37.7728220640133, -122.390451083864) | 14 | 3 | 9 | 310 | 20 | |||
| 25311 | 234049 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 Duncan St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006198.66049 | 2099980.47703 | 37.7464970353293 | -122.421289980767 | (37.7464970353293, -122.421289980767) | 2 | 7 | 7 | 28859 | 2 | |||
| 29541 | 194617 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 131 Shipley St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012071.13963 | 2112290.88253 | 37.7806279905367 | -122.401848674179 | (37.7806279905367, -122.401848674179) | 6 | 2 | 9 | 28856 | 34 | |||
| 29961 | 26692 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1295X Pierce St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4X4 | 6002282.65453 | 2112732.23804 | 37.7812887073654 | -122.435743262788 | (37.7812887073654, -122.435743262788) | 15 | 5 | 11 | 29490 | 41 | |||
| 32132 | 235013 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 530 Eureka St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6001525.51679 | 2102619.80582 | 37.7534794310398 | -122.437638150998 | (37.7534794310398, -122.437638150998) | 2 | 4 | 5 | 28862 | 22 | |||
| 40444 | 40871 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 3456 Washington St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1999 12:00:00 AM | Permit Number 41788 | 5998239.16759035 | 2115871.78992415 | 37.7896785829725 | -122.449958017829 | (37.7896785829725, -122.449958017829) | 13 | 6 | 1 | 54 | 31 | |||
| 41493 | 132884 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2620 Broderick St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 4ft | 6000186.4013 | 2117574.26459 | 37.7944643578992 | -122.443343139789 | (37.7944643578992, -122.443343139789) | 13 | 9 | 1 | 57 | 27 | |||
| 42232 | 236014 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 310 Liberty St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6004221.33125 | 2103947.72168 | 37.7572784848211 | -122.428410086068 | (37.7572784848211, -122.428410086068) | 2 | 4 | 5 | 28862 | 3 | |||
| 43135 | 140456 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1499 Eddy St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003479.0697 | 2112771.1641 | 37.7814634747388 | -122.431607035931 | (37.7814634747388, -122.431607035931) | 15 | 9 | 11 | 29490 | 41 | |||
| 45959 | 113293 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1626 PIERCE ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002154 | 2114089 | 37.7850067228559 | -122.436285471088 | (37.7850067228559, -122.436285471088) | 13 | 6 | 11 | 29490 | 13 | ||||
| 47050 | 18291 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2000 Post St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/1992 12:00:00 AM | 6 | 4X4 | 6002309.6948 | 2114045.1862 | 37.7848952663203 | -122.435743681544 | (37.7848952663203, -122.435743681544) | 13 | 6 | 11 | 29490 | 13 | ||
| 47925 | 211629 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 299x Magellan Ave | 9 | Median : Cutout | Tree | DPW 1 | 7 | Width 6ft | 5994463.26259 | 2100123.19006 | 37.7462202815386 | -122.461879740062 | (37.7462202815386, -122.461879740062) | 1 | 8 | 4 | 29491 | 40 | |||
| 50745 | 14823 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1234 McAllister St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2001 12:00:00 AM | 3 | 4X4 | 6003134.879 | 2111723.2201 | 37.778566567554 | -122.432722886511 | (37.778566567554, -122.432722886511) | 15 | 9 | 11 | 29490 | 41 | ||
| 52027 | 194967 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 380 Clementina St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6011511.10302 | 2112382.93194 | 37.7808494665786 | -122.403792598349 | (37.7808494665786, -122.403792598349) | 6 | 2 | 9 | 28853 | 34 | |||
| 57832 | 120615 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6010397.30052 | 2122043.98866 | 37.8073141042181 | -122.408327427091 | (37.8073141042181, -122.408327427091) | 3 | 1 | 10 | 308 | 23 | |||
| 57987 | 142609 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 700 CHESTNUT ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6008187.3399 | 2120697.5762 | 37.8034931957384 | -122.415880103282 | (37.8034931957384, -122.415880103282) | 5 | 1 | 10 | 308 | 32 | |||
| 61217 | 98752 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 540X Eureka St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | 2 | 4 | 5 | 28862 | 22 | ||||
| 61737 | 132548 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1990 Beach St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000721.45665 | 2120976.08361 | 37.8038353484821 | -122.441736044997 | (37.8038353484821, -122.441736044997) | 13 | 9 | 1 | 57 | 17 | |||
| 63162 | 183893 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1390 Quintara St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5989054.2006 | 2101018.2278 | 37.7483649396815 | -122.48064890349 | (37.7483649396815, -122.48064890349) | 1 | 8 | 3 | 29491 | 35 | |||
| 63809 | 99258 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151X Palm Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 5995889.58772 | 2113188.82138 | 37.7821771504315 | -122.45789304424 | (37.7821771504315, -122.45789304424) | 11 | 6 | 1 | 54 | 31 | ||
| 67589 | 236192 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 149 Otis St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6006717.89115 | 2108829.71292 | 37.7708242443664 | -122.420122450296 | (37.7708242443664, -122.420122450296) | 8 | 2 | 9 | 28853 | 19 | |||
| 67617 | 235278 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 407 Sanchez St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003619.6582 | 2105900.62697 | 37.7626066307218 | -122.430630256803 | (37.7626066307218, -122.430630256803) | 8 | 4 | 5 | 28862 | 3 | |||
| 68977 | 132726 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2699 Filbert St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6000154.84461 | 2118475.75012 | 37.7969377992907 | -122.443517117245 | (37.7969377992907, -122.443517117245) | 13 | 9 | 1 | 57 | 17 | |||
| 69191 | 7786 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 320X Fulton St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/24/2012 12:00:00 AM | 3 | 3X3 | 6006210.940911 | 2111809.7702747 | 37.7789781871097 | -122.422087746504 | (37.7789781871097, -122.422087746504) | 7 | 9 | 11 | 28852 | 10 | ||
| 71169 | 138557 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2130 POST ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6001854.1614 | 2113978.4092 | 37.7846860279812 | -122.437314893916 | (37.7846860279812, -122.437314893916) | 13 | 6 | 11 | 29490 | 13 | |||
| 72917 | 206137 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 145 Irving St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5995382.84995 | 2106676.78889 | 37.7642676956295 | -122.459174420184 | (37.7642676956295, -122.459174420184) | 15 | 5 | 11 | 56 | 12 | |||
| 75246 | 20201 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1300X Steiner St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6002775.658 | 2112980.5073 | 37.7819983835402 | -122.43405546728 | (37.7819983835402, -122.43405546728) | 15 | 9 | 11 | 29490 | 41 | ||
| 76688 | 132925 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2340 Jackson St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6002921.07917 | 2116848.57751 | 37.7926273730086 | -122.433828934884 | (37.7926273730086, -122.433828934884) | 13 | 9 | 1 | 29490 | 27 | |||
| 77084 | 30403 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2800 Turk St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/1956 12:00:00 AM | Permit Number 66 | 5997681.665837 | 2111673.48633421 | 37.7781192320704 | -122.451583952943 | (37.7781192320704, -122.451583952943) | 15 | 6 | 2 | 54 | 16 | |||
| 80894 | 5999 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1675 Eddy St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/1993 12:00:00 AM | 6 | 3X3 | 6002579.60353 | 2112492.8275 | 37.7806482091024 | -122.434698841508 | (37.7806482091024, -122.434698841508) | 15 | 5 | 11 | 29490 | 41 | ||
| 84336 | 194845 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 650 Delancey St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6015735.87001 | 2113070.1809 | 37.782971606706 | -122.389224940988 | (37.782971606706, -122.389224940988) | 6 | 2 | 9 | 28856 | 6 | |||
| 86457 | 139903 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1524 Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002147.894 | 2111936.6757 | 37.7790966382169 | -122.43615251874 | (37.7790966382169, -122.43615251874) | 15 | 5 | 11 | 29490 | 41 | |||
| 93274 | 26930 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1510X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002348.90744 | 2111960.33965 | 37.7791730318139 | -122.43545882571 | (37.7791730318139, -122.43545882571) | 15 | 5 | 11 | 29490 | 41 | |||
| 95789 | 133272 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 55 Jackson St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6013381 | 2118288 | 37.7971676890736 | -122.397737980255 | (37.7971676890736, -122.397737980255) | 3 | 1 | 10 | 28860 | 6 | |||
| 96803 | 133238 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 640 Front St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012814.95342 | 2118796.43846 | 37.7985322019592 | -122.399732373354 | (37.7985322019592, -122.399732373354) | 3 | 1 | 10 | 28860 | 6 | |||
| 99579 | 5958 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1499X Eddy St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/15/2013 12:00:00 AM | 3 | 3X3 | 6003460.55718 | 2112761.4386 | 37.7814357216287 | -122.431670385706 | (37.7814357216287, -122.431670385706) | 15 | 9 | 11 | 29490 | 41 | ||
| 100364 | 236093 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 200 Corbin Pl | 9 | Side Yard : Yard | Tree | Private 2 | 11 | Width 3ft | 6000063.11815 | 2105682.66467 | 37.7618060326498 | -122.442915354762 | (37.7618060326498, -122.442915354762) | 15 | 5 | 5 | 28862 | 3 | |||
| 102340 | 178447 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 300x Mansell St | 9 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6010874.01783 | 2090466.7757 | 37.7206369021453 | -122.404453469666 | (37.7206369021453, -122.404453469666) | 10 | 7 | 7 | 309 | 28 | |||
| 105899 | 199754 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1555 Yosemite Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014955.1471 | 2092362.9904 | 37.7260707593693 | -122.3904785934 | (37.7260707593693, -122.3904785934) | 10 | 3 | 8 | 58 | 1 | |||
| 107668 | 194994 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 11 Dedman Ct | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6016695.66804 | 2096249.95032 | 37.7368399811784 | -122.384732310246 | (37.7368399811784, -122.384732310246) | 10 | 3 | 8 | 58 | 1 | |||
| 108758 | 110875 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 800 INDIANA ST | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
| 110565 | 251035 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 5317x Geary Blvd | 9 | Median : Yard | Tree | DPW 1 | 1 | Width 10ft | 5990415.7605 | 2112675.5562 | 37.7804518645045 | -122.47679231146 | (37.7804518645045, -122.47679231146) | 11 | 6 | 2 | 55 | 26 | |||
| 111064 | 194892 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 390 China Basin St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015277.50152 | 2109087.49528 | 37.7720106210325 | -122.390532338524 | (37.7720106210325, -122.390532338524) | 14 | 3 | 9 | 310 | 20 | |||
| 114628 | 98768 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 14 | 3x3 | 6003334.44122 | 2121062.90291 | 37.8042222665138 | -122.432699869304 | (37.8042222665138, -122.432699869304) | 13 | 9 | 1 | 57 | 17 | |||
| 115967 | 133260 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 207 Jackson St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6013092.16476 | 2118222.60778 | 37.7969720490646 | -122.398732837175 | (37.7969720490646, -122.398732837175) | 3 | 1 | 10 | 28860 | 6 | |||
| 117083 | 256838 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1201x Franklin St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
| 119267 | 42719 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1790 Yosemite Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 10 | Permit Number 42732 | 6013626.78121 | 2093430.48356 | 37.7289280992382 | -122.395145447815 | (37.7289280992382, -122.395145447815) | 10 | 3 | 8 | 58 | 1 | |
| 120790 | 133173 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1900 The Embarcadero | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6010549.20123 | 2122094.68608 | 37.8074618115912 | -122.407805315766 | (37.8074618115912, -122.407805315766) | 3 | 1 | 10 | 308 | 23 | |||
| 121009 | 139913 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1601 TURK ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002285.2932 | 2112252.4233 | 37.7799714069413 | -122.435699795842 | (37.7799714069413, -122.435699795842) | 15 | 5 | 11 | 29490 | 41 | |||
| 122085 | 22757 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1615 Turk St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002290.5681256 | 2112253.7211071 | 37.7799752700111 | -122.435681640416 | (37.7799752700111, -122.435681640416) | 15 | 5 | 11 | 29490 | 41 | |||
| 122976 | 26969 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2075X Sutter St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6002731.6832 | 2114392.4853 | 37.7858728223124 | -122.434308577847 | (37.7858728223124, -122.434308577847) | 13 | 9 | 11 | 29490 | 13 | |||
| 124499 | 211852 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 714 Detroit St | 9 | Side Yard : Yard | Tree | Private 2 | 3 | 5999466.29609 | 2095415.22212 | 37.7335800736498 | -122.444241668616 | (37.7335800736498, -122.444241668616) | 9 | 7 | 4 | 63 | 40 | ||||
| 128457 | 194916 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 402 Mission Rock St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015135.31284 | 2109418.13911 | 37.7729106067791 | -122.391047298403 | (37.7729106067791, -122.391047298403) | 14 | 3 | 9 | 310 | 20 | |||
| 131177 | 98630 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6002266.09398 | 2120152.58331 | 37.8016621223571 | -122.436331772404 | (37.8016621223571, -122.436331772404) | 13 | 9 | 1 | 57 | 17 | ||
| 133341 | 194932 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 660 China Basin St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6014562.61774 | 2109051.99086 | 37.7718734492252 | -122.39300271142 | (37.7718734492252, -122.39300271142) | 14 | 3 | 9 | 310 | 20 | |||
| 134700 | 49727 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1300@ REVERE Griffith St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | Permit Number 46533 | 6017891.63282432 | 2092647.03396297 | 37.727013150708 | -122.380346965446 | (37.727013150708, -122.380346965446) | 10 | 3 | 8 | 58 | 1 | ||
| 145434 | 97862 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 895 Indiana St | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | 10 | 3 | 8 | 28856 | 29 | |||||
| 147764 | 256824 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1101x Geary Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006325 | 2114183 | 37.7855009281479 | -122.421861793189 | (37.7855009281479, -122.421861793189) | 13 | 9 | 11 | 28858 | 41 | ||||
| 153145 | 133227 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 600 Front St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012868.19418 | 2118425.30611 | 37.7975161290214 | -122.399522072308 | (37.7975161290214, -122.399522072308) | 3 | 1 | 10 | 28860 | 6 | |||
| 156848 | 20188 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1225 Steiner St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6002803.937717 | 2112440.9213574 | 37.7805184210702 | -122.433919051618 | (37.7805184210702, -122.433919051618) | 15 | 9 | 11 | 29490 | 41 | |||
| 157510 | 194831 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 543 Delancey St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6015449.98407 | 2113467.21208 | 37.7840459116455 | -122.390241744167 | (37.7840459116455, -122.390241744167) | 6 | 2 | 9 | 28856 | 6 | |||
| 159591 | 132765 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3700 Buchanan St | 9 | : | Tree | Private 2 | 7 | Width 4ft | 6003091.99833 | 2121255.71658 | 37.8047379296645 | -122.433552648755 | (37.8047379296645, -122.433552648755) | 13 | 9 | 1 | 57 | 17 | |||
| 160606 | 174956 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1225 Steiner St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6002808.89406 | 2112441.57928 | 37.7805205088243 | -122.433901952341 | (37.7805205088243, -122.433901952341) | 15 | 9 | 11 | 29490 | 41 | ||||
| 167837 | 173628 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 800X Brotherhood Way | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 3x3 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||
| 170170 | 7913 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1200X Franklin St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x4 | 6006011.4004 | 2114196.65348 | 37.7855207268899 | -122.422947727566 | (37.7855207268899, -122.422947727566) | 13 | 9 | 11 | 28858 | 41 | |||
| 170561 | 133218 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 601 Davis St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6013166.00694 | 2118348.12863 | 37.7973208133604 | -122.398486136051 | (37.7973208133604, -122.398486136051) | 3 | 1 | 10 | 28860 | 6 | |||
| 173582 | 21345 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2592X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | 1 | 8 | 3 | 29491 | 35 | |||
| 177523 | 133208 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 641 Davis St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6013118.32731 | 2118705.23557 | 37.7982986875899 | -122.398676194272 | (37.7982986875899, -122.398676194272) | 3 | 1 | 10 | 28860 | 6 | |||
| 177698 | 19132 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 25 Sanchez St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003493.34978 | 2108308.66299 | 37.7692113579425 | -122.431239005201 | (37.7692113579425, -122.431239005201) | 7 | 9 | 5 | 28862 | 3 | |||
| 182939 | 22737 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1560 Turk St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/1997 12:00:00 AM | 12 | 3X3 | 6002411.6938 | 2112321.6305 | 37.78016861134 | -122.435267471873 | (37.78016861134, -122.435267471873) | 15 | 5 | 11 | 29490 | 41 | ||
| 184121 | 133176 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 150 Francisco St | 9 | Front Yard : Yard | Tree | Private 2 | 45 | 6010490.33512 | 2121337.17898 | 37.8053785896135 | -122.407955582591 | (37.8053785896135, -122.407955582591) | 3 | 1 | 10 | 308 | 23 | ||||
| 190570 | 194866 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015868.42271 | 2109073.181 | 37.7720040811672 | -122.388487279274 | (37.7720040811672, -122.388487279274) | 14 | 3 | 9 | 310 | 20 | |||
| 191882 | 133188 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Francisco St | 9 | Front Yard : Yard | Tree | Private 2 | 18 | 6010540.31188 | 2121313.86259 | 37.8053173664783 | -122.407780985508 | (37.8053173664783, -122.407780985508) | 3 | 1 | 10 | 308 | 23 | ||||
| 189341 | 211742 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 700 Junipero Serra Blvd | 88 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5991230.19236 | 2092152.91218 | 37.7241492619617 | -122.472478226094 | (37.7241492619617, -122.472478226094) | 9 | 8 | 4 | 64 | 40 | |||
| 49801 | 211741 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 700 Junipero Serra Blvd | 86 | : | Tree | Private 2 | 8 | Width 0ft | 5991245.41265 | 2092162.56077 | 37.7241766355394 | -122.472426315417 | (37.7241766355394, -122.472426315417) | 9 | 8 | 4 | 64 | 40 | |||
| 669 | 30402 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2800 Turk St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/1956 12:00:00 AM | Permit Number 66 | 5997681.665837 | 2111673.48633421 | 37.7781192320704 | -122.451583952943 | (37.7781192320704, -122.451583952943) | 15 | 6 | 2 | 54 | 16 | |||
| 989 | 40872 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 3456 Washington St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1999 12:00:00 AM | Permit Number 41788 | 5998239.16759035 | 2115871.78992415 | 37.7896785829725 | -122.449958017829 | (37.7896785829725, -122.449958017829) | 13 | 6 | 1 | 54 | 31 | |||
| 2038 | 8035 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005070.3181 | 2111601.5224 | 37.7783419907871 | -122.426018792814 | (37.7783419907871, -122.426018792814) | 7 | 9 | 11 | 28852 | 10 | |||
| 2517 | 20187 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1225 Steiner St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6002803.937717 | 2112440.9213574 | 37.7805184210702 | -122.433919051618 | (37.7805184210702, -122.433919051618) | 15 | 9 | 11 | 29490 | 41 | |||
| 6838 | 256837 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1201x Franklin St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
| 7943 | 194966 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 380 Clementina St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6011517.79907 | 2112391.01147 | 37.7808720251553 | -122.403770001992 | (37.7808720251553, -122.403770001992) | 6 | 2 | 9 | 28853 | 34 | |||
| 8622 | 256682 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 330 Twin Peaks Blvd | 8 | Front Yard : Yard | Tree | Private 2 | 03/27/2019 12:00:00 AM | 3 | 3x3 | 5998688 | 2103995 | 37.7570936308358 | -122.447549834506 | (37.7570936308358, -122.447549834506) | 15 | 5 | 4 | 63 | 38 | ||
| 10987 | 211628 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 299x Magellan Ave | 8 | Median : Cutout | Tree | DPW 1 | 14 | Width 6ft | 5994455.12768 | 2100116.98357 | 37.7462027717556 | -122.461907419396 | (37.7462027717556, -122.461907419396) | 1 | 8 | 4 | 29491 | 40 | |||
| 11364 | 50692 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2004 12:00:00 AM | 4 | 4x4 | Permit Number 47259 | 6015887.62882 | 2115316.72883 | 37.7891485300247 | -122.388856803509 | (37.7891485300247, -122.388856803509) | 6 | 2 | 9 | 28855 | 6 | |
| 12111 | 20037 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 STAIRWAY51 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | ST | |||||||||||||
| 12719 | 49732 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1300@ REVERE Griffith St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | Permit Number 46533 | 6017891.63282432 | 2092647.03396297 | 37.727013150708 | -122.380346965446 | (37.727013150708, -122.380346965446) | 10 | 3 | 8 | 58 | 1 | ||
| 12732 | 36844 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 23314 | 236092 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 200 Corbin Pl | 8 | Side Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6000056.44576 | 2105686.72803 | 37.7618168092183 | -122.442938723641 | (37.7618168092183, -122.442938723641) | 15 | 5 | 5 | 28862 | 3 | |||
| 24099 | 19131 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 25 Sanchez St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X4 | 6003492.94588 | 2108289.09312 | 37.7691576009622 | -122.431239005184 | (37.7691576009622, -122.431239005184) | 7 | 9 | 5 | 28862 | 3 |
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) );