trees
402 rows where Fire Prevention Districts = 2 and qSpecies_id = 97 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
100196 | 224611 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 525 Burnett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5999479.68357 | 2102426.58534 | 37.7528323607352 | -122.444699169054 | (37.7528323607352, -122.444699169054) | 2 | 5 | 5 | 63 | 38 | |||
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 | |||
76333 | 224613 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 525 Burnett Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5999489.63243 | 2102445.23523 | 37.7528841365055 | -122.44466610455 | (37.7528841365055, -122.44466610455) | 2 | 5 | 5 | 63 | 38 | |||
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 | |||
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 | |||
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 | |||
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 | ||
40903 | 224617 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 970 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999693.04498 | 2101841.13049 | 37.7512370173901 | -122.443919267953 | (37.7512370173901, -122.443919267953) | 2 | 5 | 5 | 63 | 38 | |||
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 | |||
74245 | 107997 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2X Clover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | 6000451.13785 | 2105044.8413 | 37.760076841062 | -122.441527580895 | (37.760076841062, -122.441527580895) | 2 | 4 | 5 | 28862 | 3 | ||||
102790 | 224610 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 87 Berkeley Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000904.1974 | 2097866.66824 | 37.7403931018552 | -122.439446107557 | (37.7403931018552, -122.439446107557) | 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 | ||
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 | ||
15629 | 66830 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 393 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1991 12:00:00 AM | Permit Number 30127 | 6001175.80343985 | 2104102.01378806 | 37.7575293253254 | -122.438953746382 | (37.7575293253254, -122.438953746382) | 2 | 4 | 5 | 28862 | 3 | ||
74301 | 1923 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 78 Berkeley Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6001189.66062 | 2097346.80979 | 37.7389819342562 | -122.438421854409 | (37.7389819342562, -122.438421854409) | 2 | 7 | 5 | 63 | 7 | |||
20637 | 50305 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1217@ ARMY Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/2003 12:00:00 AM | Permit Number 47015 | 6001375.35048187 | 2100228.68999583 | 37.7469054591013 | -122.437986196494 | (37.7469054591013, -122.437986196494) | 2 | 4 | 5 | 63 | 22 | ||
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 | ||
76206 | 63396 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 4326 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/11/1987 12:00:00 AM | Permit Number 23978 | 6001653.34817436 | 2104704.40880226 | 37.759210515065 | -122.437345341266 | (37.759210515065, -122.437345341266) | 2 | 4 | 5 | 28862 | 3 | ||
67426 | 63397 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 4300 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1991 12:00:00 AM | Permit Number 30165 | 6001730.87094671 | 2104708.68623731 | 37.7592266666695 | -122.437077536949 | (37.7592266666695, -122.437077536949) | 2 | 4 | 5 | 28862 | 3 | ||
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 | ||
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 | ||
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 | |||
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 | ||
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 | |||
105579 | 58797 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 772 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/1979 12:00:00 AM | 24 | 3x3 | Permit Number 53459 | 6003043.36972634 | 2103781.55156302 | 37.7567554935309 | -122.432472066162 | (37.7567554935309, -122.432472066162) | 2 | 4 | 5 | 28862 | 3 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
36246 | 32868 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 456 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1996 12:00:00 AM | Permit Number 37214 | 6003519.04848512 | 2096396.05502281 | 37.736503601705 | -122.430300092251 | (37.736503601705, -122.430300092251) | 2 | 7 | 5 | 63 | 7 | |||
105533 | 63872 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 426 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24575 | 6003557.23375757 | 2103346.48170692 | 37.7555900208672 | -122.430663891517 | (37.7555900208672, -122.430663891517) | 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 | ||
45208 | 60434 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 461 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/07/1987 12:00:00 AM | Permit Number 24099 | 6003594.47944671 | 2098910.74347696 | 37.7434126315981 | -122.430218644192 | (37.7434126315981, -122.430218644192) | 2 | 7 | 5 | 63 | 22 | ||
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 | ||
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 | ||
17311 | 61740 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 219 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21745 | 6003738.99947337 | 2100964.64707663 | 37.7490603587459 | -122.429865402911 | (37.7490603587459, -122.429865402911) | 2 | 4 | 5 | 28862 | 22 | ||
97223 | 67815 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 967 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31469 | 6003802.17585758 | 2102641.49083741 | 37.7536681560563 | -122.429766523917 | (37.7536681560563, -122.429766523917) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
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 | ||
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 | ||
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 | ||||
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 | ||
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 | ||
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 | ||
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 | ||
60366 | 64334 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 18 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25162 | 6004243.25196821 | 2098226.95980835 | 37.7415718437352 | -122.427926638771 | (37.7415718437352, -122.427926638771) | 2 | 7 | 5 | 63 | 7 | ||
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 | ||
96644 | 59421 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 59 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25134 | 6004314.38183356 | 2097887.85689933 | 37.7406447683968 | -122.42765654127 | (37.7406447683968, -122.42765654127) | 2 | 7 | 5 | 63 | 7 | ||
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 | |||
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 | ||
110682 | 61727 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 106 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21732 | 6004453.38447501 | 2101057.16682643 | 37.7493548261549 | -122.427401642555 | (37.7493548261549, -122.427401642555) | 2 | 4 | 5 | 28862 | 22 | ||
90119 | 61733 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1352 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21738 | 6004486.387982 | 2101012.81721841 | 37.7492349189645 | -122.427284356874 | (37.7492349189645, -122.427284356874) | 2 | 4 | 5 | 28862 | 22 | ||
17850 | 60829 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 82 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20508 | 6004586.81845905 | 2101649.91280729 | 37.7509899147675 | -122.426982435992 | (37.7509899147675, -122.426982435992) | 2 | 4 | 5 | 28862 | 22 | ||
69005 | 62360 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 198 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22505 | 6004608.84494602 | 2099604.09085689 | 37.7453738062021 | -122.426760590215 | (37.7453738062021, -122.426760590215) | 2 | 7 | 5 | 63 | 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 | ||
110561 | 54295 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3761 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20600 | 6004679.68604313 | 2102479.51319776 | 37.7532730549459 | -122.426720362353 | (37.7532730549459, -122.426720362353) | 2 | 4 | 5 | 28862 | 22 | ||
47834 | 106690 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 98X CHATTANOOGA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 4x4 | 6004701 | 2103385 | 37.7557605147563 | -122.426711131232 | (37.7557605147563, -122.426711131232) | 2 | 4 | 5 | 28862 | 22 | |||
79246 | 60832 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 210 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20605 | 6004728.24272246 | 2102435.29497545 | 37.7531543871846 | -122.426549294945 | (37.7531543871846, -122.426549294945) | 2 | 4 | 5 | 28862 | 22 | ||
25933 | 60830 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 282 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | 22 | Permit Number 20603 | 6004748.95976393 | 2102035.39189802 | 37.7520575177016 | -122.426449179292 | (37.7520575177016, -122.426449179292) | 2 | 4 | 5 | 28862 | 22 | |
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 | ||
29378 | 62357 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 172 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22501 | 6004773.71147679 | 2099613.16071739 | 37.745408029937 | -122.426191153847 | (37.745408029937, -122.426191153847) | 2 | 7 | 5 | 63 | 22 | ||
63739 | 60831 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 205 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20604 | 6004778.44666437 | 2102471.31049199 | 37.7532561154195 | -122.426378243722 | (37.7532561154195, -122.426378243722) | 2 | 4 | 5 | 28862 | 22 | ||
102803 | 60834 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 233 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20607 | 6004786.50329151 | 2102315.79263057 | 37.752829555056 | -122.426339310434 | (37.752829555056, -122.426339310434) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
69132 | 60836 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 253 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20609 | 6004792.25802571 | 2102204.70843345 | 37.7525248690267 | -122.426311501214 | (37.7525248690267, -122.426311501214) | 2 | 4 | 5 | 28862 | 22 | ||
75679 | 57103 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3743 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20509 | 6004792.79553424 | 2102485.90723803 | 37.7532970057744 | -122.426329661558 | (37.7532970057744, -122.426329661558) | 2 | 4 | 5 | 28862 | 22 | ||
102238 | 60837 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 255 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20610 | 6004792.83349827 | 2102193.60003035 | 37.7524944004681 | -122.426308720309 | (37.7524944004681, -122.426308720309) | 2 | 4 | 5 | 28862 | 22 | ||
50861 | 60838 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 261 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20611 | 6004794.55991917 | 2102160.27475876 | 37.75240299462 | -122.426300377591 | (37.75240299462, -122.426300377591) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
59240 | 60839 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 271 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20613 | 6004797.43728628 | 2102104.7326602 | 37.7522506515925 | -122.426286473113 | (37.7522506515925, -122.426286473113) | 2 | 4 | 5 | 28862 | 22 | ||
64691 | 60840 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 315 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20614 | 6004809.28697134 | 2101883.59513704 | 37.7516441291888 | -122.426229752639 | (37.7516441291888, -122.426229752639) | 2 | 4 | 5 | 28862 | 22 | ||
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 | |||
20642 | 62333 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 54 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/1985 12:00:00 AM | Permit Number 22475 | 6005123.90294191 | 2096395.98906268 | 37.7365941933288 | -122.424751419367 | (37.7365941933288, -122.424751419367) | 2 | 7 | 5 | 28859 | 2 | ||
100467 | 62353 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 113 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | 18 | Permit Number 22497 | 6005157.02914158 | 2099582.1696783 | 37.7453445941022 | -122.424863497555 | (37.7453445941022, -122.424863497555) | 2 | 7 | 5 | 63 | 22 | |
75866 | 62334 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 66 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/1985 12:00:00 AM | Permit Number 22476 | 6005174.05627534 | 2096389.57268342 | 37.7365794079222 | -122.424577561345 | (37.7365794079222, -122.424577561345) | 2 | 7 | 5 | 28859 | 2 | ||
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 | |||
7928 | 5672 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1422 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6005185.06241 | 2100046.61651 | 37.7466214421279 | -122.424799598532 | (37.7466214421279, -122.424799598532) | 2 | 7 | 5 | 63 | 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 | |||
42082 | 62352 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 102 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22496 | 6005217.58297735 | 2099637.57957653 | 37.7455001571003 | -122.424658053081 | (37.7455001571003, -122.424658053081) | 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 | ||
24474 | 62335 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 88 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/1985 12:00:00 AM | Permit Number 22477 | 6005278.45102522 | 2096412.38253023 | 37.7366479337699 | -122.424218245392 | (37.7366479337699, -122.424218245392) | 2 | 7 | 7 | 28859 | 2 | ||
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 | |||
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 | |||
76501 | 5708 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1603 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005329.17263 | 2098980.11676 | 37.7437012157418 | -122.424225442544 | (37.7437012157418, -122.424225442544) | 2 | 7 | 5 | 28859 | 22 | |||
7021 | 5742 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1755 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005373.18109 | 2098196.81653 | 37.741552935912 | -122.424017580443 | (37.741552935912, -122.424017580443) | 2 | 7 | 5 | 28859 | 7 | |||
194157 | 224494 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 140 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005454.36959 | 2096149.25289 | 37.7359353702183 | -122.423591316208 | (37.7359353702183, -122.423591316208) | 2 | 7 | 7 | 28859 | 2 | |||
189791 | 224495 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 142 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005480.01407 | 2096145.74782 | 37.7359271935727 | -122.423502403815 | (37.7359271935727, -122.423502403815) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | ||
90779 | 226499 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 133 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6005600.01114 | 2099028.12585 | 37.7438483268298 | -122.42329235907 | (37.7438483268298, -122.42329235907) | 2 | 7 | 5 | 28859 | 22 | |||
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 | |||
5744 | 26220 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 765X San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6005701.2867 | 2098677.11468 | 37.7428902448864 | -122.422917229343 | (37.7428902448864, -122.422917229343) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||
78829 | 224596 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3395 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6005741.73742 | 2103713.82749 | 37.7567221840006 | -122.423135295184 | (37.7567221840006, -122.423135295184) | 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 |
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 | |||
61066 | 224608 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3552 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005826.64329 | 2102589.60435 | 37.7536401192198 | -122.422761767144 | (37.7536401192198, -122.422761767144) | 2 | 4 | 5 | 28859 | 19 | |||
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 |
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) );