trees
69 rows where Fire Prevention Districts = 15 and qSpecies_id = 97 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
189333 | 224619 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1324 Clayton St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 5999058.14954 | 2104997.17372 | 37.7598664980489 | -122.446341813123 | (37.7598664980489, -122.446341813123) | 15 | 5 | 5 | 28862 | 3 | |||
55915 | 224624 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1323 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5999021.66534 | 2105005.43313 | 37.7598870925388 | -122.446468587874 | (37.7598870925388, -122.446468587874) | 15 | 5 | 5 | 28862 | 12 | |||
175614 | 224623 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1323 Clayton St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 5999023.60773 | 2105026.39376 | 37.75994475616 | -122.446463378096 | (37.75994475616, -122.446463378096) | 15 | 5 | 5 | 28862 | 12 | |||
42798 | 224620 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1316 Clayton St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 5999063.56077 | 2105040.06353 | 37.759984571857 | -122.446326183806 | (37.759984571857, -122.446326183806) | 15 | 5 | 5 | 28862 | 3 | |||
178967 | 224622 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1323 Clayton St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 5999026.56459 | 2105047.83376 | 37.7600037939542 | -122.446454694247 | (37.7600037939542, -122.446454694247) | 15 | 5 | 5 | 28862 | 12 | |||
17586 | 224621 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1321 Clayton St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 5999027.25079 | 2105080.82131 | 37.7600944087555 | -122.446454694245 | (37.7600944087555, -122.446454694245) | 15 | 5 | 5 | 28862 | 12 | |||
78380 | 62435 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 297 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | Permit Number 22596 | 5999684.09914601 | 2105294.09451438 | 37.7607174991734 | -122.444198303008 | (37.7607174991734, -122.444198303008) | 15 | 5 | 5 | 28862 | 3 | ||
161649 | 62442 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3090 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | Permit Number 22605 | 5999929.32075843 | 2105305.0040382 | 37.7607614409418 | -122.443350977814 | (37.7607614409418, -122.443350977814) | 15 | 5 | 5 | 28862 | 3 | ||
128171 | 62436 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 227 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | 14 | 3x3 | Permit Number 772864 | 5999948.2266718 | 2105562.60505464 | 37.7614698277306 | -122.443304093705 | (37.7614698277306, -122.443304093705) | 15 | 5 | 5 | 28862 | 3 |
181277 | 68371 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1233 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32193 | 5998967.61980979 | 2105592.97843293 | 37.7614972584923 | -122.446697779287 | (37.7614972584923, -122.446697779287) | 15 | 5 | 11 | 29492 | 12 | ||
108720 | 224490 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 4630 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5998778.21735 | 2105711.32788 | 37.7618113953113 | -122.447361360161 | (37.7618113953113, -122.447361360161) | 15 | 5 | 11 | 29492 | 9 | |||
114821 | 92018 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 4182 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001163 | 2105841 | 37.7623034284238 | -122.439122658321 | (37.7623034284238, -122.439122658321) | 15 | 5 | 5 | 28862 | 3 | ||||
104186 | 83711 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 3955 17TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/25/2005 12:00:00 AM | 12 | 3x3 | 6002562.7 | 2105843.1 | 37.7623887399353 | -122.434281776631 | (37.7623887399353, -122.434281776631) | 15 | 4 | 5 | 28862 | 3 | ||
41908 | 35231 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 402 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1998 12:00:00 AM | Permit Number 38724 | 6003567.92997574 | 2105934.61117361 | 37.7626970125211 | -122.430811591359 | (37.7626970125211, -122.430811591359) | 15 | 4 | 5 | 28862 | 3 | |||
86121 | 224493 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 232 Upper Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5999538.9593 | 2106236.29263 | 37.7632962596403 | -122.444768001354 | (37.7632962596403, -122.444768001354) | 15 | 5 | 5 | 29492 | 9 | |||
129070 | 224489 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 24 Alma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5998519.39636 | 2106289.88206 | 37.7633851666273 | -122.448298178534 | (37.7633851666273, -122.448298178534) | 15 | 5 | 11 | 29492 | 9 | |||
145528 | 224488 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 24 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5998533.31147 | 2106291.41144 | 37.7633901614449 | -122.448250161025 | (37.7633901614449, -122.448250161025) | 15 | 5 | 11 | 29492 | 9 | |||
122820 | 65917 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1322 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | Permit Number 28932 | 5994588.71634117 | 2106515.79856518 | 37.7637799716089 | -122.461909408356 | (37.7637799716089, -122.461909408356) | 15 | 5 | 11 | 56 | 12 | ||
27714 | 66042 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 303 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/1990 12:00:00 AM | Permit Number 29081 | 6002303.92307718 | 2106443.08966771 | 37.7640214741501 | -122.435219706112 | (37.7640214741501, -122.435219706112) | 15 | 5 | 5 | 28862 | 3 | ||
42094 | 107775 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 311 PARNASSUS AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996666.6 | 2106591.7 | 37.7641077820156 | -122.454728170136 | (37.7641077820156, -122.454728170136) | 15 | 5 | 11 | 29492 | 12 | |||||
188441 | 224628 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1053 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5997656.24362 | 2106853.17472 | 37.7648824406996 | -122.45132415711 | (37.7648824406996, -122.45132415711) | 15 | 5 | 11 | 29492 | 9 | |||
70716 | 224492 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 60 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5998346.42262 | 2106894.64873 | 37.7650358128629 | -122.448940002185 | (37.7650358128629, -122.448940002185) | 15 | 5 | 11 | 29492 | 9 | |||
116135 | 224491 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 60 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5998359.17902 | 2106895.28933 | 37.7650383013108 | -122.4488959273 | (37.7650383013108, -122.4488959273) | 15 | 5 | 11 | 29492 | 9 | |||
154697 | 113877 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 101 HUGO ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995437 | 2107003 | 37.7651664998927 | -122.4590107531 | (37.7651664998927, -122.4590107531) | 15 | 5 | 11 | 56 | 12 | ||||
181335 | 224625 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50 Piedmont St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 5ft | 5999457.54578 | 2107020.99028 | 37.7654461969099 | -122.445105999866 | (37.7654461969099, -122.445105999866) | 15 | 5 | 5 | 29492 | 9 | |||
7315 | 108963 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2395x 15TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6001858 | 2107008 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | 15 | 5 | 5 | 28862 | 3 | ||||
53715 | 108962 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2395x 15TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6001858 | 2107008 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | 15 | 5 | 5 | 28862 | 3 | ||||
66329 | 108965 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2395x 15TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6001858 | 2107008 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | 15 | 5 | 5 | 28862 | 3 | ||||
151439 | 108964 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2395x 15TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6001858 | 2107008 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | 15 | 5 | 5 | 28862 | 3 | ||||
185991 | 64025 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2395x 15TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1987 12:00:00 AM | Permit Number 24782 | 6001858 | 2107008 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | 15 | 5 | 5 | 28862 | 3 | ||
138718 | 64019 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2321 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1987 12:00:00 AM | Permit Number 24776 | 6002140.06473103 | 2107033.66278157 | 37.7656337371655 | -122.435828700932 | (37.7656337371655, -122.435828700932) | 15 | 5 | 5 | 28862 | 3 | ||
93546 | 55576 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2309 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1987 12:00:00 AM | Permit Number 24775 | 6002194.69587728 | 2107036.79090461 | 37.7656454293788 | -122.435639967902 | (37.7656454293788, -122.435639967902) | 15 | 5 | 5 | 28862 | 3 | ||
30050 | 104403 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2362 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 3x3 | Permit Number 24809 | 6002031 | 2107070 | 37.7657273142687 | -122.436208531898 | (37.7657273142687, -122.436208531898) | 15 | 5 | 5 | 28862 | 3 | |
100814 | 104423 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2362 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 3x3 | Permit Number 24809 | 6002031 | 2107070 | 37.7657273142687 | -122.436208531898 | (37.7657273142687, -122.436208531898) | 15 | 5 | 5 | 28862 | 3 | |
91680 | 64024 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2356 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1987 12:00:00 AM | Permit Number 24781 | 6001973.19869493 | 2107076.19337817 | 37.7657410355678 | -122.436408897131 | (37.7657410355678, -122.436408897131) | 15 | 5 | 5 | 28862 | 3 | ||
136038 | 64051 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2362 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1987 12:00:00 AM | 18 | 3x3 | Permit Number 24809 | 6001958.39518673 | 2107077.48794504 | 37.7657437489593 | -122.436460191864 | (37.7657437489593, -122.436460191864) | 15 | 5 | 5 | 28862 | 3 |
31188 | 116841 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2344 15TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 24 | 6002015 | 2107091 | 37.7657840660528 | -122.436265375372 | (37.7657840660528, -122.436265375372) | 15 | 5 | 5 | 28862 | 3 | |||
5550 | 207625 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1223 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5995447.2053 | 2107231.58705 | 37.7657947273793 | -122.458992007973 | (37.7657947273793, -122.458992007973) | 15 | 5 | 11 | 56 | 12 | |||
77511 | 54514 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1221 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1983 12:00:00 AM | Permit Number 20683 | 5995443.00414725 | 2107246.09430383 | 37.7658343190377 | -122.459007589279 | (37.7658343190377, -122.459007589279) | 15 | 5 | 11 | 56 | 12 | ||
182226 | 224626 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 601 Buena Vista Ave West | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5999843.00884 | 2107568.58853 | 37.7669717582745 | -122.443812120926 | (37.7669717582745, -122.443812120926) | 15 | 5 | 5 | 29492 | 9 | |||
165235 | 224627 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 601 Buena Vista Ave West | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5999834.58358 | 2107589.10397 | 37.7670276079639 | -122.443842736578 | (37.7670276079639, -122.443842736578) | 15 | 5 | 5 | 29492 | 9 | |||
104931 | 61431 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 682 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1985 12:00:00 AM | Permit Number 22021 | 6002437.42157042 | 2108855.24055446 | 37.7706522292485 | -122.434930494274 | (37.7706522292485, -122.434930494274) | 15 | 5 | 11 | 29492 | 9 | ||
4209 | 62680 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 654 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1986 12:00:00 AM | Permit Number 23014 | 6002561.35247931 | 2108872.24257196 | 37.7707059484007 | -122.434503031919 | (37.7707059484007, -122.434503031919) | 15 | 5 | 11 | 29492 | 9 | ||
66258 | 56750 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 100 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/25/1985 12:00:00 AM | Permit Number 21307 | 6002862.2859563 | 2108898.25983772 | 37.7707944635274 | -122.433463958699 | (37.7707944635274, -122.433463958699) | 15 | 5 | 11 | 29492 | 9 | ||
47523 | 75088 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 574 WALLER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/1985 12:00:00 AM | 18 | 5x5 | 6002936 | 2108949 | 37.7709379654477 | -122.433212606655 | (37.7709379654477, -122.433212606655) | 15 | 5 | 11 | 29492 | 9 | ||
78159 | 244052 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 401 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5997900.6668 | 2109181.4943 | 37.771289404865 | -122.450646641766 | (37.771289404865, -122.450646641766) | 15 | 5 | 11 | 29492 | 9 | |||
140738 | 244051 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 401 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997898.1905 | 2109198.4158 | 37.7713357252186 | -122.450656427551 | (37.7713357252186, -122.450656427551) | 15 | 5 | 11 | 29492 | 9 | |||
99811 | 62669 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 299 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/1992 12:00:00 AM | Permit Number 23001 | 6003308.50596463 | 2109097.30161721 | 37.7713662897526 | -122.431934690531 | (37.7713662897526, -122.431934690531) | 15 | 9 | 11 | 29492 | 10 | ||
142226 | 62668 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 275 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1986 12:00:00 AM | Permit Number 23000 | 6003418.21056461 | 2109112.58339882 | 37.7714144683632 | -122.43155630855 | (37.7714144683632, -122.43155630855) | 15 | 9 | 11 | 29492 | 10 | ||
17568 | 60045 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 235 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1986 12:00:00 AM | Permit Number 22998 | 6003601.05151902 | 2109138.05302848 | 37.7714947633279 | -122.430925670981 | (37.7714947633279, -122.430925670981) | 15 | 9 | 11 | 29492 | 10 | ||
106089 | 56883 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 229 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1986 12:00:00 AM | Permit Number 14121 | 6003628.47766901 | 2109141.87347388 | 37.7715068072846 | -122.430831075204 | (37.7715068072846, -122.430831075204) | 15 | 9 | 11 | 29492 | 10 | ||
27367 | 62428 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 223 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1986 12:00:00 AM | Permit Number 22976 | 6003655.90381046 | 2109145.69391809 | 37.7715188511616 | -122.430736479427 | (37.7715188511616, -122.430736479427) | 15 | 9 | 11 | 29492 | 10 | ||
104098 | 56884 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 219 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1986 12:00:00 AM | Permit Number 14122 | 6003674.18790761 | 2109148.24088129 | 37.771526880372 | -122.430673415548 | (37.771526880372, -122.430673415548) | 15 | 9 | 11 | 29492 | 10 | ||
154487 | 56880 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 260 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1986 12:00:00 AM | Permit Number 22991 | 6003475.03058778 | 2109173.00048042 | 37.7715835792192 | -122.431364078952 | (37.7715835792192, -122.431364078952) | 15 | 9 | 11 | 29492 | 10 | ||
38338 | 62653 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 250 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1986 12:00:00 AM | Permit Number 22975 | 6003520.74083492 | 2109179.36788903 | 37.7716036530228 | -122.431206419247 | (37.7716036530228, -122.431206419247) | 15 | 9 | 11 | 29492 | 10 | ||
175928 | 60193 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 236 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1986 12:00:00 AM | Permit Number 22999 | 6003584.73517067 | 2109188.28225965 | 37.771631755989 | -122.430985695552 | (37.771631755989, -122.430985695552) | 15 | 9 | 11 | 29492 | 10 | ||
146415 | 56882 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 228 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1986 12:00:00 AM | Permit Number 22996 | 6003621.30337351 | 2109193.37618724 | 37.7716478146462 | -122.430859567614 | (37.7716478146462, -122.430859567614) | 15 | 9 | 11 | 29492 | 10 | ||
160352 | 66469 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 430 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1991 12:00:00 AM | Permit Number 29620 | 6002231.09425836 | 2109952.33731326 | 37.7736528678468 | -122.435722686817 | (37.7736528678468, -122.435722686817) | 15 | 5 | 11 | 29492 | 10 | ||
29118 | 61140 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2132 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/01/1983 12:00:00 AM | Permit Number 20992 | 5997609.15376905 | 2110265.51143343 | 37.7742491458885 | -122.451733203729 | (37.7742491458885, -122.451733203729) | 15 | 5 | 2 | 29492 | 16 | ||
123454 | 59623 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 445 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/1988 12:00:00 AM | Permit Number 19030 | 6001158.23229918 | 2110194.44132426 | 37.7742566261049 | -122.439451230631 | (37.7742566261049, -122.439451230631) | 15 | 5 | 11 | 29492 | 10 | ||
114874 | 61139 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2128 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/01/1983 12:00:00 AM | Permit Number 20991 | 5997627.50212199 | 2110268.03572246 | 37.7742571277486 | -122.451669915896 | (37.7742571277486, -122.451669915896) | 15 | 5 | 2 | 29492 | 16 | ||
66522 | 66379 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 625 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | Permit Number 29504 | 6003563.84234841 | 2110464.21135378 | 37.7751339598215 | -122.431149051781 | (37.7751339598215, -122.431149051781) | 15 | 9 | 11 | 29492 | 10 | ||
13355 | 62304 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2504 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1985 12:00:00 AM | Permit Number 22442 | 5997225.79467532 | 2110840.29768365 | 37.7758053966105 | -122.453100806219 | (37.7758053966105, -122.453100806219) | 15 | 6 | 2 | 54 | 16 | ||
58779 | 63899 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 719 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1987 12:00:00 AM | Permit Number 24609 | 6002042.34774334 | 2110925.77664223 | 37.7763149662139 | -122.436445273797 | (37.7763149662139, -122.436445273797) | 15 | 5 | 11 | 29492 | 10 | ||
98278 | 66836 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2920 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1993 12:00:00 AM | Permit Number 30137 | 5997039.99678003 | 2111588.58372334 | 37.777849344501 | -122.453797573256 | (37.777849344501, -122.453797573256) | 15 | 6 | 2 | 54 | 16 | ||
94326 | 62670 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1328 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1986 12:00:00 AM | Permit Number 23002 | 6002790.04269178 | 2111680.73625558 | 37.7784303546549 | -122.433912768351 | (37.7784303546549, -122.433912768351) | 15 | 5 | 11 | 29490 | 41 | ||
192915 | 66937 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2350 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/1992 12:00:00 AM | Permit Number 30262 | 5998853.41639727 | 2111835.46191539 | 37.7786310079222 | -122.447542123222 | (37.7786310079222, -122.447542123222) | 15 | 6 | 2 | 54 | 16 | ||
118592 | 63854 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1437 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24553 | 6002713.14606438 | 2111964.58520586 | 37.779205368769 | -122.434199079816 | (37.779205368769, -122.434199079816) | 15 | 5 | 11 | 29490 | 41 | ||
154840 | 63853 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1482 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24552 | 6002495.53817147 | 2111986.73822711 | 37.7792538422906 | -122.43495345894 | (37.7792538422906, -122.43495345894) | 15 | 5 | 11 | 29490 | 41 |
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) );