trees
8,659 rows where qSpecies_id = 11 sorted by qAddress 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 42486 | 43641 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 955 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/2000 12:00:00 AM | Permit Number 43291 | 5999197.81728422 | 2106825.23226471 | 37.7648938665967 | -122.445990256873 | (37.7648938665967, -122.445990256873) | 15 | 5 | 11 | 29492 | 9 | ||
| 55295 | 229119 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 953 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007613.86357 | 2104139.81261 | 37.7579973120563 | -122.41669095844 | (37.7579973120563, -122.41669095844) | 2 | 4 | 7 | 28859 | 19 | |||
| 140746 | 61166 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 953 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1983 12:00:00 AM | Permit Number 21025 | 6007610.14414973 | 2104113.50213314 | 37.7579248603374 | -122.416701957934 | (37.7579248603374, -122.416701957934) | 2 | 4 | 7 | 28859 | 19 | ||
| 54831 | 201047 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 953 Indiana St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6014994.68358 | 2104372.25303 | 37.759047900964 | -122.391180985336 | (37.759047900964, -122.391180985336) | 10 | 3 | 8 | 28856 | 29 | |||
| 117698 | 104345 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 953 Indiana St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6014995.86461 | 2104338.49081 | 37.7589552627061 | -122.391174540789 | (37.7589552627061, -122.391174540789) | 10 | 3 | 8 | 28856 | 29 | ||||
| 172399 | 104344 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 953 Indiana St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6014997.70938 | 2104304.04046 | 37.7588607718232 | -122.391165752619 | (37.7588607718232, -122.391165752619) | 10 | 3 | 8 | 28856 | 29 | ||||
| 43297 | 130037 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 951 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6006740.61471 | 2113913.82769 | 37.784785276656 | -122.420404773573 | (37.784785276656, -122.420404773573) | 7 | 9 | 9 | 28858 | 36 | |||
| 74605 | 31958 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 951 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | Permit Number 35363 | 6006750.04220439 | 2113913.29046831 | 37.78478433283 | -122.420372119329 | (37.78478433283, -122.420372119329) | 7 | 9 | 9 | 28858 | 36 | ||
| 104432 | 130036 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 951 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6006717.99187 | 2113909.0944 | 37.7847710053339 | -122.420482705228 | (37.7847710053339, -122.420482705228) | 7 | 9 | 9 | 28858 | 36 | |||
| 114355 | 31960 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 951 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | Permit Number 35363 | 6006750.04220439 | 2113913.29046831 | 37.78478433283 | -122.420372119329 | (37.78478433283, -122.420372119329) | 7 | 9 | 9 | 28858 | 36 | ||
| 120914 | 130038 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 951 O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006755.49293 | 2113915.9844 | 37.784792036859 | -122.420353452846 | (37.784792036859, -122.420353452846) | 7 | 9 | 9 | 28858 | 36 | |||
| 158053 | 31959 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 951 O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | Permit Number 35363 | 6006750.04220439 | 2113913.29046831 | 37.78478433283 | -122.420372119329 | (37.78478433283, -122.420372119329) | 7 | 9 | 9 | 28858 | 36 | ||
| 3244 | 208266 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 4 | Median : Yard | Tree | DPW 1 | 5 | Width 8ft | 5996189.57852 | 2098600.11131 | 37.7421375150253 | -122.455800307749 | (37.7421375150253, -122.455800307749) | 9 | 7 | 4 | 59 | 40 | |||
| 8998 | 208278 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 20 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 5995821.66146 | 2098283.49942 | 37.7412470549149 | -122.457049545217 | (37.7412470549149, -122.457049545217) | 9 | 7 | 4 | 59 | 40 | |||
| 14772 | 208283 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 26 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 5995702.36182 | 2098208.09954 | 37.7410331736343 | -122.457456584654 | (37.7410331736343, -122.457456584654) | 9 | 7 | 4 | 59 | 40 | |||
| 33234 | 208271 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 9 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 5996099.48169 | 2098476.66946 | 37.7417934029459 | -122.456102909823 | (37.7417934029459, -122.456102909823) | 9 | 7 | 4 | 59 | 40 | |||
| 43776 | 208281 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 24 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 5995743.57726 | 2098234.61643 | 37.7411083497847 | -122.457315995454 | (37.7411083497847, -122.457315995454) | 1 | 7 | 4 | 59 | 40 | |||
| 57541 | 208282 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 25 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 5995723.55413 | 2098221.53866 | 37.7410712913969 | -122.45738428187 | (37.7410712913969, -122.45738428187) | 9 | 7 | 4 | 59 | 40 | |||
| 61774 | 208267 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 5 | Median : Yard | Tree | DPW 1 | 2 | Width 8ft | 5996171.15306 | 2098570.80404 | 37.7420559870035 | -122.455861898701 | (37.7420559870035, -122.455861898701) | 9 | 7 | 4 | 59 | 40 | |||
| 73817 | 208264 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 1 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 5996224.40551 | 2098673.0355 | 37.7423397455987 | -122.455685157643 | (37.7423397455987, -122.455685157643) | 9 | 7 | 4 | 59 | 40 | |||
| 82528 | 208269 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 7 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 5996138.33351 | 2098519.81732 | 37.7419141063617 | -122.455971692433 | (37.7419141063617, -122.455971692433) | 9 | 7 | 4 | 59 | 40 | |||
| 87655 | 208280 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 23 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 5995763.59231 | 2098247.30886 | 37.74114434962 | -122.457247709038 | (37.74114434962, -122.457247709038) | 1 | 7 | 4 | 59 | 40 | |||
| 89885 | 208265 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 3 | Median : Yard | Tree | DPW 1 | 3 | Width 8ft | 5996197.71475 | 2098618.83624 | 37.7421893960176 | -122.455773528635 | (37.7421893960176, -122.455773528635) | 9 | 7 | 4 | 59 | 40 | |||
| 125525 | 208274 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 16 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 5995908.48685 | 2098342.99725 | 37.7414154070883 | -122.456753637694 | (37.7414154070883, -122.456753637694) | 9 | 7 | 4 | 59 | 40 | |||
| 144790 | 208270 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 8 | Median : Yard | Tree | DPW 1 | 3 | Width 8ft | 5996116.90771 | 2098495.20016 | 37.7418452839221 | -122.456043996142 | (37.7418452839221, -122.456043996142) | 9 | 7 | 4 | 59 | 40 | |||
| 164990 | 208276 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 18 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 5995860.94135 | 2098310.05696 | 37.7413222310459 | -122.456915650551 | (37.7413222310459, -122.456915650551) | 9 | 7 | 4 | 59 | 40 | |||
| 166464 | 208277 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 19 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 5995843.66013 | 2098298.46411 | 37.7412894075713 | -122.456974564246 | (37.7412894075713, -122.456974564246) | 9 | 7 | 4 | 59 | 40 | |||
| 171698 | 208272 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 10 | Median : Yard | Tree | DPW 1 | 3 | Width 8ft | 5996077.78984 | 2098457.84211 | 37.741740462546 | -122.456176551714 | (37.741740462546, -122.456176551714) | 9 | 7 | 4 | 59 | 40 | |||
| 175846 | 208275 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 17 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 5995884.52069 | 2098326.53098 | 37.741368818629 | -122.456835313194 | (37.741368818629, -122.456835313194) | 9 | 7 | 4 | 59 | 40 | |||
| 184665 | 208279 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 22 | Median : Cutout | Tree | DPW 1 | 4 | Width 3ft | 5995785.55074 | 2098260.3465 | 37.7411814088878 | -122.457172728052 | (37.7411814088878, -122.457172728052) | 9 | 7 | 4 | 59 | 40 | |||
| 186426 | 208268 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 6 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 5996154.348 | 2098544.93343 | 37.741983988173 | -122.455918135114 | (37.741983988173, -122.455918135114) | 9 | 7 | 4 | 59 | 40 | |||
| 36139 | 130065 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950 O'Farrell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6006627.08364 | 2113945.84938 | 37.7848668020145 | -122.420799828673 | (37.7848668020145, -122.420799828673) | 13 | 9 | 9 | 28858 | 36 | |||
| 107060 | 4706 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2017 09:29:00 PM | 3 | 4x4 | 6008667.8262 | 2120581.3066 | 37.8032009492885 | -122.414209123056 | (37.8032009492885, -122.414209123056) | 3 | 1 | 10 | 308 | 23 | ||
| 51856 | 200468 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6015694.93546 | 2102101.98385 | 37.7528530586416 | -122.388600687393 | (37.7528530586416, -122.388600687393) | 10 | 3 | 8 | 28856 | 29 | |||
| 95913 | 200467 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 950 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6015711.58317 | 2102102.5944 | 37.7528556576711 | -122.388543158635 | (37.7528556576711, -122.388543158635) | 10 | 3 | 8 | 28856 | 29 | |||
| 254 | 130309 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 95 Vallejo St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013009.60555 | 2119229.44522 | 37.7997319839043 | -122.399089221411 | (37.7997319839043, -122.399089221411) | 3 | 1 | 10 | 28860 | 6 | |||
| 81163 | 130304 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 95 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012919.28458 | 2119217.06493 | 37.7996929569198 | -122.399400897642 | (37.7996929569198, -122.399400897642) | 3 | 1 | 10 | 28860 | 6 | |||
| 84926 | 130307 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 95 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012979.2591 | 2119225.64994 | 37.7997198718298 | -122.399193965431 | (37.7997198718298, -122.399193965431) | 3 | 1 | 10 | 28860 | 6 | |||
| 109922 | 130305 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 95 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012938.27563 | 2119219.13003 | 37.7996996856476 | -122.399335326274 | (37.7996996856476, -122.399335326274) | 3 | 1 | 10 | 28860 | 6 | |||
| 128964 | 130308 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 95 Vallejo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012995.28331 | 2119227.04032 | 37.7997245824879 | -122.399138613059 | (37.7997245824879, -122.399138613059) | 3 | 1 | 10 | 28860 | 6 | |||
| 131697 | 130306 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 95 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012956.10621 | 2119224.64959 | 37.7997158347829 | -122.399274013203 | (37.7997158347829, -122.399274013203) | 3 | 1 | 10 | 28860 | 6 | |||
| 19611 | 171230 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 95 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6003563.26251 | 2092861.65993 | 37.7268014543988 | -122.429895193205 | (37.7268014543988, -122.429895193205) | 9 | 7 | 6 | 28861 | 5 | ||
| 105564 | 173929 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 95 High St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999870 | 2100717 | 37.7481605193068 | -122.443226610241 | (37.7481605193068, -122.443226610241) | 2 | 4 | 5 | 63 | 22 | |||||
| 20677 | 64983 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 95 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/24/1989 12:00:00 AM | Permit Number 26021 | 6005946.03067017 | 2099918.9435099 | 37.7463138322094 | -122.422159177188 | (37.7463138322094, -122.422159177188) | 2 | 7 | 5 | 28859 | 22 | ||
| 52889 | 102473 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 95 Duboce Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777498 | 6006146.9 | 2108444.4 | 37.7697340787486 | -122.42207014677 | (37.7697340787486, -122.42207014677) | 8 | 4 | 7 | 28853 | 19 | |
| 184165 | 228854 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 95 Duboce Ave | 4 | : | Tree | Private 2 | 2 | Width 3ft | 6006183.01626 | 2108471.01888 | 37.7698092047702 | -122.421947112663 | (37.7698092047702, -122.421947112663) | 8 | 4 | 7 | 28853 | 19 | |||
| 2552 | 42536 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 95 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42642 | 6006853.97359683 | 2109407.99798814 | 37.7724197439799 | -122.419692774816 | (37.7724197439799, -122.419692774816) | 8 | 2 | 9 | 28853 | 19 | ||
| 44998 | 228792 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 95 Brady St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006796.8966 | 2109442.26448 | 37.7725106162115 | -122.41989264203 | (37.7725106162115, -122.41989264203) | 8 | 2 | 9 | 28853 | 19 | |||
| 171463 | 228791 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 95 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006825.40611 | 2109415.85044 | 37.7724396956581 | -122.419792149982 | (37.7724396956581, -122.419792149982) | 8 | 2 | 9 | 28853 | 19 | |||
| 172683 | 42537 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 95 Brady St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42642 | 6006853.97359683 | 2109407.99798814 | 37.7724197439799 | -122.419692774816 | (37.7724197439799, -122.419692774816) | 8 | 2 | 9 | 28853 | 19 | ||
| 130781 | 255652 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 949 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002910 | 2110236 | 37.7744702748436 | -122.433394524315 | (37.7744702748436, -122.433394524315) | 15 | 5 | 11 | 29492 | 10 | ||||
| 152234 | 255608 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 949 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002910 | 2110236 | 37.7744702748436 | -122.433394524315 | (37.7744702748436, -122.433394524315) | 15 | 5 | 11 | 29492 | 10 | ||||
| 46460 | 229140 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 948 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007548.72229 | 2104122.84955 | 37.7579470714194 | -122.41691504342 | (37.7579470714194, -122.41691504342) | 2 | 4 | 7 | 28859 | 19 | |||
| 139467 | 61154 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 948 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1983 12:00:00 AM | 12 | Permit Number 21012 | 6007556.98547872 | 2104132.97417083 | 37.7579753361009 | -122.416887183061 | (37.7579753361009, -122.416887183061) | 2 | 4 | 7 | 28859 | 19 | |
| 98087 | 64731 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 948 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1988 12:00:00 AM | Permit Number 25689 | 6001590.74428115 | 2109084.81809315 | 37.7712344828258 | -122.437875602983 | (37.7712344828258, -122.437875602983) | 15 | 5 | 11 | 29492 | 9 | ||
| 97808 | 11961 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 945X Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/13/1999 12:00:00 AM | 6 | 3X3 | 6015820.0973 | 2096449.8462 | 37.7373403917231 | -122.38777351408 | (37.7373403917231, -122.38777351408) | 10 | 3 | 8 | 58 | 1 | ||
| 149058 | 62839 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 945 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1994 12:00:00 AM | 3x3 | Permit Number 23206 | 6001935.32608744 | 2111693.22284411 | 37.7784160988653 | -122.436870443396 | (37.7784160988653, -122.436870443396) | 15 | 5 | 11 | 29490 | 41 | |
| 78362 | 65408 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 945 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/1989 12:00:00 AM | 11 | Permit Number 28259 | 6007355.19856 | 2114656.88253 | 37.7868601376423 | -122.41833121301 | (37.7868601376423, -122.41833121301) | 13 | 9 | 9 | 28858 | 36 | |
| 109832 | 113557 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 945 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6007359.26512 | 2114624.80979 | 37.7867723026556 | -122.418314868742 | (37.7867723026556, -122.418314868742) | 13 | 9 | 9 | 28858 | 36 | |||
| 1472 | 2091 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 943 Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1992 12:00:00 AM | 6 | 2X2 | 6001433.65825 | 2095553.49813 | 37.7340717929056 | -122.437449841319 | (37.7340717929056, -122.437449841319) | 9 | 7 | 5 | 63 | 40 | ||
| 74204 | 208313 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 943 Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6001440.29748 | 2095559.0536 | 37.7340874243968 | -122.437427285162 | (37.7340874243968, -122.437427285162) | 9 | 7 | 5 | 63 | 40 | |||
| 171420 | 2090 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 943 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1998 12:00:00 AM | 6 | 2X2 | 6001422.13519 | 2095563.80022 | 37.7340994249407 | -122.437490417543 | (37.7340994249407, -122.437490417543) | 9 | 7 | 5 | 63 | 40 | ||
| 93653 | 61174 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 942 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/1983 12:00:00 AM | 14 | 3x3 | Permit Number 51925 | 6007555.1280157 | 2104166.49742661 | 37.7580672787755 | -122.416895982052 | (37.7580672787755, -122.416895982052) | 2 | 4 | 7 | 28859 | 19 | |
| 126758 | 229139 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 942 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007548.20945 | 2104145.0096 | 37.7580078889763 | -122.416918387071 | (37.7580078889763, -122.416918387071) | 2 | 4 | 7 | 28859 | 19 | |||
| 15655 | 5546 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 941 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/1991 12:00:00 AM | 20 | 3X3 | 6005114.25506 | 2102860.25848 | 37.7543430527119 | -122.425244623562 | (37.7543430527119, -122.425244623562) | 2 | 4 | 5 | 28859 | 19 | ||
| 5312 | 4705 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 940 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2017 09:01:00 PM | 3 | 3X3 | 6008689.9314 | 2120561.6575 | 37.8031482394038 | -122.414131236147 | (37.8031482394038, -122.414131236147) | 3 | 1 | 10 | 308 | 23 | ||
| 14538 | 24055 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 94 Westbrook Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/23/1995 12:00:00 AM | 3 | 3X4 | 6017158.2314746 | 2095597.9943854 | 37.7350754118257 | -122.383087646111 | (37.7350754118257, -122.383087646111) | 10 | 3 | 8 | 58 | 1 | ||
| 152031 | 24054 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 94 Westbrook Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2006 12:00:00 AM | 3 | 3X4 | 6017158.2314746 | 2095597.9943854 | 37.7350754118257 | -122.383087646111 | (37.7350754118257, -122.383087646111) | 10 | 3 | 8 | 58 | 1 | ||
| 105 | 70839 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 939 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6010931.16123 | 2112337.60471 | 37.780692593337 | -122.405795716794 | (37.780692593337, -122.405795716794) | 14 | 2 | 9 | 28853 | 34 | |||
| 9458 | 84830 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 939 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | Permit No. 49222 | 6002944 | 2110261 | 37.7745408475216 | -122.433278698665 | (37.7745408475216, -122.433278698665) | 15 | 5 | 11 | 29492 | 10 | |||
| 9525 | 23031 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 938 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/1992 12:00:00 AM | 25 | 3X3 | 6006272.23654 | 2104114.42979 | 37.7578520679407 | -122.421329079684 | (37.7578520679407, -122.421329079684) | 2 | 4 | 5 | 28859 | 19 | ||
| 62565 | 229120 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 937 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007612.77808 | 2104181.24413 | 37.7581110124402 | -122.416697647604 | (37.7581110124402, -122.416697647604) | 2 | 4 | 7 | 28859 | 19 | |||
| 119414 | 37715 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 937 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40174 | 6007605.19091424 | 2104202.89749579 | 37.7581700408754 | -122.416725421335 | (37.7581700408754, -122.416725421335) | 2 | 4 | 7 | 28859 | 19 | ||
| 151352 | 229121 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 937 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007612.06774 | 2104193.77785 | 37.7581453872033 | -122.416700992181 | (37.7581453872033, -122.416700992181) | 2 | 4 | 7 | 28859 | 19 | |||
| 117052 | 192726 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 937 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015811.55205 | 2096447.95882 | 37.7373347359926 | -122.387802927581 | (37.7373347359926, -122.387802927581) | 10 | 3 | 8 | 58 | 1 | |||
| 70484 | 173725 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 935X Carolina St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3x3 | 6012507 | 2103301 | 37.7559681076303 | -122.399709410552 | (37.7559681076303, -122.399709410552) | 10 | 3 | 8 | 28856 | 29 | |||
| 141909 | 200417 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 935 Natoma St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6008113.03947 | 2109977.64145 | 37.774054694589 | -122.415377866415 | (37.774054694589, -122.415377866415) | 8 | 2 | 9 | 28853 | 34 | |||
| 130600 | 15035 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 935 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6015831.55387 | 2096480.33516 | 37.7374247428521 | -122.387736029711 | (37.7374247428521, -122.387736029711) | 10 | 3 | 8 | 58 | 1 | ||
| 146071 | 23033 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 934 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/08/1995 12:00:00 AM | 18 | 3x3 | 6006271.44539 | 2104141.8803 | 37.7579273960556 | -122.421333765148 | (37.7579273960556, -122.421333765148) | 2 | 4 | 5 | 28859 | 19 | ||
| 177643 | 3747 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 934 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 6 | 18 | 6012421.5071398 | 2103592.6632765 | 37.756764184951 | -122.400025556542 | (37.756764184951, -122.400025556542) | 10 | 3 | 8 | 28856 | 29 | |||
| 78370 | 216714 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 934 Capitol Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/13/2017 11:10:00 AM | 3 | Width 3ft | 5995052.94253 | 2090158.75041 | 37.7188942912315 | -122.459119311509 | (37.7188942912315, -122.459119311509) | 9 | 8 | 6 | 28861 | 24 | ||
| 95419 | 228618 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 933 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002511.0479 | 2102806.4695 | 37.7540479509586 | -122.434243320888 | (37.7540479509586, -122.434243320888) | 2 | 4 | 5 | 28862 | 22 | |||
| 142519 | 66521 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 933 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1991 12:00:00 AM | Permit Number 29692 | 6002502.27879018 | 2102872.37938021 | 37.754228426046 | -122.434278358266 | (37.754228426046, -122.434278358266) | 2 | 4 | 5 | 28862 | 22 | ||
| 28778 | 229122 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 931 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007611.48228 | 2104212.40796 | 37.7581965082758 | -122.41670433675 | (37.7581965082758, -122.41670433675) | 2 | 4 | 7 | 28859 | 19 | |||
| 52774 | 229123 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 931 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6007608.62803 | 2104230.44258 | 37.7582458666636 | -122.416715485625 | (37.7582458666636, -122.416715485625) | 2 | 4 | 7 | 28859 | 19 | |||
| 169232 | 61165 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 931 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1983 12:00:00 AM | Permit Number 21023 | 6007603.33345064 | 2104236.42076201 | 37.7582619835876 | -122.416734220151 | (37.7582619835876, -122.416734220151) | 2 | 4 | 7 | 28859 | 19 | ||
| 20473 | 208314 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 931 Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001504.4065 | 2095542.47222 | 37.7340455402682 | -122.437204453845 | (37.7340455402682, -122.437204453845) | 9 | 7 | 5 | 63 | 40 | |||
| 187616 | 2088 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 931 Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2x2 | 6001485.24516 | 2095489.86478 | 37.73390000314 | -122.437266934857 | (37.73390000314, -122.437266934857) | 9 | 7 | 5 | 63 | 40 | |||
| 64259 | 87324 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 930 Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6009381.28758 | 2116066.77313 | 37.7908451991044 | -122.411421029278 | (37.7908451991044, -122.411421029278) | 5 | 1 | 10 | 28857 | 21 | |||
| 181804 | 34837 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 930 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2003 12:00:00 AM | 6 | 3x3 | Permit Number 50324 | 6009479.19554 | 2116081.10239 | 37.7908900347851 | -122.411083283466 | (37.7908900347851, -122.411083283466) | 5 | 1 | 10 | 28857 | 21 | |
| 192849 | 87323 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 930 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50324 | 6009422.52318 | 2116071.79921 | 37.7908613122503 | -122.41127871064 | (37.7908613122503, -122.41127871064) | 5 | 1 | 10 | 28857 | 21 | |
| 64705 | 22609 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 930 Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005730.73962 | 2112868.83134 | 37.7818590138259 | -122.423824283019 | (37.7818590138259, -122.423824283019) | 7 | 9 | 11 | 28852 | 41 | |||
| 72977 | 22608 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 930 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2014 12:00:00 AM | 12 | 3X3 | Permit Number 773338 | 6005709.30898 | 2112889.96844 | 37.7819158412791 | -122.423899926655 | (37.7819158412791, -122.423899926655) | 7 | 9 | 11 | 28852 | 41 | |
| 87212 | 22607 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 930 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1995 12:00:00 AM | 18 | 3X3 | 6005711.80884 | 2112867.84958 | 37.7818552494496 | -122.423889704968 | (37.7818552494496, -122.423889704968) | 7 | 9 | 11 | 28852 | 41 | ||
| 96487 | 116643 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 930 Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3X3 | 6005704.65442 | 2112915.07382 | 37.7819845117139 | -122.423917815076 | (37.7819845117139, -122.423917815076) | 7 | 9 | 11 | 28852 | 41 | |||
| 116159 | 4703 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 930 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/19/1984 12:00:00 AM | 36 | 5x6 | 6008724.3173 | 2120532.798 | 37.8030709297568 | -122.41401019958 | (37.8030709297568, -122.41401019958) | 3 | 1 | 10 | 308 | 23 | ||
| 87441 | 24052 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 93 Westbrook Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2006 12:00:00 AM | 3 | 3X3 | 6017188.0111399 | 2095557.1437591 | 37.734964889641 | -122.382981843975 | (37.734964889641, -122.382981843975) | 10 | 3 | 8 | 58 | 1 | ||
| 170766 | 24053 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 93 Westbrook Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/1995 12:00:00 AM | 12 | 3X3 | 6017188.0111399 | 2095557.1437591 | 37.734964889641 | -122.382981843975 | (37.734964889641, -122.382981843975) | 10 | 3 | 8 | 58 | 1 | ||
| 51733 | 228712 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 93 Buena Vista Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001481.64391 | 2107687.80894 | 37.76739243775 | -122.438152893264 | (37.76739243775, -122.438152893264) | 15 | 5 | 5 | 29492 | 3 | |||
| 133534 | 100066 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 93 Buena Vista Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2012 12:00:00 AM | 2x2 | Permit Number 768610 | 6001505.1 | 2107681.4 | 37.7673761743712 | -122.438071302911 | (37.7673761743712, -122.438071302911) | 15 | 5 | 5 | 29492 | 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) );