trees
1,977 rows where qSpecies_id = 41 sorted by rowid descending
This data as json, CSV (advanced)
rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
184332 | 186467 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1601 Sunset Blvd | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 57 | Width 0ft | 5984746.8052 | 2103766.8566 | 37.7556606314016 | -122.495746271784 | (37.7556606314016, -122.495746271784) | 1 | 8 | 3 | 56 | 35 | |||
183869 | 12462 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 90M | 5985224.7663097 | 2094165.6248747 | 37.7293262181041 | -122.49338600271 | (37.7293262181041, -122.49338600271) | 1 | 8 | 4 | 64 | 14 | |||
183855 | 206885 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 355 Parnassus Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | Width 5ft | 5996145.42285 | 2106474.68713 | 37.76375658663 | -122.456522296986 | (37.76375658663, -122.456522296986) | 15 | 5 | 4 | 29492 | 12 | |||
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 | ||||
183817 | 186057 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1901 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 55 | Width 0ft | 5984823.8849 | 2102196.9806 | 37.7513546987086 | -122.495363937437 | (37.7513546987086, -122.495363937437) | 1 | 8 | 3 | 29491 | 35 | |||
183787 | 185002 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2701 Sunset Blvd | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985002.5407 | 2096492.8922 | 37.735703275025 | -122.49432572255 | (37.735703275025, -122.49432572255) | 1 | 8 | 3 | 29491 | 35 | |||
183596 | 20783 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1701X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984888.092725 | 2103630.7874996 | 37.7552952964732 | -122.49524762816 | (37.7552952964732, -122.49524762816) | 1 | 8 | 3 | 56 | 35 | |||
183210 | 120110 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 90X Knollview Way | 1 | Back Yard : Yard | Tree | Private 2 | 20 | 3x25 | 5997618 | 2101448 | 37.7500389946504 | -122.451066619924 | (37.7500389946504, -122.451066619924) | 1 | 5 | 4 | 63 | 38 | |||
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 | ||||
182612 | 185113 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2801 Sunset Blvd | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 43 | Width 0ft | 5985054.6718 | 2095908.982 | 37.7341030638616 | -122.494102465407 | (37.7341030638616, -122.494102465407) | 1 | 8 | 3 | 29491 | 35 | |||
182533 | 20916 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1901X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5984934.4009631 | 2102260.4913733 | 37.7515355521167 | -122.494986448304 | (37.7515355521167, -122.494986448304) | 1 | 8 | 3 | 29491 | 35 | |||
182477 | 142131 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2200x GEARY BLVD | 14 | Median : Cutout | Tree | DPW 1 | 20 | Width 0ft | 6000333.6993 | 2113366.7616 | 37.7829200486713 | -122.442531241518 | (37.7829200486713, -122.442531241518) | 15 | 5 | 1 | 29490 | 41 | |||
182388 | 181475 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1400 Sunset Blvd | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 0ft | 5984869.4504 | 2105277.3411 | 37.7598151838233 | -122.495433528613 | (37.7598151838233, -122.495433528613) | 1 | 8 | 3 | 56 | 35 | |||
182340 | 223801 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2541 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6002300.36552 | 2097102.16795 | 37.7383733198592 | -122.434564064986 | (37.7383733198592, -122.434564064986) | 2 | 7 | 5 | 63 | 7 | |||
182163 | 109677 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 200X VIDAL DR | 6 | Median : Yard | Tree | DPW 1 | 5987624 | 2090693 | 37.7199313280832 | -122.484837086298 | (37.7199313280832, -122.484837086298) | 1 | 8 | 4 | 64 | 14 | |||||
181999 | 109893 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1408x SUNSET BLVD | 3 | Median : Cutout | Tree | DPW 1 | 40 | 3x3 | 5984818 | 2105324 | 37.7599402834086 | -122.49561490918 | (37.7599402834086, -122.49561490918) | 1 | 8 | 3 | 56 | 35 | |||
181658 | 185359 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2601 Sunset Blvd | 84 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | Width 0ft | 5984996.2598 | 2096910.7786 | 37.7368503118256 | -122.49437823177 | (37.7368503118256, -122.49437823177) | 1 | 8 | 3 | 29491 | 35 | |||
181580 | 253707 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Monument Way | 4 | Unaccepted Street : Yard | Tree | Private 2 | 10x10 | 5999088 | 2105836 | 37.7621714109075 | -122.446298918118 | (37.7621714109075, -122.446298918118) | 15 | 5 | 5 | 29492 | 3 | ||||
181537 | 186302 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1800 Sunset Blvd | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984990.1286 | 2102749.3532 | 37.7528810944721 | -122.49482977812 | (37.7528810944721, -122.49482977812) | 1 | 8 | 3 | 56 | 35 | |||
181265 | 11185 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 110 Idora Ave | 1 | Median : Cutout | Tree | DPW 1 | 48 | 8 | 5995900.4612004 | 2099322.604417 | 37.7441047056077 | -122.45685222203 | (37.7441047056077, -122.45685222203) | 1 | 8 | 4 | 59 | 40 | |||
181263 | 223746 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 591 27th St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 6002725.9014 | 2100031.26808 | 37.7464400956267 | -122.433302014896 | (37.7464400956267, -122.433302014896) | 2 | 7 | 5 | 63 | 22 | |||
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 | ||||
181158 | 186686 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1401 Sunset Blvd | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 0ft | 5984721.1583 | 2105332.5693 | 37.7599581409009 | -122.495950464805 | (37.7599581409009, -122.495950464805) | 1 | 8 | 3 | 56 | 35 | |||
181124 | 181434 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1500 Sunset Blvd | 67 | Sidewalk: Property side : Yard | Tree | Private 2 | 63 | Width 0ft | 5984896.7414 | 2104905.8493 | 37.7587967687687 | -122.495311746922 | (37.7587967687687, -122.495311746922) | 1 | 8 | 3 | 56 | 35 | |||
181057 | 187171 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2301 Sunset Blvd | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 0ft | 5984928.5376 | 2099290.2101 | 37.7433796265961 | -122.494787752732 | (37.7433796265961, -122.494787752732) | 1 | 8 | 3 | 29491 | 35 | |||
180987 | 176104 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700x Mansell St | 19 | Median : Cutout | Tree | DPW 1 | 26 | Width 0ft | 6009423.26816 | 2090026.7428 | 37.7193474820922 | -122.409437239052 | (37.7193474820922, -122.409437239052) | 9 | 3 | 8 | 309 | 18 | |||
180884 | 20990 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2003X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984964.2584556 | 2101570.8346889 | 37.7496436917689 | -122.494832355741 | (37.7496436917689, -122.494832355741) | 1 | 8 | 3 | 29491 | 35 | |||
180830 | 223776 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 615 Sanchez St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | Width 3ft | 6003693.2777 | 2104674.35169 | 37.7592437427153 | -122.430288141204 | (37.7592437427153, -122.430288141204) | 2 | 4 | 5 | 28862 | 3 | |||
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 | ||||
180566 | 20825 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1801X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984911.465596 | 2102939.293478 | 37.7533980132231 | -122.495115810531 | (37.7533980132231, -122.495115810531) | 1 | 8 | 3 | 56 | 35 | |||
180517 | 186852 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2700 Sunset Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 40 | Width 0ft | 5985203.396 | 2096268.9816 | 37.7351002284248 | -122.493614804408 | (37.7351002284248, -122.493614804408) | 1 | 8 | 3 | 29491 | 35 | |||
180396 | 223709 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1201 San Jose Ave | 12 | Front Yard : Yard | Tree | Private 2 | 24 | 6004249.02504 | 2095933.99045 | 37.7352761977326 | -122.427743340379 | (37.7352761977326, -122.427743340379) | 2 | 7 | 5 | 28861 | 2 | ||||
180356 | 185416 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2300 Sunset Blvd | 32 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 5985081.6412 | 2099232.3776 | 37.7432297948783 | -122.494254105516 | (37.7432297948783, -122.494254105516) | 1 | 8 | 3 | 29491 | 35 | |||
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 | |||
180253 | 186460 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1601 Sunset Blvd | 48 | Sidewalk: Property side : Yard | Tree | Private 2 | 51 | Width 0ft | 5984775.2784 | 2103839.2958 | 37.7558611968 | -122.495653146825 | (37.7558611968, -122.495653146825) | 1 | 8 | 3 | 56 | 35 | |||
180214 | 20488 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1204 Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
180153 | 20991 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2003X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | 5984964.2584556 | 2101570.8346889 | 37.7496436917689 | -122.494832355741 | (37.7496436917689, -122.494832355741) | 1 | 8 | 3 | 29491 | 35 | |||
180131 | 115391 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 21X BELMONT AVE | 1 | Front Yard : Yard | Tree | Private 2 | 48 | 5996611 | 2106266 | 37.7632103037359 | -122.454896938495 | (37.7632103037359, -122.454896938495) | 15 | 5 | 11 | 29492 | 12 | ||||
180053 | 21009 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2003X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984964.2584556 | 2101570.8346889 | 37.7496436917689 | -122.494832355741 | (37.7496436917689, -122.494832355741) | 1 | 8 | 3 | 29491 | 35 | |||
180052 | 109251 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 53X DEDMAN CT | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 6016647 | 2096311 | 37.7370049195852 | -122.384904830601 | (37.7370049195852, -122.384904830601) | 10 | 3 | 8 | 58 | 1 | ||||
180024 | 20724 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1601X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 60 | 5984865.3499442 | 2104298.7792234 | 37.7571280850658 | -122.495375540207 | (37.7571280850658, -122.495375540207) | 1 | 8 | 3 | 56 | 35 | |||
179968 | 21456 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2701X Sunset Blvd | 9 | Median : Cutout | Tree | DPW 1 | 02/11/2016 05:16:00 AM | 3 | 40 | 5985119.0068215 | 2096832.7848434 | 37.7366433445438 | -122.493948101207 | (37.7366433445438, -122.493948101207) | 1 | 8 | 3 | 29491 | 35 | ||
179642 | 258204 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 29 Highland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6005138.67888 | 2096702.23576 | 37.7374359124473 | -122.42472211206 | (37.7374359124473, -122.42472211206) | 2 | 7 | 5 | 28859 | 2 | ||||
179629 | 138268 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2800x GEARY BLVD | 3 | Median : Cutout | Tree | DPW 1 | 42 | Width 0ft | 5998223.1317 | 2113127.3282 | 37.7821420963388 | -122.449815635357 | (37.7821420963388, -122.449815635357) | 15 | 6 | 2 | 54 | 16 | |||
179471 | 186090 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1901 Sunset Blvd | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | Width 0ft | 5984840.151 | 2101807.9022 | 37.7502873486345 | -122.495278998058 | (37.7502873486345, -122.495278998058) | 1 | 8 | 3 | 29491 | 35 | |||
179410 | 186286 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1800 Sunset Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | Width 0ft | 5984984.8932 | 2102573.7647 | 37.752398670298 | -122.494834937777 | (37.752398670298, -122.494834937777) | 1 | 8 | 3 | 56 | 35 | |||
179383 | 176133 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800 John Muir Dr | 1 | : | Tree | Private 2 | 10 | Width 0ft | 5987205.94604 | 2086467.25904 | 37.7083041517833 | -122.485972119031 | (37.7083041517833, -122.485972119031) | 1 | 8 | 4 | 64 | 14 | |||
179327 | 29618 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 900X Junipero Serra Blvd | 27 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991164.47662 | 2090887.55637 | 37.720671104264 | -122.472613181078 | (37.720671104264, -122.472613181078) | 9 | 8 | 4 | 64 | 40 | ||
179102 | 205907 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 30 Martha Ave | 1 | Front Yard : Yard | Tree | Private 2 | 34 | 6000842.20104 | 2095534.19328 | 37.7339851426839 | -122.439493304878 | (37.7339851426839, -122.439493304878) | 9 | 7 | 5 | 63 | 40 | ||||
179090 | 185859 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2000 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 0ft | 5985005.3894 | 2100970.4754 | 37.7479976767482 | -122.494645870862 | (37.7479976767482, -122.494645870862) | 1 | 8 | 3 | 29491 | 35 | |||
179038 | 223753 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 3978 22nd St | 2 | : | Tree | Private 2 | 17 | 6001987.95274 | 2102949.84042 | 37.7544119092884 | -122.436062565734 | (37.7544119092884, -122.436062565734) | 2 | 4 | 5 | 28862 | 22 | ||||
178929 | 21049 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2101X Sunset Blvd | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.494725332997 | (37.7478054765444, -122.494725332997) | 1 | 8 | 3 | 29491 | 35 | |||
178909 | 176103 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 50 Kelloch Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 6ft | 6008313.99103 | 2086238.62297 | 37.7088838754685 | -122.413003909814 | (37.7088838754685, -122.413003909814) | 9 | 7 | 8 | 309 | 39 | |||
178885 | 21378 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2601X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40 | 5985098.343425 | 2097506.3093477 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | 1 | 8 | 3 | 29491 | 35 | |||
178742 | 186911 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2700 Sunset Blvd | 60 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985189.7183 | 2096710.0524 | 37.7363104911026 | -122.493694583533 | (37.7363104911026, -122.493694583533) | 1 | 8 | 3 | 29491 | 35 | |||
178698 | 185454 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2400 Sunset Blvd | 4 | unknown : Yard | Tree | Private 2 | 25 | Width 0ft | 5985131.0337 | 2098272.681 | 37.7405976170701 | -122.494012607503 | (37.7405976170701, -122.494012607503) | 1 | 8 | 3 | 29491 | 35 | |||
178693 | 251623 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 76R Amber Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5999293 | 2100015 | 37.7462000785932 | -122.44517138727 | (37.7462000785932, -122.44517138727) | 2 | 7 | 5 | 63 | 22 | |||||
178298 | 206858 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700 Junipero Serra Blvd | 66 | : | Tree | Private 2 | 19 | Width 0ft | 5991244.79193 | 2092323.0787 | 37.7246173419947 | -122.472440157785 | (37.7246173419947, -122.472440157785) | 9 | 8 | 4 | 64 | 40 | |||
178096 | 117248 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 299x GRAYSTONE TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999641 | 2104067 | 37.7573457417117 | -122.44425918093 | (37.7573457417117, -122.44425918093) | 2 | 5 | 5 | 28862 | 3 | ||||
177997 | 185453 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2400 Sunset Blvd | 3 | unknown : Yard | Tree | Private 2 | 32 | Width 0ft | 5985125.7214 | 2098256.744 | 37.7405535475207 | -122.494029800854 | (37.7405535475207, -122.494029800854) | 1 | 8 | 3 | 29491 | 35 | |||
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 | ||||
177820 | 205897 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 5 Sequoia Way | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5998217.20085 | 2097803.5301 | 37.7400664537036 | -122.448732094232 | (37.7400664537036, -122.448732094232) | 9 | 7 | 4 | 59 | 40 | |||
177803 | 109674 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 200X VIDAL DR | 3 | Median : Yard | Tree | DPW 1 | 5987624 | 2090693 | 37.7199313280832 | -122.484837086298 | (37.7199313280832, -122.484837086298) | 1 | 8 | 4 | 64 | 14 | |||||
177746 | 187052 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2501 Sunset Blvd | 71 | Sidewalk: Property side : Yard | Tree | Private 2 | 40 | Width 0ft | 5984975.6777 | 2097633.6281 | 37.7388338582522 | -122.494502663013 | (37.7388338582522, -122.494502663013) | 1 | 8 | 3 | 29491 | 35 | |||
177632 | 187386 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2200 Sunset Blvd | 72 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985083.4165 | 2100125.6383 | 37.745682550612 | -122.494313795975 | (37.745682550612, -122.494313795975) | 1 | 8 | 3 | 29491 | 35 | |||
177630 | 253322 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2 Euclid Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999085 | 2114289 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | 15 | 6 | 1 | 54 | 31 | |||||
177581 | 251609 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 56R Amber Dr | 2 | Back Yard : Yard | Tree | Private 2 | 5999423 | 2100048 | 37.7462981080439 | -122.44472423658 | (37.7462981080439, -122.44472423658) | 2 | 7 | 5 | 63 | 22 | |||||
177564 | 206906 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 901 Monterey Blvd | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5996084.83474 | 2094632.78414 | 37.7312381895837 | -122.455875742899 | (37.7312381895837, -122.455875742899) | 9 | 7 | 4 | 59 | 40 | |||
177526 | 20824 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1801X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984911.465596 | 2102939.293478 | 37.7533980132231 | -122.495115810531 | (37.7533980132231, -122.495115810531) | 1 | 8 | 3 | 56 | 35 | |||
177432 | 102706 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 1342 Funston Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5992135.4 | 2106294.8 | 37.7630316255695 | -122.470378504645 | (37.7630316255695, -122.470378504645) | 1 | 8 | 11 | 56 | 12 | |||||
177431 | 206894 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 380 Santa Clara Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5993143.80759 | 2095435.75112 | 37.7332737043188 | -122.466101646097 | (37.7332737043188, -122.466101646097) | 9 | 8 | 4 | 59 | 40 | |||
177430 | 187188 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2301 Sunset Blvd | 50 | Sidewalk: Property side : Yard | Tree | Private 2 | 34 | Width 0ft | 5984927.7969 | 2099125.0247 | 37.7429260288422 | -122.494778137641 | (37.7429260288422, -122.494778137641) | 1 | 8 | 3 | 29491 | 35 | |||
177307 | 250696 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 877 El Camino Del Mar | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5985597.38635 | 2114946.90963 | 37.7864076698265 | -122.493628505377 | (37.7864076698265, -122.493628505377) | 11 | 6 | 1 | 55 | 15 | |||
177263 | 217774 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 470 West Portal Ave | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 38 | 5991475.84703 | 2096085.92397 | 37.7349625438702 | -122.471915558083 | (37.7349625438702, -122.471915558083) | 1 | 8 | 4 | 29491 | 40 | ||||
176926 | 173923 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2160X 09th Ave | 11 | Median : Cutout | Tree | DPW 1 | 6x10 | 5993671 | 2100995 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | 1 | 8 | 4 | 29491 | 40 | ||||
176739 | 258666 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 10X Mendosa Ave | 13 | Median : Cutout | Tree | Private 2 | 3x3 | 5993533 | 2101170 | 37.749040957039 | -122.465172468022 | (37.749040957039, -122.465172468022) | 1 | 8 | 4 | 29491 | 40 | ||||
176697 | 126421 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 957 Green St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | 6008400.763 | 2118955.03362 | 37.7987206054154 | -122.415018129477 | (37.7987206054154, -122.415018129477) | 5 | 1 | 10 | 308 | 21 | ||||
176180 | 223704 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1100 San Jose Ave | 78 | Front Yard : Yard | Tree | Private 2 | 40 | 6004560.21701 | 2096406.89693 | 37.7365922907993 | -122.426701100777 | (37.7365922907993, -122.426701100777) | 2 | 7 | 5 | 63 | 7 | ||||
176010 | 185571 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2201 Sunset Blvd | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 62 | Width 0ft | 5984908.6272 | 2099694.7862 | 37.7444893174212 | -122.494886420663 | (37.7444893174212, -122.494886420663) | 1 | 8 | 3 | 29491 | 35 | |||
175998 | 205888 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 300 Hazelwood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 3ft | 5996225.80911 | 2095294.33142 | 37.7330627287585 | -122.455436166843 | (37.7330627287585, -122.455436166843) | 9 | 7 | 4 | 59 | 40 | |||
175942 | 249787 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 173 Chestnut St | 1 | Front Yard : Yard | Tree | Private 2 | 23 | Width 0ft | 6010924.52484 | 2121034.42071 | 37.8045715892836 | -122.40643165799 | (37.8045715892836, -122.40643165799) | 3 | 1 | 10 | 308 | 23 | |||
175747 | 20530 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1303X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.495741360313 | (37.7626943540195, -122.495741360313) | 1 | 8 | 3 | 56 | 35 | |||
175559 | 186414 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1601 Sunset Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984773.6035 | 2104227.8714 | 37.7569280195247 | -122.49568759978 | (37.7569280195247, -122.49568759978) | 1 | 8 | 3 | 56 | 35 | |||
175543 | 250197 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 201 Union St | 3 | Side Yard : Yard | Tree | Private 2 | 14 | Width 0ft | 6011839.72623 | 2119769.92251 | 37.8011507408769 | -122.403175497057 | (37.8011507408769, -122.403175497057) | 3 | 1 | 10 | 308 | 23 | |||
175486 | 185434 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2300 Sunset Blvd | 50 | unknown : Yard | Tree | Private 2 | 20 | Width 0ft | 5985080.6415 | 2099410.3284 | 37.7437183411386 | -122.494270675975 | (37.7437183411386, -122.494270675975) | 1 | 8 | 3 | 29491 | 35 | |||
175426 | 13284 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2576 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 26 | 3X3 | 6000068.81033 | 2119230.46658 | 37.799005143246 | -122.443869066799 | (37.799005143246, -122.443869066799) | 13 | 9 | 1 | 57 | 17 | ||
175385 | 185538 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2201 Sunset Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 56 | Width 0ft | 5984886.3401 | 2100056.9512 | 37.7454824194744 | -122.494990183038 | (37.7454824194744, -122.494990183038) | 1 | 8 | 3 | 29491 | 35 | |||
175257 | 111587 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 730X Lake Merced Blvd | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 48 | 5987577.49507 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | 1 | 8 | 4 | 64 | 14 | ||||
175224 | 247577 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 300x Alemany Blvd | 1 | Median : Yard | Tree | DPW 1 | 44 | 6008700.9232 | 2095336.3735 | 37.7338860994661 | -122.412309210505 | (37.7338860994661, -122.412309210505) | 9 | 7 | 7 | 28859 | 2 | ||||
175164 | 206813 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 198x San Anselmo Ave | 5 | Median : Yard | Tree | DPW 1 | 12 | 5993675.924 | 2096312.14772 | 37.7357107573442 | -122.464325594759 | (37.7357107573442, -122.464325594759) | 9 | 8 | 4 | 59 | 40 | ||||
175079 | 184738 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1301 Sunset Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 61 | Width 0ft | 5984659.3131 | 2106254.4766 | 37.7624858178148 | -122.496232374853 | (37.7624858178148, -122.496232374853) | 1 | 8 | 3 | 56 | 35 | |||
175016 | 249916 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 358 Greenwich St | 1 | Back Yard : Yard | Tree | Private 2 | 20 | Width 0ft | 6011201.85513 | 2120410.11068 | 37.8028728976405 | -122.405427930969 | (37.8028728976405, -122.405427930969) | 3 | 1 | 10 | 308 | 23 | |||
174998 | 20896 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1901X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5984934.4009631 | 2102260.4913733 | 37.7515355521167 | -122.494986448304 | (37.7515355521167, -122.494986448304) | 1 | 8 | 3 | 29491 | 35 | |||
174954 | 126417 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2745 Larkin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6006522.5634 | 2120685.74713 | 37.8033669833519 | -122.421640303563 | (37.8033669833519, -122.421640303563) | 5 | 9 | 1 | 28858 | 32 | ||||
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 | |||
174778 | 109652 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 23 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
174762 | 185414 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2300 Sunset Blvd | 30 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5985079.1419 | 2099209.8838 | 37.743167886728 | -122.494261089675 | (37.743167886728, -122.494261089675) | 1 | 8 | 3 | 29491 | 35 | |||
174756 | 206868 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700 Junipero Serra Blvd | 142 | : | Tree | Private 2 | 24 | Width 0ft | 5991190.24782 | 2091564.06571 | 37.7225301234522 | -122.472573395965 | (37.7225301234522, -122.472573395965) | 9 | 8 | 4 | 64 | 40 | |||
174748 | 123499 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2550 Fulton St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 1ft | 5995451.11899 | 2110348.56887 | 37.7743533701225 | -122.459204202763 | (37.7743533701225, -122.459204202763) | 11 | 6 | 2 | 54 | 11 | |||
174622 | 20998 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2003X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5984964.2584556 | 2101570.8346889 | 37.7496436917689 | -122.494832355741 | (37.7496436917689, -122.494832355741) | 1 | 8 | 3 | 29491 | 35 |
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) );