trees
969 rows where qSpecies_id = 97 sorted by Fire Prevention Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
54721 | 224580 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | Permit Number 781047 | 6008616.55983 | 2106802.76672 | 37.7653655169234 | -122.413411521233 | (37.7653655169234, -122.413411521233) | 8 | 4 | 7 | 28859 | 19 | ||
55241 | 5358 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 230 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6004797.67228 | 2107012.30465 | 37.7657256990156 | -122.426635095043 | (37.7657256990156, -122.426635095043) | 8 | 4 | 5 | 28862 | 3 | |||
56192 | 61710 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1975 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1984 12:00:00 AM | Permit Number 21709 | 6004910.69371619 | 2108330.79575039 | 37.7693523480889 | -122.426338061309 | (37.7693523480889, -122.426338061309) | 8 | 4 | 5 | 28862 | 19 | ||
56378 | 34142 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 400 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1997 12:00:00 AM | Permit Number 37990 | 6008524.65557539 | 2106230.12436926 | 37.7637880127631 | -122.413688890617 | (37.7637880127631, -122.413688890617) | 8 | 4 | 7 | 28859 | 19 | ||
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 | |
62313 | 61708 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 580 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1984 12:00:00 AM | Permit Number 21707 | 6004928.75046121 | 2107826.22237424 | 37.767967931643 | -122.426239675726 | (37.767967931643, -122.426239675726) | 8 | 4 | 5 | 28853 | 19 | ||
65251 | 116393 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | 8 | 4 | 7 | 28859 | 19 | ||||
65274 | 224595 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3139 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005929.78445 | 2106647.58051 | 37.7647881917533 | -122.422693436658 | (37.7647881917533, -122.422693436658) | 8 | 4 | 5 | 28859 | 19 | |||
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 | ||
67934 | 224592 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3117 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005984.09151 | 2106650.98656 | 37.7648006077779 | -122.422505844393 | (37.7648006077779, -122.422505844393) | 8 | 4 | 5 | 28859 | 19 | |||
72854 | 61763 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 390 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/1984 12:00:00 AM | Permit Number 21777 | 6005479.130443 | 2106713.50276565 | 37.7649437627207 | -122.424256822517 | (37.7649437627207, -122.424256822517) | 8 | 4 | 5 | 28853 | 19 | ||
74671 | 116392 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | 8 | 4 | 7 | 28859 | 19 | ||||
78943 | 33764 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1580 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/1996 12:00:00 AM | Permit Number 37815 | 6007223.30298499 | 2109757.94023834 | 37.7734013999863 | -122.418440043785 | (37.7734013999863, -122.418440043785) | 8 | 2 | 9 | 28853 | 19 | |||
78946 | 226484 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3120 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6008470.16955 | 2105663.03593 | 37.7622278587398 | -122.413837225211 | (37.7622278587398, -122.413837225211) | 8 | 4 | 7 | 28859 | 19 | |||
79542 | 226495 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1850 Harrison St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008685.71484 | 2107616.88585 | 37.7676047820563 | -122.413229904031 | (37.7676047820563, -122.413229904031) | 8 | 4 | 7 | 28853 | 19 | |||
87966 | 30505 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1500 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 34518 | 6007587.04685478 | 2110100.36731732 | 37.7743620934089 | -122.417206068405 | (37.7743620934089, -122.417206068405) | 8 | 2 | 9 | 28853 | 19 | |||
88565 | 36252 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 243 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 39269 | 6005153.47922718 | 2108192.45520893 | 37.7689862189606 | -122.42548843025 | (37.7689862189606, -122.42548843025) | 8 | 4 | 5 | 28853 | 19 | ||
90379 | 105718 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | 8 | 4 | 7 | 28859 | 19 | |||
91419 | 224482 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 36 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005327.69113 | 2105769.40379 | 37.7623429387058 | -122.424713446172 | (37.7623429387058, -122.424713446172) | 8 | 4 | 5 | 28859 | 19 | |||
95838 | 226485 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3120 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6008502.54321 | 2105665.76145 | 37.7622371604259 | -122.41372544939 | (37.7622371604259, -122.41372544939) | 8 | 4 | 7 | 28859 | 19 | |||
96429 | 224485 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1528 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6007214.09312 | 2107363.71404 | 37.7668269026679 | -122.418302114548 | (37.7668269026679, -122.418302114548) | 8 | 4 | 7 | 28853 | 19 | |||
104706 | 224676 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 123 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6007744.73276 | 2107219.69106 | 37.766461304874 | -122.416456511479 | (37.766461304874, -122.416456511479) | 8 | 4 | 7 | 28853 | 19 | |||
104976 | 36098 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 299 on 16th Street Dolores St | 1 | 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 | |||
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 | ||
108436 | 224667 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 560 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008944.82068 | 2105599.01741 | 37.7620787232758 | -122.412191055786 | (37.7620787232758, -122.412191055786) | 8 | 4 | 7 | 28859 | 19 | |||
111937 | 61712 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 239 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1984 12:00:00 AM | Permit Number 21712 | 6005177.32533199 | 2108193.82077345 | 37.768991315779 | -122.425406045223 | (37.768991315779, -122.425406045223) | 8 | 4 | 5 | 28853 | 19 | ||
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 | |||
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 | |||
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 | |||
116584 | 224587 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2765 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008334.82797 | 2106780.39435 | 37.7652882651653 | -122.414384386251 | (37.7652882651653, -122.414384386251) | 8 | 4 | 7 | 28859 | 19 | |||
120282 | 116391 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | 8 | 4 | 7 | 28859 | 19 | ||||
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 | |||
122639 | 224666 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 570 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008945.18383 | 2105567.26579 | 37.7619915609728 | -122.412187555625 | (37.7619915609728, -122.412187555625) | 8 | 4 | 7 | 28859 | 19 | |||
124391 | 116390 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | 8 | 4 | 7 | 28859 | 19 | ||||
127678 | 226498 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1850 Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008688.72129 | 2107547.38011 | 37.7674141042173 | -122.413214589496 | (37.7674141042173, -122.413214589496) | 8 | 4 | 7 | 28853 | 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 | ||
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 | ||
129976 | 116389 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | 8 | 4 | 7 | 28859 | 19 | ||||
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 | ||
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 | ||
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 | ||
141866 | 226497 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1850 Harrison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008687.35447 | 2107561.73783 | 37.7674534504487 | -122.41322033256 | (37.7674534504487, -122.41322033256) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |||
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 | |
146057 | 224585 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | Permit Number 781047 | 6008501.81805 | 2106792.30192 | 37.7653303399343 | -122.413807647409 | (37.7653303399343, -122.413807647409) | 8 | 4 | 7 | 28859 | 19 | ||
147208 | 226486 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3120 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6008522.95772 | 2105665.90861 | 37.7622387108737 | -122.413654853488 | (37.7622387108737, -122.413654853488) | 8 | 4 | 7 | 28859 | 19 | |||
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 | |
152129 | 35055 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 570 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/1998 12:00:00 AM | Permit Number 38614 | 6008948.51314843 | 2105576.68374234 | 37.7620176073252 | -122.41217670641 | (37.7620176073252, -122.41217670641) | 8 | 4 | 7 | 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 | ||
156316 | 226487 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3120 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008546.79549 | 2105667.11477 | 37.7622433612724 | -122.413572492685 | (37.7622433612724, -122.413572492685) | 8 | 4 | 7 | 28859 | 19 | |||
157515 | 226496 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1850 Harrison St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008684.6321 | 2107591.00428 | 37.767533656488 | -122.413231818694 | (37.767533656488, -122.413231818694) | 8 | 4 | 7 | 28853 | 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 | |
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 | |||
169407 | 224484 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1514 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6007262.01073 | 2107365.0441 | 37.7668332518872 | -122.418136469321 | (37.7668332518872, -122.418136469321) | 8 | 4 | 7 | 28853 | 19 | |||
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 | ||
175733 | 224677 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 254 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007152.66781 | 2105827.76249 | 37.7626060812304 | -122.418405656216 | (37.7626060812304, -122.418405656216) | 8 | 4 | 7 | 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 | ||
181331 | 34143 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 400 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1997 12:00:00 AM | Permit Number 37990 | 6008524.65557539 | 2106230.12436926 | 37.7637880127631 | -122.413688890617 | (37.7637880127631, -122.413688890617) | 8 | 4 | 7 | 28859 | 19 | ||
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 | |||
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 | |
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 | |||
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 | ||
194356 | 224589 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2765 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008256.05874 | 2106775.28704 | 37.7652698164603 | -122.414656469826 | (37.7652698164603, -122.414656469826) | 8 | 4 | 7 | 28859 | 19 | |||
6180 | 33653 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 284 Linden St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37742 | 6006036.93235026 | 2110918.36759919 | 37.776520795938 | -122.422626351394 | (37.776520795938, -122.422626351394) | 7 | 9 | 11 | 28852 | 10 | |||
6344 | 33663 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 424 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37751 | 6005309.8782552 | 2111164.52643651 | 37.7771556428857 | -122.425158961888 | (37.7771556428857, -122.425158961888) | 7 | 9 | 11 | 28852 | 10 | |||
10493 | 59647 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 100 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/05/1987 12:00:00 AM | 6x9 | Permit Number 24228 | 6003848.70238053 | 2108788.55742661 | 37.7705491626589 | -122.43004409806 | (37.7705491626589, -122.43004409806) | 7 | 9 | 11 | 29492 | 10 | |
11946 | 33634 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 416 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37730 | 6005394.17412308 | 2110828.6660173 | 37.7762382136369 | -122.424843455434 | (37.7762382136369, -122.424843455434) | 7 | 9 | 11 | 28852 | 10 | |||
26145 | 258009 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 380 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005531 | 2111189 | 37.7772353303506 | -122.424395772149 | (37.7772353303506, -122.424395772149) | 7 | 9 | 11 | 28852 | 10 | ||||
28013 | 33609 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 308 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37721 | 6005048.76551317 | 2110086.28535746 | 37.7741803016618 | -122.425985460117 | (37.7741803016618, -122.425985460117) | 7 | 9 | 11 | 28852 | 10 | |||
32878 | 12244 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 401X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005028.53136 | 2110211.81183 | 37.7745238232573 | -122.426064391571 | (37.7745238232573, -122.426064391571) | 7 | 9 | 11 | 28852 | 10 | |||
36000 | 104437 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 534 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005464 | 2111103 | 37.7769954116482 | -122.424621427703 | (37.7769954116482, -122.424621427703) | 7 | 9 | 11 | 28852 | 10 | |||||
40736 | 33615 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 312 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37724 | 6005030.32834442 | 2110083.71933458 | 37.7741722139784 | -122.4260490549 | (37.7741722139784, -122.4260490549) | 7 | 9 | 11 | 28852 | 10 | |||
41759 | 30892 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 412 Hayes St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | Permit Number 34719 | 6005865.19335847 | 2111068.58127823 | 37.7769235557198 | -122.423231126893 | (37.7769235557198, -122.423231126893) | 7 | 9 | 11 | 28852 | 10 | |||
49673 | 66438 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 650X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1991 12:00:00 AM | Permit Number 29582 | 6003603.61647971 | 2110556.18401653 | 37.7753887478808 | -122.431018029936 | (37.7753887478808, -122.431018029936) | 7 | 9 | 11 | 29492 | 10 | ||
69321 | 16914 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 483 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004697.20239 | 2110157.08412 | 37.7743548226588 | -122.427206624104 | (37.7743548226588, -122.427206624104) | 7 | 9 | 11 | 28852 | 10 | |||
73528 | 59961 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 444 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/1981 12:00:00 AM | Permit Number 19440 | 6005671.77527769 | 2111387.84010103 | 37.7777892453109 | -122.4239229277 | (37.7777892453109, -122.4239229277) | 7 | 9 | 11 | 28852 | 10 | ||
77743 | 31350 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 843 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | Permit Number 34960 | 6003828.78534548 | 2110731.50789971 | 37.7758829003399 | -122.430251629227 | (37.7758829003399, -122.430251629227) | 7 | 9 | 11 | 29492 | 10 | ||
78099 | 66375 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 612 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | Permit Number 29499 | 6003620.76837837 | 2110432.17499844 | 37.7750492215662 | -122.430949845165 | (37.7750492215662, -122.430949845165) | 7 | 9 | 11 | 29492 | 10 | ||
83608 | 59954 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 559 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/1981 12:00:00 AM | Permit Number 19431 | 6005185.88290556 | 2110921.14903305 | 37.7764803824816 | -122.42557057591 | (37.7764803824816, -122.42557057591) | 7 | 9 | 11 | 28852 | 10 | ||
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 | ||
92545 | 66374 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 600 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | Permit Number 29498 | 6003626.18476729 | 2110393.01425684 | 37.7749420027203 | -122.430928313262 | (37.7749420027203, -122.430928313262) | 7 | 9 | 11 | 29492 | 10 | ||
108948 | 30891 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 412 Hayes St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | Permit Number 34719 | 6005865.19335847 | 2111068.58127823 | 37.7769235557198 | -122.423231126893 | (37.7769235557198, -122.423231126893) | 7 | 9 | 11 | 28852 | 10 | |||
118167 | 33695 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 415 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37766 | 6005362.72010447 | 2111119.40531281 | 37.7770347362587 | -122.42497295397 | (37.7770347362587, -122.42497295397) | 7 | 9 | 11 | 28852 | 10 | |||
123850 | 33611 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 310 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37722 | 6005039.5469288 | 2110085.00234602 | 37.7741762578244 | -122.42601725751 | (37.7741762578244, -122.42601725751) | 7 | 9 | 11 | 28852 | 10 | |||
131474 | 16900 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 409 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005007.3916 | 2110203.70331 | 37.7745003644325 | -122.426136940772 | (37.7745003644325, -122.426136940772) | 7 | 9 | 11 | 28852 | 10 | |||
132088 | 33651 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 284 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37742 | 6006036.93235026 | 2110918.36759919 | 37.776520795938 | -122.422626351394 | (37.776520795938, -122.422626351394) | 7 | 9 | 11 | 28852 | 10 | |||
140818 | 65399 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 471 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1989 12:00:00 AM | Permit Number 28247 | 6008612.45505665 | 2113822.69504434 | 37.7846403524021 | -122.41392234969 | (37.7846403524021, -122.41392234969) | 7 | 10 | 9 | 28852 | 36 | ||
143659 | 33610 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 308 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37721 | 6005048.76551317 | 2110086.28535746 | 37.7741803016618 | -122.425985460117 | (37.7741803016618, -122.425985460117) | 7 | 9 | 11 | 28852 | 10 | |||
148185 | 33613 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 386 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37723 | 6004689.24070975 | 2110036.24790961 | 37.7740225856392 | -122.427225555933 | (37.7740225856392, -122.427225555933) | 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 | ||
179236 | 30890 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 412 Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | Permit Number 34719 | 6005865.19335847 | 2111068.58127823 | 37.7769235557198 | -122.423231126893 | (37.7769235557198, -122.423231126893) | 7 | 9 | 11 | 28852 | 10 | |||
184502 | 33607 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 314 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37719 | 6005021.10976005 | 2110082.43632314 | 37.7741681701238 | -122.426080852286 | (37.7741681701238, -122.426080852286) | 7 | 9 | 11 | 28852 | 10 | |||
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 | ||
185167 | 33614 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 312 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37724 | 6005030.32834442 | 2110083.71933458 | 37.7741722139784 | -122.4260490549 | (37.7741722139784, -122.4260490549) | 7 | 9 | 11 | 28852 | 10 | |||
186946 | 33612 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 310 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37722 | 6005039.5469288 | 2110085.00234602 | 37.7741762578244 | -122.42601725751 | (37.7741762578244, -122.42601725751) | 7 | 9 | 11 | 28852 | 10 | |||
190656 | 30538 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 614 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 34538 | 6003619.86564688 | 2110438.7017887 | 37.7750670913733 | -122.430953433821 | (37.7750670913733, -122.430953433821) | 7 | 9 | 11 | 29492 | 10 | ||||
27966 | 173643 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 657 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012793 | 2114089 | 37.7856054636163 | -122.399477673173 | (37.7856054636163, -122.399477673173) | 6 | 2 | 9 | 28853 | 6 | ||||
39551 | 39879 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 301 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41173 | 6015620.67363669 | 2114221.43610992 | 37.786126305998 | -122.389703911477 | (37.786126305998, -122.389703911477) | 6 | 2 | 9 | 28855 | 6 | |||
49450 | 111387 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 469 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014036 | 2112699 | 37.7818580461792 | -122.395079826315 | (37.7818580461792, -122.395079826315) | 6 | 2 | 9 | 28856 | 6 |
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) );