1,977 rows where qSpecies_id = 41 sorted by rowid descending

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);