trees
1,977 rows where qSpecies_id = 41 sorted by TreeID 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30463 | 99864 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 681 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768887 | 5981306.2 | 2111092.9 | 37.7755737343962 | -122.508188499048 | (37.7755737343962, -122.508188499048) | 11 | 6 | 2 | 55 | 26 | ||||
78924 | 99863 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 681 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | 5981324.99313 | 2111098.19167 | 37.7755893711796 | -122.508123883044 | (37.7755893711796, -122.508123883044) | 11 | 6 | 2 | 55 | 26 | ||||
185053 | 99826 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Cascade Walk | 1 | Front Yard : Yard | Tree | Private 2 | 5992183.1 | 2103187.3 | 37.7545020044945 | -122.469987253468 | (37.7545020044945, -122.469987253468) | 1 | 8 | 4 | 56 | 12 | |||||
172353 | 99662 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1337 Portola Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5993559.3 | 2097744.3 | 37.7396363671104 | -122.464832777968 | (37.7396363671104, -122.464832777968) | 1 | 8 | 4 | 59 | 40 | |||||
127814 | 99448 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1601X 15th Ave | 6 | Median : Cutout | Tree | DPW 1 | 5991576.7 | 2104258.5 | 37.7574081656565 | -122.472162400604 | (37.7574081656565, -122.472162400604) | 1 | 8 | 4 | 56 | 12 | |||||
49170 | 99447 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1601X 15th Ave | 5 | Median : Cutout | Tree | DPW 1 | 5991576.7 | 2104258.5 | 37.7574081656565 | -122.472162400604 | (37.7574081656565, -122.472162400604) | 1 | 8 | 4 | 56 | 12 | |||||
152466 | 99446 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1601X 15th Ave | 3 | Median : Cutout | Tree | DPW 1 | 5991576.7 | 2104258.5 | 37.7574081656565 | -122.472162400604 | (37.7574081656565, -122.472162400604) | 1 | 8 | 4 | 56 | 12 | |||||
21438 | 99445 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1601X 15th Ave | 2 | Median : Cutout | Tree | DPW 1 | 5991576.7 | 2104258.5 | 37.7574081656565 | -122.472162400604 | (37.7574081656565, -122.472162400604) | 1 | 8 | 4 | 56 | 12 | |||||
96354 | 99444 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1601X 15th Ave | 1 | Median : Cutout | Tree | DPW 1 | 5991576.7 | 2104258.5 | 37.7574081656565 | -122.472162400604 | (37.7574081656565, -122.472162400604) | 1 | 8 | 4 | 56 | 12 | |||||
138894 | 99164 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 302X Pacheco St | 48 | Median : Cutout | Tree | Private 2 | 24 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
107887 | 99154 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 302X Pacheco St | 37 | Median : Cutout | Tree | Private 2 | 9 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
144747 | 99153 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 302X Pacheco St | 41 | Median : Cutout | Tree | Private 2 | 3 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
182971 | 99152 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 302X Pacheco St | 36 | Median : Cutout | Tree | Private 2 | 9 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
88849 | 99151 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 302X Pacheco St | 35 | Median : Cutout | Tree | Private 2 | 9 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
85788 | 99148 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 302X Pacheco St | 32 | Median : Cutout | Tree | Private 2 | 3 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
167874 | 99146 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 302X Pacheco St | 30 | Median : Cutout | Tree | Private 2 | 3 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
169183 | 99144 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 302X Pacheco St | 27 | Median : Cutout | Tree | Private 2 | 9 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
83269 | 99143 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 302X Pacheco St | 26 | Median : Cutout | Tree | Private 2 | 9 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
74109 | 99136 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 302X Pacheco St | 19 | Median : Cutout | Tree | Private 2 | 36 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
183835 | 99133 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 302X Pacheco St | 16 | Median : Cutout | Tree | Private 2 | 3 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
181187 | 99128 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 302X Pacheco St | 11 | Median : Cutout | Tree | Private 2 | 3 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
72593 | 99125 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 302X Pacheco St | 8 | Median : Cutout | Tree | Private 2 | 3 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
169517 | 99122 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 302X Pacheco St | 3 | Median : Cutout | Tree | Private 2 | 48 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
177984 | 99120 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 302X Pacheco St | 1 | Median : Cutout | Tree | Private 2 | 3 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
162399 | 99047 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 240@Casitas Lansdale Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 42 | Permit Number 768724 | 5994955.6 | 2096712.9 | 37.7368848033667 | -122.459930310697 | (37.7368848033667, -122.459930310697) | 9 | 7 | 4 | 59 | 40 | |||
192549 | 98880 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 101 Lansdale Ave | 1 | Front Yard : Yard | Tree | Private 2 | 11 | 5994747.9 | 2097283.1 | 37.7384384842789 | -122.460689725403 | (37.7384384842789, -122.460689725403) | 9 | 7 | 4 | 59 | 40 | ||||
101121 | 98820 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 302X Pacheco St | 28 | Median : Cutout | Tree | Private 2 | 05/09/2010 12:00:00 AM | Permit Number 768820 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | |||
172476 | 98706 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 353 UPPER TER | Unaccepted Street : Yard | Tree | Private 2 | 5999086.1 | 2105914.9 | 37.7623879420949 | -122.446311165521 | (37.7623879420949, -122.446311165521) | 15 | 5 | 5 | 29492 | 9 | ||||||
145768 | 98703 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 7070@ 32nd Ave California St | 4 | Front Yard : | Tree | Private 2 | 03/10/2012 12:00:00 AM | Permit Number 767466 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.493376058427 | (37.7850123376907, -122.493376058427) | 11 | 6 | 1 | 55 | 33 | |||
30200 | 98503 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 208 Glenview Dr | Back Yard : Yard | Tree | Private 2 | 5998871 | 2100779 | 37.7482737407191 | -122.446685565827 | (37.7482737407191, -122.446685565827) | 2 | 5 | 5 | 63 | 38 | ||||||
137991 | 98379 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 199X Cragmont Ave | 4 | Unaccepted Street : Yard | Tree | Private 2 | 5992899 | 2101153 | 37.7489576989052 | -122.467363590244 | (37.7489576989052, -122.467363590244) | 1 | 8 | 4 | 29491 | 40 | |||||
161675 | 98378 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 199X Cragmont Ave | 3 | Unaccepted Street : Yard | Tree | Private 2 | Permit Number 768647 | 5992899 | 2101153 | 37.7489576989052 | -122.467363590244 | (37.7489576989052, -122.467363590244) | 1 | 8 | 4 | 29491 | 40 | ||||
141724 | 98377 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 199X Cragmont Ave | 2 | Unaccepted Street : Yard | Tree | Private 2 | 5992899 | 2101153 | 37.7489576989052 | -122.467363590244 | (37.7489576989052, -122.467363590244) | 1 | 8 | 4 | 29491 | 40 | |||||
35560 | 98376 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 199X Cragmont Ave | 1 | Unaccepted Street : Yard | Tree | Private 2 | 5992899 | 2101153 | 37.7489576989052 | -122.467363590244 | (37.7489576989052, -122.467363590244) | 1 | 8 | 4 | 29491 | 40 | |||||
75016 | 98140 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 315 San Marcos Ave | Front Yard : Yard | Tree | Private 2 | 5992920.8 | 2100212.1 | 37.7463754865467 | -122.467219803339 | (37.7463754865467, -122.467219803339) | 1 | 8 | 4 | 29491 | 40 | ||||||
142043 | 97731 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1150 Francisco St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | Permit Number 50638 | 6005778.11415 | 2120709.05822 | 37.8033889834786 | -122.424218159845 | (37.8033889834786, -122.424218159845) | 5 | 9 | 1 | 28858 | 32 | |
157400 | 97685 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 84 Coventry Ct | Back Yard : Yard | Tree | Private 2 | 5997084 | 2096485 | 37.7363812239889 | -122.452555087132 | (37.7363812239889, -122.452555087132) | 9 | 7 | 4 | 59 | 40 | ||||||
154478 | 96856 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 324X Alemany Blvd | 1 | Median : Cutout | Tree | DPW 1 | 36 | 410x30 | 6008894.01857 | 2095530.1163 | 37.7344289090546 | -122.4116553033 | (37.7344289090546, -122.4116553033) | 10 | 7 | 7 | 28859 | 2 | |||
12287 | 95982 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 Vasquez Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5995122.4 | 2099706.3 | 37.7451135296363 | -122.459570350972 | (37.7451135296363, -122.459570350972) | 1 | 8 | 4 | 59 | 40 | |||||
180642 | 95331 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 390X Filbert St | 2 | Median : Yard | Tree | DPW 1 | 18 | 6010951.1 | 2119992.4 | 37.8017119430502 | -122.406266229116 | (37.8017119430502, -122.406266229116) | 3 | 1 | 10 | 308 | 23 | ||||
186871 | 95072 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 19 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 54021 | 6003434 | 2097382 | 37.7392059633181 | -122.430664475135 | (37.7392059633181, -122.430664475135) | 2 | 7 | 5 | 63 | 7 | |||
158156 | 93206 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 400 Masonic Ave | 4 | Front Yard : Yard | Tree | Private 2 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.7774714343299 | -122.446572853901 | (37.7774714343299, -122.446572853901) | 15 | 5 | 11 | 29492 | 16 | |||
37603 | 93205 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 400 Masonic Ave | 3 | Front Yard : Yard | Tree | Private 2 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.7774714343299 | -122.446572853901 | (37.7774714343299, -122.446572853901) | 15 | 5 | 11 | 29492 | 16 | |||
98332 | 93204 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 400 Masonic Ave | 1 | Front Yard : Yard | Tree | Private 2 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.7774714343299 | -122.446572853901 | (37.7774714343299, -122.446572853901) | 15 | 5 | 11 | 29492 | 16 | |||
180298 | 93203 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 400 Masonic Ave | 2 | Front Yard : Yard | Tree | Private 2 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.7774714343299 | -122.446572853901 | (37.7774714343299, -122.446572853901) | 15 | 5 | 11 | 29492 | 16 | |||
24231 | 93107 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 15 Mesa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 3x3 | Permit Number 53163 | 5993680.1 | 2100698.2 | 37.7477539957997 | -122.464629544553 | (37.7477539957997, -122.464629544553) | 1 | 8 | 4 | 29491 | 40 | ||
42325 | 92565 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 222 Stanyan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52905 | 5996693 | 2111182 | 37.7767130721687 | -122.454968563419 | (37.7767130721687, -122.454968563419) | 15 | 6 | 2 | 54 | 16 | |||
162467 | 92564 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 222 Stanyan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52905 | 5996693 | 2111182 | 37.7767130721687 | -122.454968563419 | (37.7767130721687, -122.454968563419) | 15 | 6 | 2 | 54 | 16 | |||
130426 | 92563 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 222 Stanyan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52905 | 5996693 | 2111182 | 37.7767130721687 | -122.454968563419 | (37.7767130721687, -122.454968563419) | 15 | 6 | 2 | 54 | 16 | |||
42360 | 92562 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 222 Stanyan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52905 | 5996693 | 2111182 | 37.7767130721687 | -122.454968563419 | (37.7767130721687, -122.454968563419) | 15 | 6 | 2 | 54 | 16 | |||
33711 | 92561 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 222 Stanyan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52905 | 5996693 | 2111182 | 37.7767130721687 | -122.454968563419 | (37.7767130721687, -122.454968563419) | 15 | 6 | 2 | 54 | 16 | |||
193880 | 92560 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 222 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52905 | 5996693 | 2111182 | 37.7767130721687 | -122.454968563419 | (37.7767130721687, -122.454968563419) | 15 | 6 | 2 | 54 | 16 | |||
5238 | 92559 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 222 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52905 | 5996693 | 2111182 | 37.7767130721687 | -122.454968563419 | (37.7767130721687, -122.454968563419) | 15 | 6 | 2 | 54 | 16 | |||
87390 | 91152 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 166 Kensington Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52026 | 5994670.3 | 2098755.2 | 37.7424760401064 | -122.461064697802 | (37.7424760401064, -122.461064697802) | 1 | 8 | 4 | 59 | 40 | |||
144947 | 91139 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 166 Kensington Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | Permit Number 52026 | 5994670.3 | 2098755.2 | 37.7424760401064 | -122.461064697802 | (37.7424760401064, -122.461064697802) | 1 | 8 | 4 | 59 | 40 | |||
118832 | 91138 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 166 Kensington Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | Permit Number 52026 | 5994670.3 | 2098755.2 | 37.7424760401064 | -122.461064697802 | (37.7424760401064, -122.461064697802) | 1 | 8 | 4 | 59 | 40 | |||
37660 | 90814 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 3101X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985939.53004 | 2110416.22532 | 37.7739877194341 | -122.492111077157 | (37.7739877194341, -122.492111077157) | 11 | 6 | 2 | 55 | 26 | ||
123260 | 87819 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 390 Lansdale Ave | 1 | Front Yard : Cutout | Tree | Private 2 | Permit Number 50681 | 5995630.7 | 2096410.1 | 37.7360921919213 | -122.457574304331 | (37.7360921919213, -122.457574304331) | 9 | 7 | 4 | 59 | 40 | ||||
37713 | 87116 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 470 West Portal Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694 | 2096460 | 37.7360022829337 | -122.471188578306 | (37.7360022829337, -122.471188578306) | 1 | 8 | 4 | 29491 | 40 | |||
49363 | 87064 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 101 Arbor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2007 12:00:00 AM | Permit Number 50006 | 6001805 | 2096722 | 37.737301333655 | -122.436249595043 | (37.737301333655, -122.436249595043) | 2 | 7 | 5 | 63 | 7 | |||
87265 | 86903 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 233 Drake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2007 12:00:00 AM | 3x3 | Permit Number 49863 | 6001780 | 2086418 | 37.7090074518569 | -122.435599089406 | (37.7090074518569, -122.435599089406) | 9 | 7 | 6 | 28861 | 5 | ||
187891 | 8650 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2800 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5998245.1291 | 2113130.374 | 37.7821517178635 | -122.449739754186 | (37.7821517178635, -122.449739754186) | 15 | 6 | 2 | 54 | 16 | |||
192234 | 8622 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2600 Geary Blvd | 10 | Median : Cutout | Tree | DPW 1 | 12 | 20 | 5999315.0497 | 2113216.8408 | 37.782450288182 | -122.446044546347 | (37.782450288182, -122.446044546347) | 15 | 5 | 1 | 54 | 16 | |||
37188 | 8603 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2400 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 36 | 6 | 5999987.1554 | 2113318.7057 | 37.7827683400756 | -122.443726682203 | (37.7827683400756, -122.443726682203) | 15 | 5 | 1 | 29490 | 31 | |||
148420 | 8602 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2400 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 36 | 6 | 6000066.0077 | 2113328.1816 | 37.7827988555755 | -122.443454568276 | (37.7827988555755, -122.443454568276) | 15 | 5 | 1 | 29490 | 16 | |||
22973 | 8585 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2200 Geary Blvd | 12 | Median : Cutout | Tree | DPW 1 | 06/01/1994 12:00:00 AM | 6 | 6 | 6000465.007 | 2113386.3901 | 37.7829814273003 | -122.442078382069 | (37.7829814273003, -122.442078382069) | 15 | 5 | 1 | 29490 | 41 | ||
96320 | 8584 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2200 Geary Blvd | 11 | Median : Cutout | Tree | DPW 1 | 36 | 6 | 6000533.0297 | 2113398.5733 | 37.7830187554699 | -122.441843926918 | (37.7830187554699, -122.441843926918) | 15 | 5 | 1 | 29490 | 41 | |||
66983 | 8583 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2200 Geary Blvd | 10 | Median : Cutout | Tree | DPW 1 | 36 | 6 | 6000590.223 | 2113406.0186 | 37.7830424571155 | -122.441646596602 | (37.7830424571155, -122.441646596602) | 15 | 5 | 1 | 29490 | 41 | |||
30557 | 8580 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2200 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 06/01/1994 12:00:00 AM | 6 | 6 | 6000778.3855 | 2113430.8926 | 37.7831214735368 | -122.44099741813 | (37.7831214735368, -122.44099741813) | 15 | 5 | 11 | 29490 | 41 | ||
125323 | 8579 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2200 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6000836.5941 | 2113437.661 | 37.7831433729932 | -122.440796526182 | (37.7831433729932, -122.440796526182) | 15 | 5 | 11 | 29490 | 41 | |||
13332 | 8534 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2100 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 06/10/1994 12:00:00 AM | 6 | 6 | 6001381.7916 | 2113512.283 | 37.7833793 | -122.438915716928 | (37.7833793, -122.438915716928) | 15 | 5 | 11 | 29490 | 41 | ||
4324 | 8533 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2100 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6001504.6387 | 2113566.4305 | 37.783534963845 | -122.438494596028 | (37.783534963845, -122.438494596028) | 15 | 5 | 11 | 29490 | 41 | |||
187724 | 8531 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2100 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6001578.5839 | 2113601.7956 | 37.7836362733136 | -122.438241309064 | (37.7836362733136, -122.438241309064) | 15 | 5 | 11 | 29490 | 41 | |||
48834 | 85239 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 200 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2007 12:00:00 AM | Permit Number 49542 | 5994792 | 2096029 | 37.7349975719357 | -122.460446404237 | (37.7349975719357, -122.460446404237) | 9 | 8 | 4 | 59 | 40 | |||
21932 | 85238 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 200 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2007 12:00:00 AM | Permit Number 49542 | 5994792 | 2096029 | 37.7349975719357 | -122.460446404237 | (37.7349975719357, -122.460446404237) | 9 | 8 | 4 | 59 | 40 | |||
32630 | 85060 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 7070 California St | 1 | Front Yard : Cutout | Tree | Private 2 | 07/03/2007 12:00:00 AM | Permit Number 49405 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
96990 | 8476 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1900 Geary Blvd | 13 | Median : Cutout | Tree | DPW 1 | 48 | 8 | 6001756.763 | 2113633.6072 | 37.783733752237 | -122.437627157513 | (37.783733752237, -122.437627157513) | 13 | 5 | 11 | 29490 | 41 | |||
184619 | 8473 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1900 Geary Blvd | 10 | Median : Cutout | Tree | DPW 1 | 48 | 8 | 6001933.4192 | 2113657.2968 | 37.7838088404542 | -122.437017691332 | (37.7838088404542, -122.437017691332) | 13 | 5 | 11 | 29490 | 41 | |||
88723 | 8470 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1900 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6002187.2355 | 2113695.2 | 37.7839273365059 | -122.436142296427 | (37.7839273365059, -122.436142296427) | 13 | 5 | 11 | 29490 | 41 | |||
105300 | 8468 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1900 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6002285.3778 | 2113701.9684 | 37.7839514961521 | -122.435803245129 | (37.7839514961521, -122.435803245129) | 13 | 5 | 11 | 29490 | 41 | |||
43926 | 8467 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1900 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6002321.2505 | 2113708.7369 | 37.783972118374 | -122.435679623339 | (37.783972118374, -122.435679623339) | 13 | 5 | 11 | 29490 | 41 | |||
56795 | 8466 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1900 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6002359.1538 | 2113715.5053 | 37.7839928555225 | -122.435548976348 | (37.7839928555225, -122.435548976348) | 13 | 5 | 11 | 29490 | 41 | |||
66774 | 8464 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1900 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 17 | 8 | 6002427.515 | 2113723.6274 | 37.7840190391748 | -122.435313053048 | (37.7840190391748, -122.435313053048) | 13 | 5 | 11 | 29490 | 41 | |||
125484 | 8401 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1500 Geary Blvd | 12 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6003886.7265 | 2113933.9476 | 37.7846792853457 | -122.430279723684 | (37.7846792853457, -122.430279723684) | 13 | 9 | 11 | 29490 | 41 | |||
55029 | 8400 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1500 Geary Blvd | 11 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6003921.0381 | 2113941.5724 | 37.7847021645415 | -122.430161561145 | (37.7847021645415, -122.430161561145) | 13 | 9 | 11 | 29490 | 41 | |||
79527 | 8399 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1500 Geary Blvd | 10 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6003960.687 | 2113944.6223 | 37.7847127843654 | -122.430024606782 | (37.7847127843654, -122.430024606782) | 13 | 9 | 11 | 29490 | 41 | |||
102237 | 8398 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1500 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6003997.2859 | 2113948.4347 | 37.7847253249416 | -122.429898258777 | (37.7847253249416, -122.429898258777) | 13 | 9 | 11 | 29490 | 41 | |||
100264 | 8396 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1500 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 06/09/1994 12:00:00 AM | 6 | 8 | 6004125.3824 | 2113965.9717 | 37.7847807304874 | -122.429456338379 | (37.7847807304874, -122.429456338379) | 13 | 9 | 11 | 29490 | 41 | ||
66906 | 8221 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2100X Funston Ave | 12 | Median : Cutout | Tree | DPW 1 | 6 | 8X25 | 5992292.4750795 | 2101127.8707395 | 37.7488536670461 | -122.469459107919 | (37.7488536670461, -122.469459107919) | 1 | 8 | 4 | 29491 | 40 | |||
76778 | 8220 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2100X Funston Ave | 11 | Median : Cutout | Tree | DPW 1 | 6 | 8X25 | 5992292.4750795 | 2101127.8707395 | 37.7488536670461 | -122.469459107919 | (37.7488536670461, -122.469459107919) | 1 | 8 | 4 | 29491 | 40 | |||
174914 | 8214 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2189X Funston Ave | 5 | Median : Cutout | Tree | DPW 1 | 6 | 8X25 | 5992287.42413 | 2100535.51604 | 37.7472269214863 | -122.469433461595 | (37.7472269214863, -122.469433461595) | 1 | 8 | 4 | 29491 | 40 | |||
58461 | 750 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2301X 36th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/19/2016 01:42:00 PM | 3 | 6 | 5985126.5669837 | 2099532.1780828 | 37.7440555948275 | -122.494120857895 | (37.7440555948275, -122.494120857895) | 1 | 8 | 3 | 29491 | 35 | ||
49827 | 53726 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/1972 12:00:00 AM | 8 | Permit Number 9405 | 6012451.87174 | 2095251.14558 | 37.7338618519323 | -122.399334980939 | (37.7338618519323, -122.399334980939) | 10 | 3 | 8 | 58 | 1 | ||
165899 | 5052 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 5399X Diamond Heights Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 27 | 6001966.99767 | 2098545.79058 | 37.7423182410096 | -122.43581994755 | (37.7423182410096, -122.43581994755) | 2 | 7 | 5 | 63 | 22 | ||||
152904 | 5051 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 5399X Diamond Heights Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 6001971.36584 | 2098533.18854 | 37.7422838868872 | -122.43580394232 | (37.7422838868872, -122.43580394232) | 2 | 7 | 5 | 63 | 22 | ||||
8755 | 5050 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 5399X Diamond Heights Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | 6001979.62541 | 2098516.88417 | 37.7422395880754 | -122.43577421703 | (37.7422395880754, -122.43577421703) | 2 | 7 | 5 | 63 | 22 | ||||
161451 | 5049 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 5399X Diamond Heights Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 39 | 6001985.29603 | 2098499.31047 | 37.7421916569134 | -122.435753352751 | (37.7421916569134, -122.435753352751) | 2 | 7 | 5 | 63 | 22 | ||||
62397 | 5048 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 5399X Diamond Heights Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 6002000.04243 | 2098472.35983 | 37.7421184943815 | -122.435700436623 | (37.7421184943815, -122.435700436623) | 2 | 7 | 5 | 63 | 22 | ||||
33268 | 5047 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 5399X Diamond Heights Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 6002007.86459 | 2098449.21717 | 37.7420553943514 | -122.43567173476 | (37.7420553943514, -122.43567173476) | 2 | 7 | 5 | 63 | 22 | ||||
86424 | 5046 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 5399X Diamond Heights Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 6002013.96438 | 2098440.0292 | 37.7420305128012 | -122.43564998647 | (37.7420305128012, -122.43564998647) | 2 | 7 | 5 | 63 | 22 |
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) );