trees
969 rows where qSpecies_id = 97 sorted by PlantDate 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | ||
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 | ||
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 | ||
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 | |
167803 | 41049 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1452 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1999 12:00:00 AM | Permit Number 41829 | 6011713.00642169 | 2101589.94219711 | 37.7512256245579 | -122.402335016202 | (37.7512256245579, -122.402335016202) | 10 | 3 | 8 | 28856 | 29 | ||
11332 | 55316 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1125 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1972 12:00:00 AM | 14 | 3x3 | Permit Number 11245 | 6011314.64048 | 2089535.2445 | 37.7181037214869 | -122.402864884726 | (37.7181037214869, -122.402864884726) | 10 | 7 | 8 | 309 | 39 | |
164692 | 55317 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1126 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 4 | Permit Number 11246 | 6011285.28669 | 2089520.65076 | 37.7180620109438 | -122.402965322811 | (37.7180620109438, -122.402965322811) | 10 | 7 | 8 | 309 | 39 | ||
65803 | 66224 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 32 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29318 | 6005343.90687 | 2105779.62004334 | 37.7623719059493 | -122.424658088706 | (37.7623719059493, -122.424658088706) | 8 | 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 | ||
18380 | 65586 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1779 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Permit Number 28486 | 6014089.25997 | 2096159.17746 | 37.7364462435881 | -122.393737527685 | (37.7364462435881, -122.393737527685) | 10 | 3 | 8 | 58 | 1 | ||
51538 | 66220 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1 Dolores Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1990 12:00:00 AM | Permit Number 29312 | 6005304.82019082 | 2105877.54249684 | 37.7626385702507 | -122.424800241819 | (37.7626385702507, -122.424800241819) | 8 | 4 | 5 | 28859 | 19 | ||
107780 | 66216 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 438 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1990 12:00:00 AM | Permit Number 29307 | 6008473.34152559 | 2106010.06053059 | 37.7631808865324 | -122.413850803115 | (37.7631808865324, -122.413850803115) | 8 | 4 | 7 | 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 | ||
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 | ||
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 |
84851 | 59876 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2195X Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1981 12:00:00 AM | 3x3 | Permit Number 768644 | 6002471.9091323 | 2118692.46196613 | 37.7976647031079 | -122.43551504484 | (37.7976647031079, -122.43551504484) | 13 | 9 | 1 | 57 | 17 | ||
109279 | 68204 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1110 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | 16 | 3x3 | Permit Number 32363 | 6009978.53990017 | 2102725.22931804 | 37.7542458964916 | -122.408413088762 | (37.7542458964916, -122.408413088762) | 2 | 4 | 7 | 28859 | 19 |
1151 | 199431 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 695 Arkansas St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | Width 10ft | 6013045.46319 | 2103845.54885 | 37.7574933220764 | -122.397885411405 | (37.7574933220764, -122.397885411405) | 10 | 3 | 8 | 28856 | 29 | ||
2420 | 260860 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 695 Arkansas St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/16/2019 12:00:00 AM | 3 | 3x3 | 6013106 | 2103855 | 37.7575226440732 | -122.397676712285 | (37.7575226440732, -122.397676712285) | 10 | 3 | 8 | 28856 | 29 | ||
10390 | 199430 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 695 Arkansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | Width 10ft | 6013045.24345 | 2103834.71473 | 37.7574635617095 | -122.397885411392 | (37.7574635617095, -122.397885411392) | 10 | 3 | 8 | 28856 | 29 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
80884 | 60279 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 890 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1982 12:00:00 AM | Permit Number 19841 | 6007951.11915857 | 2102749.5563076 | 37.7541989479338 | -122.415426159541 | (37.7541989479338, -122.415426159541) | 2 | 4 | 7 | 28859 | 19 | ||
138825 | 60292 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2902 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1982 12:00:00 AM | Permit Number 19857 | 6009437.54414231 | 2102795.33502096 | 37.7544080802013 | -122.410288944543 | (37.7544080802013, -122.410288944543) | 2 | 4 | 7 | 28859 | 19 | ||
171938 | 60290 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2915 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1982 12:00:00 AM | Permit Number 19854 | 6009379.15115854 | 2102740.05515277 | 37.7542530206621 | -122.41048698011 | (37.7542530206621, -122.41048698011) | 2 | 4 | 7 | 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 | ||
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 | ||
115001 | 67594 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 308 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | Permit Number 31161 | 6013452.45067872 | 2105638.02121278 | 37.7624377166869 | -122.39660352483 | (37.7624377166869, -122.39660352483) | 10 | 3 | 8 | 28856 | 29 | ||
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 | ||
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 | ||
115568 | 62139 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 394 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | Permit Number 22347 | 6000980.72200275 | 2092487.56875551 | 37.7256276955072 | -122.438796151694 | (37.7256276955072, -122.438796151694) | 9 | 7 | 6 | 28861 | 25 | ||
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 | ||
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 | ||
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 | |
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 | ||
38079 | 53067 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2161 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2006 12:00:00 AM | Permit Number 49038 | 6002271.52116096 | 2114331.58955378 | 37.7856794886217 | -122.435896249645 | (37.7856794886217, -122.435896249645) | 13 | 6 | 11 | 29490 | 13 | |||
181231 | 57942 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 15 Byron Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776219 | 5999289.47216 | 2086646.12526 | 37.7094920599881 | -122.444223069735 | (37.7094920599881, -122.444223069735) | 9 | 7 | 6 | 28861 | 5 | |
32783 | 62137 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 127 San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/31/1985 12:00:00 AM | Permit Number 22247 | 6001408.1074829 | 2092199.32717361 | 37.7248605551976 | -122.437298087712 | (37.7248605551976, -122.437298087712) | 9 | 7 | 6 | 28861 | 25 | ||
625 | 245416 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2761 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010170.0429 | 2102204.1541 | 37.7528258621349 | -122.407714081565 | (37.7528258621349, -122.407714081565) | 2 | 4 | 7 | 28859 | 19 | |
11640 | 245417 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2761 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010192.4103 | 2102204.1541 | 37.7528271142349 | -122.407636730621 | (37.7528271142349, -122.407636730621) | 2 | 4 | 7 | 28859 | 19 | |
13405 | 245415 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2761 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010145.3814 | 2102202.4336 | 37.752819757444 | -122.407799244655 | (37.752819757444, -122.407799244655) | 2 | 4 | 7 | 28859 | 19 | |
53369 | 67032 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 255 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012868.03417039 | 2116855.7141363 | 37.7932063935721 | -122.399412377848 | (37.7932063935721, -122.399412377848) | 4 | 1 | 10 | 28860 | 6 | |||
74295 | 97191 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 255 California St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012839.6 | 2116825.7 | 37.7931223970079 | -122.399508654361 | (37.7931223970079, -122.399508654361) | 4 | 1 | 10 | 28860 | 6 | |||
92709 | 97190 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 255 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012839.6 | 2116825.7 | 37.7931223970079 | -122.399508654361 | (37.7931223970079, -122.399508654361) | 4 | 1 | 10 | 28860 | 6 | |||
93302 | 97189 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 255 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012839.6 | 2116825.7 | 37.7931223970079 | -122.399508654361 | (37.7931223970079, -122.399508654361) | 4 | 1 | 10 | 28860 | 6 | |||
186372 | 59298 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 734 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1980 12:00:00 AM | Permit Number 18636 | 5993516.37713931 | 2106668.84289355 | 37.7641383983924 | -122.465629390558 | (37.7641383983924, -122.465629390558) | 11 | 8 | 11 | 56 | 12 | |||
65684 | 65243 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1086 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1989 12:00:00 AM | Permit Number 28037 | 6009165.76758609 | 2102839.33295033 | 37.7545136503205 | -122.411231929366 | (37.7545136503205, -122.411231929366) | 2 | 4 | 7 | 28859 | 19 | ||
71033 | 62088 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 474 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1985 12:00:00 AM | Permit Number 22174 | 6013214.9408475 | 2104861.98073646 | 37.7602936588903 | -122.397370564655 | (37.7602936588903, -122.397370564655) | 10 | 3 | 8 | 28856 | 29 | ||
98172 | 61524 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 5301 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1984 12:00:00 AM | Permit Number 21481 | 5991172.88177213 | 2114060.20768973 | 37.7842976232811 | -122.474274166868 | (37.7842976232811, -122.474274166868) | 11 | 6 | 2 | 54 | 26 | ||
178899 | 61526 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1335 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1984 12:00:00 AM | Permit Number 21483 | 5991367.33157346 | 2114748.57792616 | 37.7861989598694 | -122.47365167719 | (37.7861989598694, -122.47365167719) | 11 | 6 | 2 | 54 | 26 | ||
86490 | 66119 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 223 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29179 | 6005470.38749546 | 2110092.46405208 | 37.7742210861409 | -122.424527432779 | (37.7742210861409, -122.424527432779) | 7 | 9 | 11 | 28852 | 10 | ||
179128 | 66115 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 817 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29170 | 6003947.68857827 | 2110748.1234611 | 37.7759352566539 | -122.429841497852 | (37.7759352566539, -122.429841497852) | 7 | 9 | 11 | 29492 | 10 | ||
24214 | 64582 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3646 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1988 12:00:00 AM | 18 | 7x12 | Permit Number 25481 | 6005989.81318517 | 2104358.59934784 | 37.758506573723 | -122.422323167129 | (37.758506573723, -122.422323167129) | 2 | 4 | 5 | 28859 | 19 | |
98843 | 64576 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3524 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1988 12:00:00 AM | Permit Number 25474 | 6006109.43020381 | 2104951.42696267 | 37.760141086622 | -122.421951589354 | (37.760141086622, -122.421951589354) | 2 | 4 | 5 | 28859 | 19 | ||
165757 | 64580 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3540 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1988 12:00:00 AM | Permit Number 25479 | 6006657.88465402 | 2104395.66614284 | 37.7586460128066 | -122.420015302359 | (37.7586460128066, -122.420015302359) | 2 | 4 | 7 | 28859 | 19 | ||
143284 | 32039 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3653 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1995 12:00:00 AM | Permit Number 35422 | 6003092.33534727 | 2120827.43015376 | 37.8035619867255 | -122.433520856524 | (37.8035619867255, -122.433520856524) | 13 | 9 | 1 | 57 | 17 | |||
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 | ||
80902 | 64591 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3375 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1988 12:00:00 AM | Permit Number 25492 | 6005853.76544152 | 2103715.18666196 | 37.7567322373374 | -122.422747957423 | (37.7567322373374, -122.422747957423) | 2 | 4 | 5 | 28859 | 19 | ||
60993 | 61785 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1495 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1987 12:00:00 AM | Permit Number 24636 | 6012051.50334521 | 2101403.29784414 | 37.7507320294913 | -122.401151335946 | (37.7507320294913, -122.401151335946) | 10 | 3 | 8 | 28856 | 29 | ||
150898 | 54789 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 271 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1972 12:00:00 AM | 21 | Permit Number 10638 | 6012677.12996 | 2087211.64652 | 37.7117995683772 | -122.39799240103 | (37.7117995683772, -122.39799240103) | 10 | 3 | 8 | 309 | 1 | ||
108921 | 571 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2970 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/30/2015 12:00:00 AM | 12 | 3x3 | 6009054.00613 | 2102184.08314 | 37.7527082129358 | -122.411572138748 | (37.7527082129358, -122.411572138748) | 2 | 4 | 7 | 28859 | 19 | ||
128778 | 65199 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 393 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1989 12:00:00 AM | Permit Number 27185 | 6003086.32595187 | 2091584.19795725 | 37.7232668084318 | -122.431452793676 | (37.7232668084318, -122.431452793676) | 9 | 7 | 6 | 28861 | 5 | ||
61132 | 38252 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1556 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | 24 | 4x6 | Permit Number 40362 | 6007050.76125355 | 2107358.39166569 | 37.7668030933038 | -122.418866676369 | (37.7668030933038, -122.418866676369) | 8 | 4 | 7 | 28853 | 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
160598 | 34453 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1167 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 10 | Permit Number 38197 | 6007453.34661 | 2118811.22971 | 37.7982724714417 | -122.418286300874 | (37.7982724714417, -122.418286300874) | 5 | 1 | 10 | 28858 | 32 | |
61919 | 43305 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 693 Vermont St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/12/2000 12:00:00 AM | 6 | Permit Number 43072 | 6011285.67007 | 2105193.27319 | 37.7610957103087 | -122.4040663601 | (37.7610957103087, -122.4040663601) | 10 | 3 | 8 | 28856 | 29 | |
23053 | 48044 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
26673 | 48040 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
36236 | 48046 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
76052 | 48037 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
82252 | 48042 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
97902 | 48043 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
126375 | 48039 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
140651 | 48045 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
170827 | 48041 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||
1692 | 61474 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1960 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1984 12:00:00 AM | Permit Number 21417 | 6004396.86379546 | 2107211.14447839 | 37.7662489975602 | -122.428035576337 | (37.7662489975602, -122.428035576337) | 8 | 4 | 5 | 28862 | 3 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
15539 | 37970 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 602 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/1998 12:00:00 AM | Permit Number 40200 | |||||||||||||
185038 | 111900 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 650X Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2016 12:00:00 AM | 3 | 6003603.61647971 | 2110556.18401653 | 37.7753887478808 | -122.431018029936 | (37.7753887478808, -122.431018029936) | 7 | 9 | 11 | 29492 | 10 | ||
102755 | 62037 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 395 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/1985 12:00:00 AM | 14 | 3x3 | Permit Number 781547 | 6009850.4646 | 2114693.00092 | 37.7870994553217 | -122.409700683759 | (37.7870994553217, -122.409700683759) | 5 | 1 | 10 | 28852 | 36 | |
23581 | 31969 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 470 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1995 12:00:00 AM | Permit Number 35370 | 6009517.59351868 | 2092163.53246737 | 37.7252199449059 | -122.409261897755 | (37.7252199449059, -122.409261897755) | 9 | 3 | 7 | 309 | 28 |
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) );