trees
576 rows where Neighborhoods (old) = 19 and qSpecies_id = 50 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
175900 | 229803 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1 Sycamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006754.85376 | 2105853.73018 | 37.7626549800545 | -122.419783396906 | (37.7626549800545, -122.419783396906) | 8 | 4 | 7 | 28859 | 19 | |||
48019 | 190731 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 100 Utah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010525.63223 | 2107742.12089 | 37.7680517730114 | -122.406874662236 | (37.7680517730114, -122.406874662236) | 8 | 4 | 8 | 28853 | 19 | |||
63833 | 190728 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 100 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6010522.48931 | 2107817.1778 | 37.7682576862591 | -122.406890823964 | (37.7682576862591, -122.406890823964) | 8 | 4 | 8 | 28853 | 19 | |||
102667 | 190730 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 100 Utah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010525.46494 | 2107766.85443 | 37.7681196762964 | -122.406876984296 | (37.7681196762964, -122.406876984296) | 8 | 4 | 8 | 28853 | 19 | |||
151047 | 190732 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 100 Utah St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010527.29182 | 2107717.8289 | 37.7679851656226 | -122.406867209579 | (37.7679851656226, -122.406867209579) | 8 | 4 | 8 | 28853 | 19 | |||
175279 | 190729 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 100 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010522.64899 | 2107794.80164 | 37.7681962553765 | -122.406888694378 | (37.7681962553765, -122.406888694378) | 8 | 4 | 8 | 28853 | 19 | |||
99838 | 228533 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009349.90879 | 2107361.21702 | 37.7669400409627 | -122.410914473531 | (37.7669400409627, -122.410914473531) | 8 | 4 | 7 | 28853 | 19 | |||
117876 | 228535 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009303.88793 | 2107359.35357 | 37.766932343692 | -122.411073521351 | (37.766932343692, -122.411073521351) | 8 | 4 | 7 | 28853 | 19 | |||
131487 | 228534 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009327.35781 | 2107359.80868 | 37.7669349094434 | -122.410992374607 | (37.7669349094434, -122.410992374607) | 8 | 4 | 7 | 28853 | 19 | |||
139411 | 228538 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009238.10189 | 2107354.62318 | 37.7669156657401 | -122.411300731452 | (37.7669156657401, -122.411300731452) | 8 | 4 | 7 | 28853 | 19 | |||
154249 | 228539 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009212.74652 | 2107353.73928 | 37.7669118166657 | -122.411388369502 | (37.7669118166657, -122.411388369502) | 8 | 4 | 7 | 28853 | 19 | |||
175061 | 228532 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009375.26414 | 2107362.10106 | 37.7669438900682 | -122.410826835502 | (37.7669438900682, -122.410826835502) | 8 | 4 | 7 | 28853 | 19 | |||
177993 | 228536 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009279.45147 | 2107357.51638 | 37.7669259288053 | -122.411157913712 | (37.7669259288053, -122.411157913712) | 8 | 4 | 7 | 28853 | 19 | |||
194227 | 228537 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009258.78622 | 2107356.53697 | 37.7669220806253 | -122.411229322595 | (37.7669220806253, -122.411229322595) | 8 | 4 | 7 | 28853 | 19 | |||
26703 | 101946 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1045 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007665.9 | 2103581.6 | 37.7564675147494 | -122.41647145397 | (37.7564675147494, -122.41647145397) | 2 | 4 | 7 | 28859 | 19 | |||
170166 | 226315 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1045 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007642.72664 | 2103585.2825 | 37.756476322828 | -122.416551856705 | (37.756476322828, -122.416551856705) | 2 | 4 | 7 | 28859 | 19 | |||
176666 | 96068 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1055 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767693 | 6008044 | 2101787 | 37.7515612062089 | -122.415036827298 | (37.7515612062089, -122.415036827298) | 2 | 4 | 7 | 28859 | 19 | |
178217 | 226324 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1055 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008046.21468 | 2101786.36501 | 37.7515595871229 | -122.415029123693 | (37.7515595871229, -122.415029123693) | 2 | 4 | 7 | 28859 | 19 | |||
78698 | 173775 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 1057 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/2018 12:00:00 AM | 3 | 4x4 | Permit Number 779347 | 6009462.91602 | 2103024.17334 | 37.7550378411013 | -122.410217357343 | (37.7550378411013, -122.410217357343) | 2 | 4 | 7 | 28859 | 19 | |
28301 | 226433 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006663.83853 | 2103099.55931 | 37.7550875384663 | -122.419902738742 | (37.7550875384663, -122.419902738742) | 2 | 4 | 7 | 28859 | 19 | |||
44484 | 226429 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006669.22772 | 2102968.64373 | 37.7547283780289 | -122.419874812075 | (37.7547283780289, -122.419874812075) | 2 | 4 | 7 | 28859 | 19 | |||
53093 | 226430 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006668.67931 | 2102994.38705 | 37.7547990323663 | -122.419878535269 | (37.7547990323663, -122.419878535269) | 2 | 4 | 7 | 28859 | 19 | |||
68745 | 226432 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006660.51047 | 2103068.53452 | 37.7550021640414 | -122.41991204672 | (37.7550021640414, -122.41991204672) | 2 | 4 | 7 | 28859 | 19 | |||
69822 | 226431 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006664.92393 | 2103021.2685 | 37.7548726310745 | -122.419893429847 | (37.7548726310745, -122.419893429847) | 2 | 4 | 7 | 28859 | 19 | |||
79294 | 226434 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006662.06006 | 2103117.82252 | 37.7551375848404 | -122.419910185127 | (37.7551375848404, -122.419910185127) | 2 | 4 | 7 | 28859 | 19 | |||
109114 | 226436 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006661.69832 | 2103152.67554 | 37.7552332628263 | -122.419913909217 | (37.7552332628263, -122.419913909217) | 2 | 4 | 7 | 28859 | 19 | |||
128732 | 226427 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006674.0476 | 2102914.93571 | 37.7545811796958 | -122.419854332733 | (37.7545811796958, -122.419854332733) | 2 | 4 | 7 | 28859 | 19 | |||
191365 | 226435 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006660.81941 | 2103136.07502 | 37.7551876321062 | -122.419915770819 | (37.7551876321062, -122.419915770819) | 2 | 4 | 7 | 28859 | 19 | |||
192973 | 226428 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006671.33563 | 2102940.18758 | 37.7546503627401 | -122.419865503217 | (37.7546503627401, -122.419865503217) | 2 | 4 | 7 | 28859 | 19 | |||
83277 | 226415 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1072 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009167.57752 | 2102926.63896 | 37.754753474499 | -122.411231837073 | (37.754753474499, -122.411231837073) | 2 | 4 | 7 | 28859 | 19 | |||
106987 | 37008 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1072 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39622 | 6009161.44708429 | 2102917.71033779 | 37.7547286146948 | -122.411252407188 | (37.7547286146948, -122.411252407188) | 2 | 4 | 7 | 28859 | 19 | ||
13796 | 46609 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1078 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2002 12:00:00 AM | Permit Number 44732 | 6010490.67134457 | 2102955.14321265 | 37.7549058552549 | -122.406658202843 | (37.7549058552549, -122.406658202843) | 10 | 4 | 7 | 28859 | 19 | |||
55105 | 39192 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1081 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1998 12:00:00 AM | Permit Number 40845 | 6008661.50268126 | 2102262.13718449 | 37.7529005072206 | -122.412935008702 | (37.7529005072206, -122.412935008702) | 2 | 4 | 7 | 28859 | 19 | |||
121210 | 229830 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1097 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6010012.5891 | 2102852.11627 | 37.7545962064773 | -122.408304286625 | (37.7545962064773, -122.408304286625) | 2 | 4 | 7 | 28859 | 19 | |||
142531 | 43929 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1097x York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2003 12:00:00 AM | Permit Number 43519 | 6010038 | 2102851 | 37.7545945643559 | -122.408216329842 | (37.7545945643559, -122.408216329842) | 2 | 4 | 7 | 28859 | 19 | ||
14306 | 35546 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 110 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.7551593447884 | -122.419928417644 | (37.7551593447884, -122.419928417644) | 2 | 4 | 7 | 28859 | 19 | ||
47921 | 35543 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 110 Bartlett St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.7551593447884 | -122.419928417644 | (37.7551593447884, -122.419928417644) | 2 | 4 | 7 | 28859 | 19 | ||
56991 | 35544 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 110 Bartlett St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.7551593447884 | -122.419928417644 | (37.7551593447884, -122.419928417644) | 2 | 4 | 7 | 28859 | 19 | ||
134370 | 35545 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 110 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.7551593447884 | -122.419928417644 | (37.7551593447884, -122.419928417644) | 2 | 4 | 7 | 28859 | 19 | ||
158000 | 35547 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 110 Bartlett St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.7551593447884 | -122.419928417644 | (37.7551593447884, -122.419928417644) | 2 | 4 | 7 | 28859 | 19 | ||
192044 | 35542 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 110 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.7551593447884 | -122.419928417644 | (37.7551593447884, -122.419928417644) | 2 | 4 | 7 | 28859 | 19 | ||
35536 | 34771 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1112 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 11 | Permit Number 38413 | 6008023.83866277 | 2101437.17080746 | 37.7505995211504 | -122.415081788574 | (37.7505995211504, -122.415081788574) | 2 | 4 | 7 | 28859 | 19 | |
121695 | 34770 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1112 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 11 | Permit Number 38413 | 6008023.83866277 | 2101437.17080746 | 37.7505995211504 | -122.415081788574 | (37.7505995211504, -122.415081788574) | 2 | 4 | 7 | 28859 | 19 | |
124310 | 34772 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1112 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 11 | Permit Number 38413 | 6008023.83866277 | 2101437.17080746 | 37.7505995211504 | -122.415081788574 | (37.7505995211504, -122.415081788574) | 2 | 4 | 7 | 28859 | 19 | |
125641 | 225915 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1115 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779648 | 6010030.36922 | 2102582.89023 | 37.7538579673932 | -122.408223810779 | (37.7538579673932, -122.408223810779) | 2 | 4 | 7 | 28859 | 19 | |
56974 | 226417 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1116 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008029.19909 | 2101392.11657 | 37.7504761135956 | -122.415060063068 | (37.7504761135956, -122.415060063068) | 2 | 4 | 7 | 28859 | 19 | |||
145243 | 226418 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1116 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008030.04777 | 2101411.71526 | 37.7505299748764 | -122.415058515332 | (37.7505299748764, -122.415058515332) | 2 | 4 | 7 | 28859 | 19 | |||
94876 | 226416 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1118 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008031.51023 | 2101373.79083 | 37.7504259251155 | -122.415050773974 | (37.7504259251155, -122.415050773974) | 2 | 4 | 7 | 28859 | 19 | |||
108448 | 229836 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 112 San Carlos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006642.16012 | 2105416.67615 | 37.7614485827148 | -122.420142145449 | (37.7614485827148, -122.420142145449) | 2 | 4 | 7 | 28859 | 19 | |||
61958 | 34774 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1139 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1999 12:00:00 AM | Permit Number 38415 | 6008083.82317224 | 2101294.64403942 | 37.750211545435 | -122.414864270544 | (37.750211545435, -122.414864270544) | 2 | 4 | 7 | 28859 | 19 | ||
181150 | 226323 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1139 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008076.0678 | 2101289.03077 | 37.7501956968847 | -122.414890691951 | (37.7501956968847, -122.414890691951) | 2 | 4 | 7 | 28859 | 19 | |||
173888 | 51288 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1143 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/2004 12:00:00 AM | Permit Number 47660 | 6009497.00762937 | 2102519.03673443 | 37.7536527600356 | -122.410063798952 | (37.7536527600356, -122.410063798952) | 2 | 4 | 7 | 28859 | 19 | ||
123697 | 229858 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 115 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6005418.69368 | 2103014.66569 | 37.7547842133232 | -122.424202776932 | (37.7547842133232, -122.424202776932) | 2 | 4 | 5 | 28859 | 19 | |||
83390 | 226322 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1153 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008078.2472 | 2101222.93823 | 37.7500143440966 | -122.414878478273 | (37.7500143440966, -122.414878478273) | 2 | 4 | 7 | 28859 | 19 | |||
117197 | 34779 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1153 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38418 | 6008088.1654875 | 2101216.34832832 | 37.7499968070134 | -122.414843713866 | (37.7499968070134, -122.414843713866) | 2 | 4 | 7 | 28859 | 19 | ||
117450 | 226321 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1153 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008080.72157 | 2101209.59973 | 37.7499778586098 | -122.414868977829 | (37.7499778586098, -122.414868977829) | 2 | 4 | 7 | 28859 | 19 | |||
141115 | 34778 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1153 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38418 | 6008088.1654875 | 2101216.34832832 | 37.7499968070134 | -122.414843713866 | (37.7499968070134, -122.414843713866) | 2 | 4 | 7 | 28859 | 19 | ||
94181 | 34791 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1165 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/2002 12:00:00 AM | Permit Number 38427 | 6008689.09005555 | 2101767.92143829 | 37.7515450503444 | -122.412804668606 | (37.7515450503444, -122.412804668606) | 2 | 4 | 7 | 28859 | 19 | ||
26900 | 35554 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 117 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38928 | 6005427.85924462 | 2103026.46196551 | 37.754817120668 | -122.424171918741 | (37.754817120668, -122.424171918741) | 2 | 4 | 5 | 28859 | 19 | ||
56905 | 34792 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1171 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38428 | 6008691.00817577 | 2101734.24862099 | 37.7514527000041 | -122.412795655117 | (37.7514527000041, -122.412795655117) | 2 | 4 | 7 | 28859 | 19 | ||
59072 | 226414 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1174 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009199.3273 | 2102350.17557 | 37.7531724159966 | -122.411081321155 | (37.7531724159966, -122.411081321155) | 2 | 4 | 7 | 28859 | 19 | |||
51280 | 229857 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 119 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005419.16743 | 2102997.26245 | 37.7547364548257 | -122.42419990093 | (37.7547364548257, -122.42419990093) | 2 | 4 | 5 | 28859 | 19 | |||
121690 | 229856 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 119 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005420.32438 | 2102982.74414 | 37.7546966562501 | -122.424194867403 | (37.7546966562501, -122.424194867403) | 2 | 4 | 5 | 28859 | 19 | |||
82268 | 229743 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 120 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005873.02878 | 2106520.6426 | 37.7644364480055 | -122.422880717778 | (37.7644364480055, -122.422880717778) | 8 | 4 | 5 | 28859 | 19 | |||
130757 | 35314 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 120 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | 6 | 3x3 | Permit Number 38781 | 6005865.10533901 | 2106546.77110861 | 37.7645077436281 | -122.422909979953 | (37.7645077436281, -122.422909979953) | 8 | 4 | 5 | 28859 | 19 |
1084 | 229775 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011442.57459 | 2102566.84517 | 37.7538928862632 | -122.403338920978 | (37.7538928862632, -122.403338920978) | 10 | 4 | 8 | 28859 | 19 | |||
15057 | 229773 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011446.65854 | 2102520.54386 | 37.7537659811344 | -122.403321540662 | (37.7537659811344, -122.403321540662) | 10 | 4 | 8 | 28859 | 19 | |||
18290 | 229761 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6011456.4035 | 2102287.48645 | 37.7531266009123 | -122.403271446634 | (37.7531266009123, -122.403271446634) | 10 | 4 | 8 | 28859 | 19 | |||
29151 | 229756 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011464.15557 | 2102190.87321 | 37.7528617550894 | -122.403237842573 | (37.7528617550894, -122.403237842573) | 10 | 4 | 8 | 28859 | 19 | |||
36074 | 229770 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011448.51225 | 2102466.33912 | 37.753617250357 | -122.403311317166 | (37.753617250357, -122.403311317166) | 10 | 4 | 8 | 28859 | 19 | |||
38692 | 229763 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 6011453.21392 | 2102329.36922 | 37.7532414236718 | -122.403285422977 | (37.7532414236718, -122.403285422977) | 10 | 4 | 8 | 28859 | 19 | |||
41300 | 229766 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6011452.91917 | 2102390.65584 | 37.7534096868171 | -122.403290753279 | (37.7534096868171, -122.403290753279) | 10 | 4 | 8 | 28859 | 19 | |||
41670 | 229778 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 48 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011440.8047 | 2102625.16918 | 37.7540529323224 | -122.403349144463 | (37.7540529323224, -122.403349144463) | 10 | 4 | 8 | 28859 | 19 | |||
54681 | 229760 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011458.91565 | 2102265.65077 | 37.7530667852271 | -122.403261223145 | (37.7530667852271, -122.403261223145) | 10 | 4 | 8 | 28859 | 19 | |||
55327 | 229772 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011446.86383 | 2102500.86077 | 37.7537119471592 | -122.403319446151 | (37.7537119471592, -122.403319446151) | 10 | 4 | 8 | 28859 | 19 | |||
70055 | 229765 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011453.42278 | 2102371.80516 | 37.7533579551144 | -122.403287685694 | (37.7533579551144, -122.403287685694) | 10 | 4 | 8 | 28859 | 19 | |||
88805 | 229752 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011465.52618 | 2102102.51804 | 37.7526192277045 | -122.403226887931 | (37.7526192277045, -122.403226887931) | 10 | 4 | 8 | 28859 | 19 | |||
92812 | 229776 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6011441.50409 | 2102586.88485 | 37.7539478510307 | -122.40334403271 | (37.7539478510307, -122.40334403271) | 10 | 4 | 8 | 28859 | 19 | |||
93661 | 229780 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 50 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6011438.15067 | 2102669.08614 | 37.7541733704045 | -122.403361412121 | (37.7541733704045, -122.403361412121) | 10 | 4 | 8 | 28859 | 19 | |||
95325 | 229771 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011447.67718 | 2102483.4305 | 37.7536641328931 | -122.403315407293 | (37.7536641328931, -122.403315407293) | 10 | 4 | 8 | 28859 | 19 | |||
95655 | 229774 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 44 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011445.35286 | 2102545.22023 | 37.7538336641006 | -122.403327791844 | (37.7538336641006, -122.403327791844) | 10 | 4 | 8 | 28859 | 19 | |||
102641 | 229758 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011460.45759 | 2102239.71319 | 37.7529956524374 | -122.403254066338 | (37.7529956524374, -122.403254066338) | 10 | 4 | 8 | 28859 | 19 | |||
106642 | 229781 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011437.0323 | 2102686.77187 | 37.7542218690658 | -122.403366523848 | (37.7542218690658, -122.403366523848) | 10 | 4 | 8 | 28859 | 19 | |||
107367 | 229764 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011452.97986 | 2102350.02958 | 37.753298139414 | -122.403287685686 | (37.753298139414, -122.403287685686) | 10 | 4 | 8 | 28859 | 19 | |||
120093 | 229753 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011465.79162 | 2102125.84808 | 37.7526833017063 | -122.403227610989 | (37.7526833017063, -122.403227610989) | 10 | 4 | 8 | 28859 | 19 | |||
120945 | 229754 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011464.93054 | 2102145.24186 | 37.7527365046859 | -122.403231952908 | (37.7527365046859, -122.403231952908) | 10 | 4 | 8 | 28859 | 19 | |||
122297 | 229767 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011451.55336 | 2102410.70185 | 37.7534646524788 | -122.403296886638 | (37.7534646524788, -122.403296886638) | 10 | 4 | 8 | 28859 | 19 | |||
127332 | 229777 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 47 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011441.00674 | 2102606.02985 | 37.7540003912143 | -122.403347099413 | (37.7540003912143, -122.403347099413) | 10 | 4 | 8 | 28859 | 19 | |||
143926 | 229768 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011450.10406 | 2102428.33109 | 37.7535129775571 | -122.403303138733 | (37.7535129775571, -122.403303138733) | 10 | 4 | 8 | 28859 | 19 | |||
154582 | 229782 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 52 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6011435.78224 | 2102697.98371 | 37.7542525844934 | -122.403371635592 | (37.7542525844934, -122.403371635592) | 10 | 4 | 8 | 28859 | 19 | |||
159856 | 229762 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011454.29465 | 2102314.61303 | 37.7532009667707 | -122.403280647606 | (37.7532009667707, -122.403280647606) | 10 | 4 | 8 | 28859 | 19 | |||
164341 | 229751 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6011465.75975 | 2102083.13702 | 37.7525660247145 | -122.40322471697 | (37.7525660247145, -122.40322471697) | 10 | 4 | 8 | 28859 | 19 | |||
165791 | 229757 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6011461.99954 | 2102213.77594 | 37.752924520553 | -122.403246909533 | (37.752924520553, -122.403246909533) | 10 | 4 | 8 | 28859 | 19 | |||
168519 | 229779 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 49 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011439.17328 | 2102646.69218 | 37.75411193863 | -122.403356300366 | (37.75411193863, -122.403356300366) | 10 | 4 | 8 | 28859 | 19 | |||
170096 | 229769 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011449.91996 | 2102448.35306 | 37.7535679432079 | -122.403305183785 | (37.7535679432079, -122.403305183785) | 10 | 4 | 8 | 28859 | 19 | |||
187690 | 229759 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6011459.21947 | 2102251.51401 | 37.753027985753 | -122.403259178089 | (37.753027985753, -122.403259178089) | 10 | 4 | 8 | 28859 | 19 | |||
193911 | 229755 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011464.24481 | 2102169.9708 | 37.7528043666378 | -122.403236063707 | (37.7528043666378, -122.403236063707) | 10 | 4 | 8 | 28859 | 19 | |||
2399 | 121749 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 12 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
4736 | 121804 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 22 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
15956 | 121747 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 10 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 |
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) );