trees
665 rows where qSpecies_id = 89 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26479 | 220593 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008525.9203 | 2107974.98193 | 37.7685790581131 | -122.413807947778 | (37.7685790581131, -122.413807947778) | 8 | 4 | 7 | 28853 | 19 | |||
38406 | 220594 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008571.39642 | 2107977.23283 | 37.7685877923289 | -122.413650808341 | (37.7685877923289, -122.413650808341) | 8 | 4 | 7 | 28853 | 19 | |||
22266 | 189179 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012646.32236 | 2115321.24239 | 37.7889807363318 | -122.400071707361 | (37.7889807363318, -122.400071707361) | 12 | 2 | 9 | 28855 | 6 | |||
46462 | 189178 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012651.66778 | 2115316.04533 | 37.7889667644596 | -122.400052847677 | (37.7889667644596, -122.400052847677) | 12 | 2 | 9 | 28855 | 6 | |||
67570 | 189177 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012656.64503 | 2115309.49846 | 37.7889490657959 | -122.400035166996 | (37.7889490657959, -122.400035166996) | 12 | 2 | 9 | 28855 | 6 | |||
119465 | 189175 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012666.59913 | 2115298.53532 | 37.7889195185657 | -122.399999956726 | (37.7889195185657, -122.399999956726) | 12 | 2 | 9 | 28855 | 6 | |||
176265 | 189176 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012661.31608 | 2115304.65409 | 37.7889360247231 | -122.400018665349 | (37.7889360247231, -122.400018665349) | 12 | 2 | 9 | 28855 | 6 | |||
54594 | 220611 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009641.7814 | 2098664.71567 | 37.7430777589371 | -122.409291162184 | (37.7430777589371, -122.409291162184) | 10 | 7 | 7 | 28859 | 2 | |||
2382 | 255210 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
75027 | 203443 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Marne Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5995223.6819 | 2097798.00617 | 37.7398796519151 | -122.459081986971 | (37.7398796519151, -122.459081986971) | 9 | 7 | 4 | 59 | 40 | |||
84837 | 203444 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Marne Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5995221.10472 | 2097808.00302 | 37.7399069526404 | -122.459091621397 | (37.7399069526404, -122.459091621397) | 9 | 7 | 4 | 59 | 40 | |||
117582 | 203446 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Marne Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5995218.70657 | 2097826.55093 | 37.7399577427547 | -122.459101255842 | (37.7399577427547, -122.459101255842) | 9 | 7 | 4 | 59 | 40 | |||
175290 | 203445 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Marne Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5995218.97252 | 2097817.06527 | 37.7399317127649 | -122.459099649629 | (37.7399317127649, -122.459099649629) | 9 | 7 | 4 | 59 | 40 | |||
34872 | 125482 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Nob Hill Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 1ft | 6009469.59091 | 2116291.78471 | 37.7914679787239 | -122.411131403485 | (37.7914679787239, -122.411131403485) | 5 | 1 | 10 | 28857 | 21 | |||
153761 | 125481 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Nob Hill Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 6009481.63749 | 2116293.53202 | 37.7914734519756 | -122.411089845832 | (37.7914734519756, -122.411089845832) | 5 | 1 | 10 | 28857 | 21 | |||
88927 | 220598 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Sycamore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006787.43083 | 2105854.68311 | 37.7626594317184 | -122.419670791888 | (37.7626594317184, -122.419670791888) | 8 | 4 | 7 | 28859 | 19 | |||
64382 | 66177 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 10 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/05/1990 12:00:00 AM | Permit Number 29250 | 6009347.85081362 | 2097405.9142613 | 37.7396048925803 | -122.41021864302 | (37.7396048925803, -122.41021864302) | 10 | 7 | 7 | 28859 | 2 | ||
136067 | 220643 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 10 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009355.21688 | 2097375.10372 | 37.7395207064184 | -122.410190999519 | (37.7395207064184, -122.410190999519) | 10 | 7 | 7 | 28859 | 2 | |||
87960 | 220595 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 10 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005798.00468 | 2105985.91015 | 37.7629639655453 | -122.423102194736 | (37.7629639655453, -122.423102194736) | 8 | 4 | 5 | 28859 | 19 | |||
1264 | 125499 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 10 Hastings Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6007355.47144 | 2119286.08851 | 37.7995708047014 | -122.418658671469 | (37.7995708047014, -122.418658671469) | 5 | 1 | 1 | 28858 | 32 | ||||
44125 | 120266 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 24th Ave | 2 | Side Yard : Yard | Tree | Private 2 | 5 | 5988365.77159 | 2115120.59325 | 37.7870461179038 | -122.484063450514 | (37.7870461179038, -122.484063450514) | 11 | 6 | 1 | 55 | 33 | ||||
23055 | 189156 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012246.95244 | 2112466.10025 | 37.7811189079475 | -122.401252766302 | (37.7811189079475, -122.401252766302) | 6 | 2 | 9 | 28856 | 34 | |||
57639 | 189157 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012230.29612 | 2112453.73281 | 37.7810840205508 | -122.401309519845 | (37.7810840205508, -122.401309519845) | 6 | 2 | 9 | 28856 | 34 | |||
57858 | 189153 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012332.53447 | 2112551.48713 | 37.7813581348078 | -122.400962694499 | (37.7813581348078, -122.400962694499) | 6 | 2 | 9 | 28856 | 34 | |||
108852 | 189154 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012314.00092 | 2112536.43535 | 37.7813157722581 | -122.401025754031 | (37.7813157722581, -122.401025754031) | 6 | 2 | 9 | 28856 | 34 | |||
144036 | 189155 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012260.87565 | 2112478.52323 | 37.7811537953404 | -122.401205471869 | (37.7811537953404, -122.401205471869) | 6 | 2 | 9 | 28856 | 34 | |||
56067 | 203470 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Staples Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 5999333.68862 | 2093807.88656 | 37.72915914047 | -122.444584644873 | (37.72915914047, -122.444584644873) | 9 | 7 | 4 | 28861 | 40 | ||||
20384 | 189165 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1000 Pennsylvania Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6014460.44489 | 2102480.94268 | 37.753825107047 | -122.392896328823 | (37.753825107047, -122.392896328823) | 10 | 3 | 8 | 28856 | 29 | |||
64447 | 125502 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1001 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 6007468.42884 | 2120195.87716 | 37.8020752142594 | -122.418332338987 | (37.8020752142594, -122.418332338987) | 5 | 1 | 1 | 28858 | 32 | |||
84618 | 125504 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1001 Lombard St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 7ft | 6007489.69173 | 2120199.07294 | 37.8020851859507 | -122.418258985774 | (37.8020851859507, -122.418258985774) | 5 | 1 | 1 | 28858 | 32 | |||
178268 | 125503 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1001 Lombard St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 7ft | 6007472.5485 | 2120196.70062 | 37.8020777071716 | -122.418318141382 | (37.8020777071716, -122.418318141382) | 5 | 1 | 1 | 28858 | 32 | |||
62900 | 32709 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1005 Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37107 | 6007675.42771265 | 2115829.29953352 | 37.7900973284958 | -122.417306405748 | (37.7900973284958, -122.417306405748) | 13 | 1 | 10 | 28858 | 21 | ||
77931 | 32708 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1005 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37107 | 6007675.42771265 | 2115829.29953352 | 37.7900973284958 | -122.417306405748 | (37.7900973284958, -122.417306405748) | 13 | 1 | 10 | 28858 | 21 | ||
186226 | 32707 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1005 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37107 | 6007675.42771265 | 2115829.29953352 | 37.7900973284958 | -122.417306405748 | (37.7900973284958, -122.417306405748) | 13 | 1 | 10 | 28858 | 21 | ||
186427 | 32706 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1005 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 1 | Permit Number 37107 | 6007669.19829 | 2115867.15124 | 37.790200909505 | -122.417330642617 | (37.790200909505, -122.417330642617) | 13 | 1 | 10 | 28858 | 21 | |
89424 | 203484 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 101 Los Palmos Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5998423.23469 | 2096036.13552 | 37.7352253905456 | -122.447892505138 | (37.7352253905456, -122.447892505138) | 9 | 7 | 4 | 59 | 40 | |||
133463 | 203485 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 101 Los Palmos Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5998424.41404 | 2096025.6755 | 37.7351967372311 | -122.447887674883 | (37.7351967372311, -122.447887674883) | 9 | 7 | 4 | 59 | 40 | |||
179693 | 203486 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 101 Los Palmos Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5998423.08817 | 2096045.87835 | 37.7352521336624 | -122.447893712922 | (37.7352521336624, -122.447893712922) | 9 | 7 | 4 | 59 | 40 | |||
42265 | 96059 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 101 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767687 | 6010479 | 2099916 | 37.7465603843487 | -122.406484424587 | (37.7465603843487, -122.406484424587) | 2 | 7 | 7 | 28859 | 2 | |
101343 | 94131 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 101 Montcalm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53497 | 6010479 | 2099916 | 37.7465603843487 | -122.406484424587 | (37.7465603843487, -122.406484424587) | 2 | 7 | 7 | 28859 | 2 | ||
104611 | 96061 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 101 Montcalm St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767687 | 6010479 | 2099916 | 37.7465603843487 | -122.406484424587 | (37.7465603843487, -122.406484424587) | 2 | 7 | 7 | 28859 | 2 | |
157818 | 53452 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 101 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53497 | 6010475.69688316 | 2099901.56098952 | 37.7465205531872 | -122.406494829187 | (37.7465205531872, -122.406494829187) | 2 | 7 | 7 | 28859 | 2 | ||
162633 | 94132 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 101 Montcalm St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53497 | 6010479 | 2099916 | 37.7465603843487 | -122.406484424587 | (37.7465603843487, -122.406484424587) | 2 | 7 | 7 | 28859 | 2 | ||
182643 | 96060 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 101 Montcalm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767687 | 6010479 | 2099916 | 37.7465603843487 | -122.406484424587 | (37.7465603843487, -122.406484424587) | 2 | 7 | 7 | 28859 | 2 | |
99651 | 249529 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1035 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6006430.75514 | 2114125.51985 | 37.7853490652506 | -122.4214918273 | (37.7853490652506, -122.4214918273) | 13 | 9 | 11 | 28858 | 41 | |||
30749 | 17018 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1048 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/1998 12:00:00 AM | 3 | 3X3 | 6001982.80486 | 2109858.77961 | 37.7733818753695 | -122.436574858617 | (37.7733818753695, -122.436574858617) | 15 | 5 | 11 | 29492 | 10 | ||
88253 | 125522 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1087 Greenwich St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6007750.4574 | 2119887.81691 | 37.8012452299295 | -122.417334539369 | (37.8012452299295, -122.417334539369) | 5 | 1 | 1 | 308 | 32 | |||
317 | 189161 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 109 Kissling St | 4 | : | Tree | Private 2 | 2 | Width 3ft | 6008149.50016 | 2109391.65635 | 37.7724477670719 | -122.415210253457 | (37.7724477670719, -122.415210253457) | 8 | 2 | 9 | 28853 | 19 | |||
88873 | 189160 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 109 Kissling St | 3 | : | Tree | Private 2 | 2 | Width 3ft | 6008158.83722 | 2109400.58141 | 37.772472797918 | -122.415178587445 | (37.772472797918, -122.415178587445) | 8 | 2 | 9 | 28853 | 19 | |||
100444 | 189158 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 109 Kissling St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6008181.20874 | 2109420.17856 | 37.7725278642987 | -122.415102589323 | (37.7725278642987, -122.415102589323) | 8 | 2 | 9 | 28853 | 19 | |||
121797 | 189162 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 109 Kissling St | 5 | : | Tree | Private 2 | 2 | Width 3ft | 6008137.74771 | 2109383.99653 | 37.7724260745213 | -122.41525036412 | (37.7724260745213, -122.41525036412) | 8 | 2 | 9 | 28853 | 19 | |||
139089 | 189159 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 109 Kissling St | 2 | : | Tree | Private 2 | 2 | Width 3ft | 6008170.01676 | 2109410.076 | 37.7724994960939 | -122.415140588393 | (37.7724994960939, -122.415140588393) | 8 | 2 | 9 | 28853 | 19 | |||
34525 | 125530 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010077.84381 | 2116891.68093 | 37.7931492405824 | -122.40906919691 | (37.7931492405824, -122.40906919691) | 3 | 1 | 10 | 28857 | 4 | |||
41938 | 125534 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6010079.0906 | 2116883.16981 | 37.793125940953 | -122.409064282098 | (37.793125940953, -122.409064282098) | 3 | 1 | 10 | 28857 | 4 | |||
44724 | 125536 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010079.47478 | 2116878.80155 | 37.7931139682908 | -122.409062644439 | (37.7931139682908, -122.409062644439) | 3 | 1 | 10 | 28857 | 4 | |||
68453 | 125538 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6010079.83492 | 2116873.25499 | 37.7930987589554 | -122.409061006782 | (37.7930987589554, -122.409061006782) | 3 | 1 | 10 | 28857 | 4 | |||
88185 | 125529 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6010076.61244 | 2116904.10673 | 37.793183289838 | -122.40907433472 | (37.793183289838, -122.40907433472) | 3 | 1 | 10 | 28857 | 4 | |||
115378 | 125533 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010078.6629 | 2116885.41787 | 37.7931320896218 | -122.409065920669 | (37.7931320896218, -122.409065920669) | 3 | 1 | 10 | 28857 | 4 | |||
133904 | 125537 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010079.43392 | 2116876.79887 | 37.7931084671277 | -122.409062644443 | (37.7931084671277, -122.409062644443) | 3 | 1 | 10 | 28857 | 4 | |||
136839 | 125531 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010078.15064 | 2116889.31743 | 37.7931427681724 | -122.409067968409 | (37.7931427681724, -122.409067968409) | 3 | 1 | 10 | 28857 | 4 | |||
154365 | 125535 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010079.40223 | 2116881.04203 | 37.7931201160419 | -122.409063053629 | (37.7931201160419, -122.409063053629) | 3 | 1 | 10 | 28857 | 4 | |||
187380 | 125532 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010078.47215 | 2116887.6611 | 37.7931382383022 | -122.409066739034 | (37.7931382383022, -122.409066739034) | 3 | 1 | 10 | 28857 | 4 | |||
23673 | 125501 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1115 Filbert St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6007553.74728 | 2119514.62481 | 37.8002094690578 | -122.417988773678 | (37.8002094690578, -122.417988773678) | 5 | 1 | 1 | 28858 | 32 | |||
62150 | 67492 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1119 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/2015 12:00:00 AM | 3 | Permit Number 774343 | 6011679.29477 | 2103189.50582 | 37.7556157939465 | -122.402564065097 | (37.7556157939465, -122.402564065097) | 10 | 3 | 8 | 28856 | 29 | |
116507 | 203463 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 112 Baden St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6000775.43585 | 2094454.02267 | 37.7310154446029 | -122.439646720241 | (37.7310154446029, -122.439646720241) | 9 | 7 | 4 | 63 | 40 | |||
121531 | 203462 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 112 Baden St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 6000775.11209 | 2094438.40357 | 37.7309725397368 | -122.439646720213 | (37.7309725397368, -122.439646720213) | 9 | 7 | 4 | 63 | 40 | |||
104422 | 125479 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1133 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009244.74147 | 2117035.03683 | 37.7934961558667 | -122.411961928316 | (37.7934961558667, -122.411961928316) | 3 | 1 | 10 | 28857 | 21 | |||
113174 | 125497 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1154 Chestnut St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6006282.86688 | 2120431.59702 | 37.8026556331117 | -122.422451714169 | (37.8026556331117, -122.422451714169) | 5 | 9 | 1 | 28858 | 32 | |||
194134 | 125498 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1154 Chestnut St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6006270.07079 | 2120429.11585 | 37.8026480985929 | -122.422495818752 | (37.8026480985929, -122.422495818752) | 5 | 9 | 1 | 28858 | 32 | |||
169624 | 17031 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1160X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001440.12949 | 2109757.61689 | 37.7730732545652 | -122.438444795925 | (37.7730732545652, -122.438444795925) | 15 | 5 | 11 | 29492 | 10 | |||
29202 | 125468 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1177 California St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6008726.14199 | 2116272.16952 | 37.7913723996763 | -122.413702344902 | (37.7913723996763, -122.413702344902) | 5 | 1 | 10 | 28857 | 21 | |||
106323 | 125469 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1177 California St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6008779.73096 | 2116281.55689 | 37.7914011842588 | -122.413517591782 | (37.7914011842588, -122.413517591782) | 5 | 1 | 10 | 28857 | 21 | |||
125968 | 125466 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1177 California St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6008683.65979 | 2116266.52541 | 37.7913545166392 | -122.413848933479 | (37.7913545166392, -122.413848933479) | 5 | 1 | 10 | 28857 | 21 | |||
182154 | 125467 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1177 California St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 6008702.23207 | 2116269.4831 | 37.7913636807268 | -122.413784882888 | (37.7913636807268, -122.413784882888) | 5 | 1 | 10 | 28857 | 21 | |||
193513 | 125465 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1177 California St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 6008661.04402 | 2116264.72933 | 37.7913483149251 | -122.413927056694 | (37.7913483149251, -122.413927056694) | 5 | 1 | 10 | 28857 | 21 | |||
87958 | 66924 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 118 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1991 12:00:00 AM | Permit Number 30245 | 6007569.63661842 | 2098095.56578905 | 37.7413986874365 | -122.416415794383 | (37.7413986874365, -122.416415794383) | 2 | 7 | 7 | 28859 | 2 | ||
41180 | 220663 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1190 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003819.29636 | 2101374.54384 | 37.7501903863949 | -122.42961696547 | (37.7501903863949, -122.42961696547) | 2 | 4 | 5 | 28862 | 22 | |||
132417 | 49036 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1190 Sanchez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46211 | 6003822.41781324 | 2101344.45239948 | 37.7501079390792 | -122.429604025448 | (37.7501079390792, -122.429604025448) | 2 | 4 | 5 | 28862 | 22 | ||
168006 | 49034 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1190 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46211 | 6003822.41781324 | 2101344.45239948 | 37.7501079390792 | -122.429604025448 | (37.7501079390792, -122.429604025448) | 2 | 4 | 5 | 28862 | 22 | ||
179660 | 49037 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1190 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | 10 | Permit Number 46211 | 6003822.41781324 | 2101344.45239948 | 37.7501079390792 | -122.429604025448 | (37.7501079390792, -122.429604025448) | 2 | 4 | 5 | 28862 | 22 | |
189014 | 49035 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1190 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46211 | 6003822.41781324 | 2101344.45239948 | 37.7501079390792 | -122.429604025448 | (37.7501079390792, -122.429604025448) | 2 | 4 | 5 | 28862 | 22 | ||
31145 | 220664 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1192 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003819.11819 | 2101351.99344 | 37.7501284581809 | -122.429615973494 | (37.7501284581809, -122.429615973494) | 2 | 4 | 5 | 28862 | 22 | |||
6257 | 125500 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 12 Hastings Ter | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6007269.76384 | 2119273.06582 | 37.7995302219096 | -122.418954327193 | (37.7995302219096, -122.418954327193) | 5 | 1 | 1 | 28858 | 32 | ||||
102881 | 220639 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1202 Stanyan St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5997451.78012 | 2105807.14899 | 37.7619986098677 | -122.451955868771 | (37.7619986098677, -122.451955868771) | 15 | 5 | 11 | 29492 | 9 | |||
186373 | 96486 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1202 Stanyan St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5997433 | 2105848 | 37.7621097006999 | -122.452023768999 | (37.7621097006999, -122.452023768999) | 15 | 5 | 11 | 29492 | 9 | |||||
34992 | 125491 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6005994.09185 | 2120329.47146 | 37.8023589278732 | -122.423443758146 | (37.8023589278732, -122.423443758146) | 5 | 9 | 1 | 28858 | 32 | |||
51637 | 125493 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6006021.47381 | 2120333.65457 | 37.8023719590496 | -122.423349300554 | (37.8023719590496, -122.423349300554) | 5 | 9 | 1 | 28858 | 32 | |||
73410 | 125496 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6006063.84143 | 2120339.68716 | 37.8023909140602 | -122.423203116649 | (37.8023909140602, -122.423203116649) | 5 | 9 | 1 | 28858 | 32 | |||
87363 | 125495 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6006051.2199 | 2120336.9264 | 37.8023826214287 | -122.423246597049 | (37.8023826214287, -122.423246597049) | 5 | 9 | 1 | 28858 | 32 | |||
115971 | 66783 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | 5 | Permit Number 30054 | 6005979.75561 | 2120327.60903 | 37.8023530049553 | -122.423493236148 | (37.8023530049553, -122.423493236148) | 5 | 9 | 1 | 28858 | 32 | |
121196 | 125494 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6006034.74479 | 2120336.40198 | 37.8023802517163 | -122.423303571803 | (37.8023802517163, -122.423303571803) | 5 | 9 | 1 | 28858 | 32 | |||
149402 | 125492 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6006010.16913 | 2120331.72981 | 37.8023660361287 | -122.423388283439 | (37.8023660361287, -122.423388283439) | 5 | 9 | 1 | 28858 | 32 | |||
162391 | 189180 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 123 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6012900.45208 | 2113712.93045 | 37.7845788525671 | -122.399079511431 | (37.7845788525671, -122.399079511431) | 6 | 2 | 9 | 28853 | 6 | |||
51653 | 125485 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1237x Robert C Levy Tunl | 3 | Median : Yard | Tree | DPW 1 | 10 | 6007640.9414 | 2118138.07584 | 37.796434716745 | -122.417589429708 | (37.796434716745, -122.417589429708) | 5 | 1 | 10 | 28858 | 32 | ||||
142938 | 125484 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1237x Robert C Levy Tunl | 1 | Median : Yard | Tree | DPW 1 | 18 | 6007648.69076 | 2118115.73393 | 37.796373807471 | -122.417561030927 | (37.796373807471, -122.417561030927) | 5 | 1 | 10 | 28858 | 32 | ||||
169681 | 125486 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1237x Robert C Levy Tunl | 4 | Median : Yard | Tree | DPW 1 | 6 | 6007645.27033 | 2118136.8198 | 37.7964315115565 | -122.417574361577 | (37.7964315115565, -122.417574361577) | 5 | 1 | 10 | 28858 | 32 | ||||
167430 | 37576 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 124 Danvers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40009 | 5999906.30838792 | 2105075.4680497 | 37.7601298795068 | -122.44341407918 | (37.7601298795068, -122.44341407918) | 2 | 4 | 5 | 28862 | 3 | ||
1455 | 176735 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1245 Bacon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/17/2019 12:00:00 AM | 3 | Width 2ft | 6007785.06482 | 2091940.88647 | 37.7245113883837 | -122.415235340041 | (37.7245113883837, -122.415235340041) | 9 | 3 | 7 | 309 | 28 | ||
13926 | 176734 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1245 Bacon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/17/2019 12:00:00 AM | 3 | Width 2ft | 6007778.84426 | 2091938.91597 | 37.7245056282085 | -122.415256704327 | (37.7245056282085, -122.415256704327) | 9 | 3 | 7 | 309 | 28 | ||
79988 | 201923 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 125 Elmira St | 1 | : | Tree | Private 2 | 13 | Width 4ft | 6011215.48386 | 2096005.8192 | 37.7358650396404 | -122.403662651736 | (37.7358650396404, -122.403662651736) | 10 | 3 | 8 | 58 | 1 |
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) );