Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
310 | 310 | 30658 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 47 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34591 | 6007577.417719999 | 2109608.9608 | 37.7730122661246 | -122.41720454865299 | (37.7730122661246, -122.417204548653) |
13609 | 13609 | 12227 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1551 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2000 12:00:00 AM | 6 | 3X3 | 6015788.0003 | 2095930.721 | 37.735913201034606 | -122.387848277235 | (37.7359132010346, -122.387848277235) | ||
20051 | 20051 | 26498 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2710 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/1999 12:00:00 AM | 6 | 3x3 | 6008903.18819 | 2102577.2710700002 | 37.7537793576317 | -122.412121481544 | (37.7537793576317, -122.412121481544) | ||
23785 | 23785 | 226391 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1437 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008021.55589 | 2099786.31396 | 37.746066510059705 | -122.414972850429 | (37.7460665100597, -122.414972850429) | |||
24273 | 24273 | 226430 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006668.67931 | 2102994.38705 | 37.75479903236629 | -122.41987853526899 | (37.7547990323663, -122.419878535269) | |||
26038 | 26038 | 229743 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 120 Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005873.02878 | 2106520.6426 | 37.7644364480055 | -122.422880717778 | (37.7644364480055, -122.422880717778) | |||
28765 | 28765 | 35362 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 979 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 6 | Permit Number 38824 | 6011922.436290001 | 2103880.66513 | 37.75752713659001 | -122.401771780343 | (37.75752713659, -122.401771780343) | |
28977 | 28977 | 228541 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1380 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010322.60009 | 2101256.7138900002 | 37.750232939618705 | -122.407119730208 | (37.7502329396187, -122.407119730208) | |||
29888 | 29888 | 226402 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 88 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008216.93199 | 2099535.32688 | 37.745388332215704 | -122.414279508218 | (37.7453883322157, -122.414279508218) | |||
33460 | 33460 | 229759 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6011459.21947 | 2102251.51401 | 37.753027985753 | -122.403259178089 | (37.753027985753, -122.403259178089) | |||
34566 | 34566 | 190734 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 128 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010530.37912 | 2107677.75559 | 37.7678753062214 | -122.406853706245 | (37.7678753062214, -122.406853706245) | |||
38369 | 38369 | 226432 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006660.51047 | 2103068.53452 | 37.7550021640414 | -122.41991204671999 | (37.7550021640414, -122.41991204672) | |||
39582 | 39582 | 229804 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 10 Crescent Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 5ft | 6005354.49537 | 2095898.81655 | 37.7352420900484 | -122.423918818711 | (37.7352420900484, -122.423918818711) | |||
40607 | 40607 | 229785 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1366 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010846.0607900005 | 2101951.02013 | 37.7521686322761 | -122.40535845022801 | (37.7521686322761, -122.405358450228) | |||
40736 | 40736 | 226790 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 35 Yukon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000260.41701 | 2104714.6723 | 37.7591594105937 | -122.44216349005899 | (37.7591594105937, -122.442163490059) | |||
43282 | 43282 | 226795 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 677 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002427.793880001 | 2104301.04841 | 37.758146980811404 | -122.434638096272 | (37.7581469808114, -122.434638096272) | |||
44200 | 44200 | 229830 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1097 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010012.5891 | 2102852.11627 | 37.7545962064773 | -122.408304286625 | (37.7545962064773, -122.408304286625) | |||
45365 | 45365 | 201527 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 740 Earl St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 5ft | 6020341.20189 | 2093704.82943 | 37.730052512603294 | -122.371951898056 | (37.7300525126033, -122.371951898056) | |||
45485 | 45485 | 229864 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 76 Peralta Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6010511.83754 | 2100376.53881 | 37.7478267603098 | -122.406403320374 | (37.7478267603098, -122.406403320374) | |||
46113 | 46113 | 226433 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006663.83853 | 2103099.55931 | 37.7550875384663 | -122.41990273874201 | (37.7550875384663, -122.419902738742) | |||
47572 | 47572 | 229860 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3224 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008991.737509999 | 2099895.44974 | 37.746420642402605 | -122.411625786002 | (37.7464206424026, -122.411625786002) | |||
50352 | 50352 | 226767 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4257 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001499.39319 | 2102307.7971900003 | 37.752621244884 | -122.437706147824 | (37.752621244884, -122.437706147824) | |||
51165 | 51165 | 190723 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2277 Alameda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010387.48096 | 2107844.66484 | 37.768325603974795 | -122.40735974486601 | (37.7683256039748, -122.407359744866) | |||
53457 | 53457 | 190730 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 100 Utah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010525.46494 | 2107766.85443 | 37.76811967629639 | -122.40687698429599 | (37.7681196762964, -122.406876984296) | |||
54362 | 54362 | 229782 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6011435.782240001 | 2102697.98371 | 37.7542525844934 | -122.40337163559201 | (37.7542525844934, -122.403371635592) | |||
58331 | 58331 | 226802 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4187 20th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002513.17222 | 2104117.5372099997 | 37.7576479497004 | -122.434329701679 | (37.7576479497004, -122.434329701679) | |||
59860 | 59860 | 190726 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2211 Alameda St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010460.27046 | 2107847.89076 | 37.7683385353269 | -122.40710819908001 | (37.7683385353269, -122.40710819908) | |||
60089 | 60089 | 67473 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 880 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/1992 12:00:00 AM | 6 | Permit Number 30995 | 6012731.1830400005 | 2103360.24925 | 37.75614328768621 | -122.39893826479499 | (37.7561432876862, -122.398938264795) | |
63157 | 63157 | 190706 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2221 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011852.8073 | 2101343.3115 | 37.750556233291704 | -122.401834231975 | (37.7505562332917, -122.401834231975) | |||
64516 | 64516 | 229737 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1456 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009551.6906 | 2100697.1929200003 | 37.7486534468077 | -122.409746105823 | (37.7486534468077, -122.409746105823) | |||
66150 | 66150 | 226424 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 576 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007852.843669999 | 2104586.25311 | 37.7592365733232 | -122.415896074661 | (37.7592365733232, -122.415896074661) | |||
66426 | 66426 | 226312 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2180 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008090.95388 | 2105786.60151 | 37.762545837442104 | -122.41515753969999 | (37.7625458374421, -122.4151575397) | |||
67156 | 67156 | 81978 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2318 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50641 | 6007584.72207 | 2120320.19239 | 37.8024230981 | -122.417938725504 | (37.8024230981, -122.417938725504) | |
68707 | 68707 | 228532 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1000 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009375.264140001 | 2107362.10106 | 37.766943890068205 | -122.410826835502 | (37.7669438900682, -122.410826835502) | |||
70131 | 70131 | 43301 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 515 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 6 | Permit Number 48334 | 6013838.69916 | 2104687.6633599997 | 37.7598497302126 | -122.39520105018299 | (37.7598497302126, -122.395201050183) | |
72428 | 72428 | 190718 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 446 Missouri St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6013483.0407 | 2105010.44498 | 37.7607162323997 | -122.39645373295299 | (37.7607162323997, -122.396453732953) | |||
72849 | 72849 | 226345 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3175 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008443.19224 | 2101522.80952 | 37.7508582229518 | -122.413637681828 | (37.7508582229518, -122.413637681828) | |||
74197 | 74197 | 190736 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 128 Utah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010534.2694 | 2107640.09784 | 37.7677721243224 | -122.406837595791 | (37.7677721243224, -122.406837595791) | |||
76259 | 76259 | 228546 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1423 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 6ft | 6009579.53359 | 2100868.3183 | 37.74912487951521 | -122.409661901393 | (37.7491248795152, -122.409661901393) | |||
92025 | 92025 | 28275 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 304 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/17/2016 12:00:00 AM | 6 | 2X3 | 6006647.725204401 | 2098034.3646343 | 37.7411787556411 | -122.419599108791 | (37.7411787556411, -122.419599108791) | ||
108696 | 108696 | 226792 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 379 Collingwood St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6002133.75148 | 2103664.46985 | 37.7563823922541 | -122.435609479191 | (37.7563823922541, -122.435609479191) | |||
109956 | 109956 | 35314 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 120 Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1998 12:00:00 AM | 6 | 3x3 | Permit Number 38781 | 6005865.10533901 | 2106546.77110861 | 37.7645077436281 | -122.422909979953 | (37.7645077436281, -122.422909979953) |
125069 | 125069 | 229801 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 232 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006479.775219999 | 2104722.77918 | 37.759534152684296 | -122.4206545081 | (37.7595341526843, -122.4206545081) | |||
128911 | 128911 | 101946 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1045 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6007665.9 | 2103581.6 | 37.756467514749396 | -122.41647145396999 | (37.7564675147494, -122.41647145397) | |||
130350 | 130350 | 226429 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006669.22772 | 2102968.64373 | 37.7547283780289 | -122.41987481207501 | (37.7547283780289, -122.419874812075) | |||
131149 | 131149 | 190707 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2221 26th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011869.78299 | 2101342.9203 | 37.750556106496504 | -122.401775500866 | (37.7505561064965, -122.401775500866) | |||
132374 | 132374 | 50150 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 541@ 20TH ST Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/07/2003 12:00:00 AM | 6 | Permit Number 46869 | 6014129.22762 | 2104572.8122 | 37.7595505266559 | -122.394188205843 | (37.7595505266559, -122.394188205843) | |
132808 | 132808 | 78435 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2036 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 6 | 6011985.6646 | 2103761.39443 | 37.757203173815604 | -122.401544727608 | (37.7572031738156, -122.401544727608) | ||
132957 | 132957 | 226796 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 659 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002418.29753 | 2104403.0961700003 | 37.7584266402862 | -122.43467823573799 | (37.7584266402862, -122.434678235738) | |||
137679 | 137679 | 226776 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 16 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6004065.4050900005 | 2102868.59003 | 37.7543066193819 | -122.428872407741 | (37.7543066193819, -122.428872407741) | |||
146349 | 146349 | 47676 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 434 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | 6 | Permit Number 45460 | 6014318.70228 | 2105083.22351 | 37.7609625351244 | -122.39356862599399 | (37.7609625351244, -122.393568625994) | |
146934 | 146934 | 229825 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1306 York St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010049.59844 | 2101548.0323400004 | 37.7510175540398 | -122.408084334038 | (37.7510175540398, -122.408084334038) | |||
154467 | 154467 | 226325 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 825 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007984.60499 | 2102879.5260900003 | 37.754557697483705 | -122.415319557045 | (37.7545576974837, -122.415319557045) | |||
156112 | 156112 | 46098 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 624 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/2001 12:00:00 AM | 6 | Permit Number 44467 | 6012970.56549 | 2104146.6143 | 37.758315810544794 | -122.39816556101499 | (37.7583158105448, -122.398165561015) | ||
158019 | 158019 | 190724 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2277 Alameda St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010411.73546 | 2107844.78326 | 37.768327286608404 | -122.40727585879401 | (37.7683272866084, -122.407275858794) | |||
159887 | 159887 | 190696 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 99 Missouri St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6013444.350319999 | 2106714.41309 | 37.7653928005592 | -122.39670700362801 | (37.7653928005592, -122.396707003628) | |||
163454 | 163454 | 129101 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 701 Buchanan St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 6ft | 6004471.22614 | 2110943.39026 | 37.7765010448349 | -122.428044363274 | (37.7765010448349, -122.428044363274) | |||
163516 | 163516 | 226780 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3980 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003123.97049 | 2105369.10011 | 37.7611190917893 | -122.43230669740299 | (37.7611190917893, -122.432306697403) | |||
163722 | 163722 | 190741 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1786 Quesada Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014282.6032300005 | 2095390.34812 | 37.7343459381091 | -122.39301527674601 | (37.7343459381091, -122.393015276746) | |||
165603 | 165603 | 229819 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 713 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009886.7617 | 2104802.87513 | 37.7599455053009 | -122.408877057635 | (37.7599455053009, -122.408877057635) | |||
169061 | 169061 | 226816 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4132 17th St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6001458.2857800005 | 2105860.2549900003 | 37.7623730956507 | -122.438102756943 | (37.7623730956507, -122.438102756943) | |||
169455 | 169455 | 226320 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1237 Alabama St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009255.59412 | 2102037.09938 | 37.7523159340399 | -122.410864628624 | (37.7523159340399, -122.410864628624) | |||
169635 | 169635 | 229751 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6011465.75975 | 2102083.1370200003 | 37.7525660247145 | -122.40322471696999 | (37.7525660247145, -122.40322471697) | |||
173677 | 173677 | 229831 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1216 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010281.08298 | 2102019.10674 | 37.7523239784704 | -122.407317038764 | (37.7523239784704, -122.407317038764) | |||
174926 | 174926 | 40804 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 585 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Permit Number 41753 | 6013297.80731 | 2104343.61694 | 37.7588749586426 | -122.397047620054 | (37.7588749586426, -122.397047620054) | |||
176464 | 176464 | 37964 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 422 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 6 | Permit Number 40195 | 6013476.642440001 | 2105094.41315 | 37.760946434546 | -122.396481747729 | (37.760946434546, -122.396481747729) | |
178014 | 178014 | 116872 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1250 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013499.867880001 | 2106650.2771400004 | 37.7652197871992 | -122.396510483775 | (37.7652197871992, -122.396510483775) | |||
180200 | 180200 | 226393 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1451 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008028.94032 | 2099726.7877 | 37.745903479176896 | -122.41494310356701 | (37.7459034791769, -122.414943103567) | |||
180784 | 180784 | 226793 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 379 Collingwood St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6002133.14773 | 2103676.3157099998 | 37.756414883846105 | -122.435612414605 | (37.7564148838461, -122.435612414605) | |||
180970 | 180970 | 226399 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1480 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008004.14123 | 2099529.6733 | 37.745360853432395 | -122.41501490632 | (37.7453608534324, -122.41501490632) | |||
182053 | 182053 | 190732 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 100 Utah St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010527.29182 | 2107717.8289 | 37.767985165622605 | -122.40686720957899 | (37.7679851656226, -122.406867209579) | |||
182727 | 182727 | 226811 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 62 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004456.5508 | 2107418.4917900003 | 37.7668217000839 | -122.427843906179 | (37.7668217000839, -122.427843906179) | |||
184158 | 184158 | 30882 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 601 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2005 12:00:00 AM | 6 | Permit Number 48128 | 6014140.03931 | 2104332.5507 | 37.7588914216105 | -122.39413399288601 | (37.7588914216105, -122.394133992886) | ||
185952 | 185952 | 39551 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 814 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 6 | Permit Number 40977 | 6012407.86986 | 2104192.7387200003 | 37.7584111000042 | -122.40011486132 | (37.7584111000042, -122.40011486132) | |
186618 | 186618 | 115552 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 925x Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 15x7 | 6015276.56251 | 2104229.2059299997 | 37.7586707630633 | -122.390196112573 | (37.7586707630633, -122.390196112573) | ||
188726 | 188726 | 229802 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 232 Lexington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006479.512730001 | 2104709.9912400004 | 37.759499025184496 | -122.420654508118 | (37.7594990251845, -122.420654508118) | |||
188899 | 188899 | 226386 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 354 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006131.45892 | 2098074.37938 | 37.7412595329921 | -122.421387016722 | (37.7412595329921, -122.421387016722) | |||
188966 | 188966 | 226346 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3175 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008464.57897 | 2101524.14473 | 37.7508630900604 | -122.41356381871599 | (37.7508630900604, -122.413563818716) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");