trees
209 rows where Supervisor Districts = 5 and qSpecies_id = 97 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193369 | 61728 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 121 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21733 | 6004369.94753879 | 2101000.29060373 | 37.7491939379116 | -122.427686117612 | (37.7491939379116, -122.427686117612) | 2 | 4 | 5 | 28862 | 22 | ||
189934 | 64807 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 74 Newburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25809 | 6002370.48571479 | 2099839.6903707 | 37.7458938988463 | -122.434517304917 | (37.7458938988463, -122.434517304917) | 2 | 7 | 5 | 63 | 22 | ||
189515 | 23099 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1406 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x4 | 6006424.41645 | 2101384.80463 | 37.7503657245067 | -122.420609012309 | (37.7503657245067, -122.420609012309) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
188830 | 61704 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 560 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1984 12:00:00 AM | Permit Number 21703 | 6005065.62335195 | 2107833.77826085 | 37.7679964138535 | -122.42576678516 | (37.7679964138535, -122.42576678516) | 8 | 4 | 5 | 28853 | 19 | ||
188220 | 60835 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 237 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20608 | 6004787.65423878 | 2102293.57578284 | 37.7527686178291 | -122.42633374857 | (37.7527686178291, -122.42633374857) | 2 | 4 | 5 | 28862 | 22 | ||
187559 | 51017 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 464 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/2004 12:00:00 AM | Permit Number 47495 | 6003323.42861905 | 2103333.57669245 | 37.75554133817 | -122.431471541095 | (37.75554133817, -122.431471541095) | 2 | 4 | 5 | 28862 | 22 | ||
187259 | 224590 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3111 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006042.423 | 2106653.80762 | 37.7648116442701 | -122.422304291014 | (37.7648116442701, -122.422304291014) | 8 | 4 | 5 | 28859 | 19 | |||
186913 | 59494 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3121 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/1981 12:00:00 AM | 14 | 4x4 | Permit Number 18869 | 6006018.54214632 | 2106655.70514999 | 37.7648155073416 | -122.422387023676 | (37.7648155073416, -122.422387023676) | 8 | 4 | 5 | 28859 | 19 | |
186624 | 224609 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3556 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005809.70389 | 2102588.37341 | 37.7536357835838 | -122.422820259951 | (37.7536357835838, -122.422820259951) | 2 | 4 | 5 | 28859 | 19 | |||
186297 | 63778 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 140 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24459 | 6004215.48168844 | 2101629.42267968 | 37.7509126493248 | -122.428265095141 | (37.7509126493248, -122.428265095141) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
184847 | 63772 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1134 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24451 | 6003162.44517655 | 2101626.56141002 | 37.7508451528322 | -122.431906388672 | (37.7508451528322, -122.431906388672) | 2 | 4 | 5 | 28862 | 22 | ||
184130 | 224683 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1380 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006412.3793 | 2101568.56601 | 37.7508696128423 | -122.420663681196 | (37.7508696128423, -122.420663681196) | 2 | 4 | 5 | 28859 | 19 | |||
183797 | 224615 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 525 Burnett Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5999500.0818 | 2102479.17274 | 37.7529779168973 | -122.444632407852 | (37.7529779168973, -122.444632407852) | 2 | 5 | 5 | 63 | 38 | |||
183423 | 63773 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 400 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24453 | 6004132.01414207 | 2101578.81224199 | 37.7507689616906 | -122.428550126724 | (37.7507689616906, -122.428550126724) | 2 | 4 | 5 | 28862 | 22 | ||
183317 | 5133 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2796 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6002464.77756 | 2095726.89475 | 37.7346064681217 | -122.433897334607 | (37.7346064681217, -122.433897334607) | 2 | 7 | 5 | 63 | 7 | |||
183273 | 52783 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 269@ 24th ST Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/25/2006 12:00:00 AM | Permit Number 48827 | 6004796.86181264 | 2102115.84108407 | 37.7522811202098 | -122.426289254005 | (37.7522811202098, -122.426289254005) | 2 | 4 | 5 | 28862 | 22 | ||
182814 | 61735 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 246 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21740 | 6003563.88991247 | 2101007.45012611 | 37.7491679679218 | -122.430473986745 | (37.7491679679218, -122.430473986745) | 2 | 4 | 5 | 28862 | 22 | ||
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 | |||
182138 | 63877 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 849 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24582 | 6003121.89544563 | 2103305.24261692 | 37.7554521151946 | -122.432166481498 | (37.7554521151946, -122.432166481498) | 2 | 4 | 5 | 28862 | 22 | ||
181582 | 224591 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3117 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006001.0018 | 2106651.39278 | 37.7648026771212 | -122.422447384857 | (37.7648026771212, -122.422447384857) | 8 | 4 | 5 | 28859 | 19 | |||
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 | |||
180250 | 224681 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1390 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6006415.87838 | 2101496.97772 | 37.7506732449771 | -122.420646499655 | (37.7506732449771, -122.420646499655) | 2 | 4 | 5 | 28859 | 19 | |||
179582 | 224605 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 71 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6005897.27948 | 2103429.13328 | 37.7559492562604 | -122.422577143518 | (37.7559492562604, -122.422577143518) | 2 | 4 | 5 | 28859 | 19 | |||
179560 | 66225 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 36 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29319 | 6005318.51312392 | 2105778.36560715 | 37.76236702737 | -122.424745827071 | (37.76236702737, -122.424745827071) | 8 | 4 | 5 | 28859 | 19 | ||
179373 | 63876 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 493 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24580 | 6003154.01696483 | 2103272.14676469 | 37.7553630630052 | -122.432053032269 | (37.7553630630052, -122.432053032269) | 2 | 4 | 5 | 28862 | 22 | ||
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 | |||
177810 | 23094 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1384 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/1992 12:00:00 AM | 3 | 3x3 | 6006412.34173 | 2101544.72785 | 37.7508041565902 | -122.420662119057 | (37.7508041565902, -122.420662119057) | 2 | 4 | 5 | 28859 | 19 | ||
176059 | 63988 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 237 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1987 12:00:00 AM | Permit Number 24734 | 6004762.51437158 | 2103946.91619601 | 37.7573068822751 | -122.42653840479 | (37.7573068822751, -122.42653840479) | 2 | 4 | 5 | 28862 | 3 | ||
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 | |||
171625 | 61732 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 184 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21737 | 6003971.9147598 | 2101029.52294751 | 37.7492516799815 | -122.429064604837 | (37.7492516799815, -122.429064604837) | 2 | 4 | 5 | 28862 | 22 | ||
171142 | 61751 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1839 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1984 12:00:00 AM | Permit Number 21762 | 6005280.05550322 | 2107208.06692616 | 37.7662904752312 | -122.424980563467 | (37.7662904752312, -122.424980563467) | 8 | 4 | 5 | 28853 | 19 | ||
170717 | 107384 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 73 HILL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9x6 | 6005896.4 | 2103362 | 37.7557648742481 | -122.422575414787 | (37.7557648742481, -122.422575414787) | 2 | 4 | 5 | 28859 | 19 | ||||
168168 | 224481 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 77 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005108.87913 | 2105720.69975 | 37.7621968483334 | -122.425466769576 | (37.7621968483334, -122.425466769576) | 8 | 4 | 5 | 28859 | 19 | |||
167109 | 61473 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1918 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1984 12:00:00 AM | 24 | Permit Number 21416 | 6004687.86766006 | 2107227.29036829 | 37.766309789845 | -122.427030199286 | (37.766309789845, -122.427030199286) | 8 | 4 | 5 | 28862 | 3 | |
166304 | 224616 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 525 Burnett Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5999502.23945 | 2102489.21916 | 37.7530056250346 | -122.444625668335 | (37.7530056250346, -122.444625668335) | 2 | 5 | 5 | 63 | 38 | |||
166052 | 224691 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3514 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006345.67902 | 2101450.87841 | 37.7505427101753 | -122.420885982798 | (37.7505427101753, -122.420885982798) | 2 | 4 | 5 | 28859 | 19 | |||
165815 | 62533 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 128 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/1988 12:00:00 AM | Permit Number 25140 | 6004317.58532782 | 2101049.36983513 | 37.749325736021 | -122.427870683655 | (37.749325736021, -122.427870683655) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
164254 | 59572 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 893 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1991 12:00:00 AM | Permit Number 24583 | 6003136.10237421 | 2103049.36160406 | 37.7547503322276 | -122.432099077639 | (37.7547503322276, -122.432099077639) | 2 | 4 | 5 | 28862 | 22 | ||
164240 | 96965 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3686 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x4 | Permit Number 23795 | 6005734 | 2104335 | 37.758427342075 | -122.423206207432 | (37.758427342075, -122.423206207432) | 2 | 4 | 5 | 28859 | 19 | ||
162342 | 60432 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 447 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1992 12:00:00 AM | Permit Number 31498 | 6003680.70369729 | 2098915.54804456 | 37.7434307072212 | -122.42992084535 | (37.7434307072212, -122.42992084535) | 2 | 7 | 5 | 63 | 22 | ||
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 | ||
160997 | 64287 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 359 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25092 | 6004210.28159871 | 2098359.34465346 | 37.7419334769159 | -122.428050070914 | (37.7419334769159, -122.428050070914) | 2 | 7 | 5 | 63 | 7 | ||
155173 | 28743 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 750 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005621.99358 | 2098694.18206 | 37.742932633526 | -122.42319261615 | (37.742932633526, -122.42319261615) | 2 | 7 | 5 | 28859 | 22 | |||
153957 | 5685 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1506 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 5x5 | 6005209.87097 | 2099535.96992 | 37.7452207246578 | -122.424677493096 | (37.7452207246578, -122.424677493096) | 2 | 7 | 5 | 63 | 22 | |||
152804 | 60714 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 21 Oakwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1989 12:00:00 AM | Permit Number 20367 | 6005264.975818 | 2105333.47768938 | 37.7611424464321 | -122.424899339668 | (37.7611424464321, -122.424899339668) | 2 | 4 | 5 | 28859 | 19 | ||
152493 | 61711 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 232 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1991 12:00:00 AM | Permit Number 29947 | 6005210.12151982 | 2108247.78406465 | 37.7691413389079 | -122.425296445755 | (37.7691413389079, -122.425296445755) | 8 | 4 | 5 | 28853 | 19 | ||
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 | ||||
150822 | 61707 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Rosemont Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/1984 12:00:00 AM | 16 | 3x11 | Permit Number 21706 | 6005093.88211876 | 2108026.7239243 | 37.7685277931807 | -122.42568277558 | (37.7685277931807, -122.42568277558) | 8 | 4 | 5 | 28853 | 19 | |
148502 | 224692 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3514 25th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006331.52942 | 2101449.49488 | 37.7505381137462 | -122.420934815082 | (37.7505381137462, -122.420934815082) | 2 | 4 | 5 | 28859 | 19 | |||
147724 | 5576 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1040 Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6005062.54747 | 2102282.8606 | 37.7527547312707 | -122.425382354736 | (37.7527547312707, -122.425382354736) | 2 | 4 | 5 | 28862 | 22 | |||
146840 | 64693 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 110 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/1988 12:00:00 AM | Permit Number 25636 | 6005573.37725141 | 2104043.9306623 | 37.7576190678174 | -122.423741017308 | (37.7576190678174, -122.423741017308) | 2 | 4 | 5 | 28859 | 19 | ||
146304 | 63405 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 4330 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/11/1987 12:00:00 AM | Permit Number 23987 | 6001641.42159443 | 2104703.75073536 | 37.7592080301488 | -122.437386541918 | (37.7592080301488, -122.437386541918) | 2 | 4 | 5 | 28862 | 3 | ||
146150 | 61734 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 264 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21739 | 6003453.08659842 | 2101001.58454059 | 37.7491455850179 | -122.430856727417 | (37.7491455850179, -122.430856727417) | 2 | 4 | 5 | 28862 | 22 | ||
145021 | 224593 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3131 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/1981 12:00:00 AM | 13 | Width 3ft | Permit Number 18870 | 6005970.19181 | 2106649.76485 | 37.7647964691065 | -122.422553833108 | (37.7647964691065, -122.422553833108) | 8 | 4 | 5 | 28859 | 19 | |
144984 | 61731 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1250 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21736 | 6003842.20340405 | 2100987.35465575 | 37.7491285523468 | -122.42951014206 | (37.7491285523468, -122.42951014206) | 2 | 4 | 5 | 28862 | 22 | ||
144232 | 5748 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1770 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 5X5 | 6005291.42369 | 2098088.82872 | 37.7412518096224 | -122.424292591354 | (37.7412518096224, -122.424292591354) | 2 | 7 | 5 | 63 | 7 | |||
143478 | 224612 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 525 Burnett Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5999484.75601 | 2102435.63345 | 37.7528574940932 | -122.444682277976 | (37.7528574940932, -122.444682277976) | 2 | 5 | 5 | 63 | 38 | |||
142490 | 5334 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 140 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6004762.96876 | 2107575.67846 | 37.7672706263574 | -122.426795251693 | (37.7672706263574, -122.426795251693) | 8 | 4 | 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 | ||
138197 | 224604 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 26 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6005971.50768 | 2103476.95331 | 37.7560847463373 | -122.422323835073 | (37.7560847463373, -122.422323835073) | 2 | 4 | 5 | 28859 | 19 | |||
137705 | 66878 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 281 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1991 12:00:00 AM | Permit Number 30189 | 6001145.91509222 | 2104727.87963003 | 37.7592460999874 | -122.439101967223 | (37.7592460999874, -122.439101967223) | 2 | 4 | 5 | 28862 | 3 | ||
136653 | 5127 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2764 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/18/1994 12:00:00 AM | 15 | 3X3 | 6002472.72131 | 2095943.62285 | 37.7352020045603 | -122.433885356532 | (37.7352020045603, -122.433885356532) | 2 | 7 | 5 | 63 | 7 | ||
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 |
135891 | 61714 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 236 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1984 12:00:00 AM | Permit Number 21714 | 6005186.275415 | 2108246.41850013 | 37.7691362421663 | -122.425378830956 | (37.7691362421663, -122.425378830956) | 8 | 4 | 5 | 28853 | 19 | ||
135538 | 34978 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 135 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1997 12:00:00 AM | Permit Number 38559 | 6002699.25501919 | 2105112.74476166 | 37.7603911107583 | -122.433757281047 | (37.7603911107583, -122.433757281047) | 2 | 4 | 5 | 28862 | 3 | |||
135237 | 61717 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 126 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1984 12:00:00 AM | Permit Number 21717 | 6005390.65318574 | 2108294.55770451 | 37.7692799656993 | -122.424675324148 | (37.7692799656993, -122.424675324148) | 8 | 4 | 5 | 28853 | 19 | ||
135040 | 64333 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 21 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25161 | 6004296.86075631 | 2098199.7784306 | 37.741500242556 | -122.427739341515 | (37.741500242556, -122.427739341515) | 2 | 7 | 5 | 63 | 7 | ||
131865 | 226500 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 155 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6005540.15432 | 2099025.50317 | 37.7438377472209 | -122.423499143787 | (37.7438377472209, -122.423499143787) | 2 | 7 | 5 | 28859 | 22 | |||
131423 | 5670 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1416 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6005182.49595 | 2100071.1312 | 37.7466886088884 | -122.424810216828 | (37.7466886088884, -122.424810216828) | 2 | 7 | 5 | 63 | 22 | |||
131070 | 61754 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3208 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1984 12:00:00 AM | Permit Number 21766 | 6005459.89972761 | 2106676.78980679 | 37.7648418717739 | -122.424320725398 | (37.7648418717739, -122.424320725398) | 8 | 4 | 5 | 28853 | 19 | ||
129773 | 66218 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 81 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1990 12:00:00 AM | Permit Number 29310 | 6005039.41557773 | 2105712.51494257 | 37.7621704498093 | -122.425706435205 | (37.7621704498093, -122.425706435205) | 8 | 4 | 5 | 28859 | 19 | ||
129506 | 66222 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 48 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1990 12:00:00 AM | Permit Number 29314 | 6005242.33190892 | 2105774.60229973 | 37.7623523912444 | -122.425009042016 | (37.7623523912444, -122.425009042016) | 8 | 4 | 5 | 28859 | 19 | ||
129099 | 10222 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1375-1377 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005868.37697 | 2101019.32612 | 37.7493308512387 | -122.422505871374 | (37.7493308512387, -122.422505871374) | 2 | 4 | 5 | 28859 | 19 | |||
128740 | 61713 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 269 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1984 12:00:00 AM | Permit Number 21713 | 6004998.47961276 | 2108183.57904333 | 37.7689530882522 | -122.42602393242 | (37.7689530882522, -122.42602393242) | 8 | 4 | 5 | 28853 | 19 | ||
128200 | 66311 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 140 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29426 | 6001329.17242898 | 2095394.93152934 | 37.7336304648573 | -122.437799727546 | (37.7336304648573, -122.437799727546) | 9 | 7 | 5 | 63 | 40 | ||
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 |
127710 | 224614 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 525 Burnett Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5999496.34966 | 2102468.38313 | 37.7529480782956 | -122.444644538818 | (37.7529480782956, -122.444644538818) | 2 | 5 | 5 | 63 | 38 | |||
127691 | 61741 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 175 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21746 | 6004036.62237664 | 2100981.15253515 | 37.7491225287463 | -122.428837396831 | (37.7491225287463, -122.428837396831) | 2 | 4 | 5 | 28862 | 22 | ||
127460 | 24447 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1156 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6006347.02184 | 2102851.32539 | 37.754388091646 | -122.420980760555 | (37.754388091646, -122.420980760555) | 2 | 4 | 5 | 28859 | 19 | |||
126791 | 23101 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1406 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3X3 | 6006426.26721 | 2101342.93585 | 37.7502508667074 | -122.420599640465 | (37.7502508667074, -122.420599640465) | 2 | 4 | 5 | 28859 | 19 | |||
125961 | 63244 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3686 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/1987 12:00:00 AM | 14 | 4x4 | Permit Number 23795 | 6005743.604902 | 2104344.93890143 | 37.7584551740166 | -122.423173695837 | (37.7584551740166, -122.423173695837) | 2 | 4 | 5 | 28859 | 19 |
124577 | 224597 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3379 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005839.72376 | 2103719.16031 | 37.7567423557945 | -122.422796801149 | (37.7567423557945, -122.422796801149) | 2 | 4 | 5 | 28859 | 19 | |||
124265 | 22835 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 104 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/1994 12:00:00 AM | 20 | 2X2 | 5999575.13645 | 2098938.39255 | 37.7432600730945 | -122.444118450719 | (37.7432600730945, -122.444118450719) | 2 | 7 | 5 | 63 | 7 | ||
122852 | 58069 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 4525 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1991 12:00:00 AM | Permit Number 30131 | 6000914.77254872 | 2105195.89592401 | 37.7605180033322 | -122.439934925187 | (37.7605180033322, -122.439934925187) | 2 | 4 | 5 | 28862 | 3 | ||
122779 | 61739 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 232 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21744 | 6003650.07025761 | 2101012.01224764 | 37.7491853759856 | -122.430176299432 | (37.7491853759856, -122.430176299432) | 2 | 4 | 5 | 28862 | 22 | ||
121365 | 5338 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 158 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x5 | 6004769.98156 | 2107435.4149 | 37.766885892799 | -122.426761005535 | (37.766885892799, -122.426761005535) | 8 | 4 | 5 | 28862 | 3 | |||
120716 | 1351 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 271 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5999796.36324 | 2099302.32917 | 37.7442719740833 | -122.443379644158 | (37.7442719740833, -122.443379644158) | 2 | 7 | 5 | 63 | 22 | |||
119041 | 63779 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 143 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24460 | 6004205.74848694 | 2101576.80650466 | 37.7507676268483 | -122.428295003883 | (37.7507676268483, -122.428295003883) | 2 | 4 | 5 | 28862 | 22 | ||
118466 | 116773 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 400 Vicksburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6004132.01414207 | 2101578.81224199 | 37.7507689616906 | -122.428550126724 | (37.7507689616906, -122.428550126724) | 2 | 4 | 5 | 28862 | 22 | ||||
118335 | 64335 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 148 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25163 | 6004614.99091661 | 2097575.59980235 | 37.7398043808352 | -122.426594919866 | (37.7398043808352, -122.426594919866) | 2 | 7 | 5 | 63 | 7 | ||
116320 | 64674 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3672 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1988 12:00:00 AM | Permit Number 25610 | 6005829.7777873 | 2104349.72005691 | 37.7584731646091 | -122.422876010971 | (37.7584731646091, -122.422876010971) | 2 | 4 | 5 | 28859 | 19 | ||
115641 | 5371 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 266 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 6x6 | 6004805.70542 | 2106808.51316 | 37.7651665904864 | -122.42659279722 | (37.7651665904864, -122.42659279722) | 8 | 4 | 5 | 28862 | 3 | |||
115580 | 36099 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 299 on 16th Dolores St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/1998 12:00:00 AM | Permit Number 39198 | 6004891.74541508 | 2106619.46330166 | 37.7646523685012 | -122.426281744676 | (37.7646523685012, -122.426281744676) | 8 | 4 | 5 | 28859 | 19 | |||
115391 | 224618 | Planning Code 138.1 required 2 | Ficus microcarpa :: Chinese Banyan 97 | 165 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 3ft | Permit Number 780743 | 6001936.24436 | 2096476.10277 | 37.7366336128599 | -122.435778235198 | (37.7366336128599, -122.435778235198) | 2 | 7 | 5 | 63 | 7 | ||
114985 | 5689 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1535 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005306.00348 | 2099419.02782 | 37.7449050572203 | -122.424336766952 | (37.7449050572203, -122.424336766952) | 2 | 7 | 5 | 28859 | 22 | |||
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 | ||||
112567 | 5335 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 149 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 6X8 | 6004854.459 | 2107562.68516 | 37.7672401222731 | -122.42647787465 | (37.7672401222731, -122.42647787465) | 8 | 4 | 5 | 28862 | 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) );