Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
154810 | 154810 | 187404 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 50 | Width 0ft | 5985026.9229 | 2100775.7749 | 37.747464342604104 | -122.49455705885799 | (37.7474643426041, -122.494557058858) | |||
158656 | 158656 | 186246 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1701 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 59 | Width 0ft | 5984800.2947 | 2103186.8747 | 37.7540712938714 | -122.49551851619199 | (37.7540712938714, -122.495518516192) | |||
172640 | 172640 | 185503 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 57 | unknown : Yard 19 | Tree 1 | Private 1 | 40 | Width 0ft | 5985131.0337 | 2098785.3193 | 37.7420051837622 | -122.49405038008001 | (37.7420051837622, -122.49405038008) | |||
42102 | 42102 | 186245 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1701 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984817.4364 | 2103195.9813 | 37.7540973018155 | -122.495459908525 | (37.7540973018155, -122.495459908525) | |||
52849 | 52849 | 181423 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984896.1844 | 2104792.2296 | 37.758484768072904 | -122.49530529413 | (37.7584847680729, -122.49530529413) | |||
58661 | 58661 | 187194 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 52 | Width 0ft | 5984914.4635 | 2099065.395 | 37.7427615213468 | -122.494819844657 | (37.7427615213468, -122.494819844657) | |||
59574 | 59574 | 186318 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1800 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 0ft | 5984972.4087 | 2102856.8811 | 37.7531752992143 | -122.494898983562 | (37.7531752992143, -122.494898983562) | |||
67904 | 67904 | 185572 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 48 | Width 0ft | 5984879.9724 | 2099676.4789 | 37.7444373731189 | -122.49498415201599 | (37.7444373731189, -122.494984152016) | |||
131376 | 131376 | 187120 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2600 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 0ft | 5985153.1122 | 2097319.0095 | 37.7379803828802 | -122.493866007061 | (37.7379803828802, -122.493866007061) | |||
136260 | 136260 | 185203 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2500 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985125.3894 | 2097982.8278 | 37.739801427846 | -122.49401076629 | (37.739801427846, -122.49401076629) | |||
149016 | 149016 | 185997 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2001 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 87 | Width 0ft | 5984874.4912 | 2100963.0377 | 37.7479695924465 | -122.495097956423 | (37.7479695924465, -122.495097956423) | |||
186166 | 186166 | 181496 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 0ft | 5984867.2226 | 2105416.0239 | 37.7601958376586 | -122.495451461713 | (37.7601958376586, -122.495451461713) | |||
40549 | 40549 | 185571 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201 Sunset Blvd | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 62 | Width 0ft | 5984908.6272 | 2099694.7862 | 37.744489317421205 | -122.494886420663 | (37.7444893174212, -122.494886420663) | |||
59488 | 59488 | 185330 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601 Sunset Blvd | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984984.9543 | 2097045.1889 | 37.737218704899504 | -122.494427224378 | (37.7372187048995, -122.494427224378) | |||
62075 | 62075 | 186467 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601 Sunset Blvd | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 57 | Width 0ft | 5984746.8052 | 2103766.8566 | 37.755660631401604 | -122.495746271784 | (37.7556606314016, -122.495746271784) | |||
176055 | 176055 | 186244 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1701 Sunset Blvd | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984769.2252 | 2103216.605 | 37.754151105704295 | -122.495628153173 | (37.7541511057043, -122.495628153173) | |||
183860 | 183860 | 186109 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901 Sunset Blvd | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 57 | Width 0ft | 5984840.4659 | 2101628.7594 | 37.7497954900583 | -122.495264699643 | (37.7497954900583, -122.495264699643) | |||
51208 | 51208 | 185329 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601 Sunset Blvd | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 53 | Width 0ft | 5984988.7228 | 2097068.6374 | 37.7372833087501 | -122.49441592312701 | (37.7372833087501, -122.494415923127) | |||
51736 | 51736 | 184793 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 0ft | 5984699.9431 | 2105830.5199 | 37.7613241314326 | -122.49606057370801 | (37.7613241314326, -122.496060573708) | |||
52415 | 52415 | 185995 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2001 Sunset Blvd | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 0ft | 5984831.3398 | 2100982.3251 | 37.7480200240369 | -122.495248592075 | (37.7480200240369, -122.495248592075) | |||
64193 | 64193 | 187192 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | Width 0ft | 5984947.0562 | 2099097.6172 | 37.7428519025748 | -122.49470952510299 | (37.7428519025748, -122.494709525103) | |||
133818 | 133818 | 186243 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1701 Sunset Blvd | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 73 | Width 0ft | 5984798.9554 | 2103218.7477 | 37.7541587299008 | -122.495525498398 | (37.7541587299008, -122.495525498398) | |||
166337 | 166337 | 186697 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1401 Sunset Blvd | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 61 | Width 0ft | 5984719.6928 | 2105196.6935 | 37.75958497805411 | -122.495945509363 | (37.7595849780541, -122.495945509363) | |||
167665 | 167665 | 186108 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901 Sunset Blvd | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984809.6117 | 2101640.7232 | 37.749826532853206 | -122.495372275422 | (37.7498265328532, -122.495372275422) | |||
35832 | 35832 | 185569 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201 Sunset Blvd | 53 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | Width 0ft | 5984875.7272 | 2099710.7055 | 37.74453110155571 | -122.495001354066 | (37.7445311015557, -122.495001354066) | |||
73990 | 73990 | 185328 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601 Sunset Blvd | 53 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 0ft | 5984973.8581 | 2097100.251 | 37.737369241278294 | -122.49446964625099 | (37.7373692412783, -122.494469646251) | |||
76306 | 76306 | 187034 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501 Sunset Blvd | 53 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985000.2262 | 2097805.1313 | 37.7393061966828 | -122.494430425941 | (37.7393061966828, -122.494430425941) | |||
131941 | 131941 | 184792 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 53 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 0ft | 5984699.5634 | 2105839.2535 | 37.76134808921321 | -122.496062531256 | (37.7613480892132, -122.496062531256) | |||
152598 | 152598 | 186315 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1800 Sunset Blvd | 53 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 0ft | 5984977.2414 | 2102833.1203 | 37.7531103414955 | -122.49488051957898 | (37.7531103414955, -122.494880519579) | |||
180706 | 180706 | 184052 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1600 Sunset Blvd | 53 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 0ft | 5984937.3498 | 2103855.5949 | 37.7559154391845 | -122.49509386136101 | (37.7559154391845, -122.495093861361) | |||
184027 | 184027 | 185994 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2001 Sunset Blvd | 53 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5984830.686000001 | 2100989.8439 | 37.7480406303286 | -122.49525140725001 | (37.7480406303286, -122.49525140725) | |||
5557 | 5557 | 20407 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 262X Sunset Blvd | 52 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
62215 | 62215 | 186106 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901 Sunset Blvd | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | Width 0ft | 5984850.5407 | 2101643.8716 | 37.749837573879 | -122.49523097537501 | (37.749837573879, -122.495230975375) | |||
62813 | 62813 | 185993 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2001 Sunset Blvd | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 44 | Width 0ft | 5984854.2231 | 2100989.8439 | 37.748042008357295 | -122.495170018078 | (37.7480420083573, -122.495170018078) | |||
135224 | 135224 | 186241 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1701 Sunset Blvd | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984814.757999999 | 2103244.996 | 37.7542317258103 | -122.495472785714 | (37.7542317258103, -122.495472785714) | |||
29764 | 29764 | 185497 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 51 | unknown : Yard 19 | Tree 1 | Private 1 | 33 | Width 0ft | 5985111.7766 | 2098651.8474 | 37.7416375791026 | -122.494107128969 | (37.7416375791026, -122.494107128969) | |||
53586 | 53586 | 185992 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2001 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984890.8365 | 2100993.7667 | 37.7480549227911 | -122.495043701448 | (37.7480549227911, -122.495043701448) | |||
53775 | 53775 | 186105 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 44 | Width 0ft | 5984830.3911 | 2101661.5025 | 37.7498848037651 | -122.49530195262899 | (37.7498848037651, -122.495301952629) | |||
54807 | 54807 | 185025 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 0ft | 5984994.5849 | 2096323.3091 | 37.7352371795053 | -122.494340732091 | (37.7352371795053, -122.494340732091) | |||
69733 | 69733 | 186694 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1401 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 85 | Width 0ft | 5984719.2741 | 2105229.7727 | 37.75967577978221 | -122.495949397724 | (37.7596757797822, -122.495949397724) | |||
161696 | 161696 | 187189 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 0ft | 5984948.5376 | 2099133.5432 | 37.7429506323623 | -122.49470705098899 | (37.7429506323623, -122.494707050989) | |||
167290 | 167290 | 185908 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2000 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5985025.7545 | 2101367.4934 | 37.7490889717309 | -122.49460471461799 | (37.7490889717309, -122.494604714618) | |||
34251 | 34251 | 185991 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2001 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 49 | Width 0ft | 5984838.2048 | 2101005.2084 | 37.748083257257704 | -122.495226540797 | (37.7480832572577, -122.495226540797) | |||
57083 | 57083 | 185434 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 50 | unknown : Yard 19 | Tree 1 | Private 1 | 20 | Width 0ft | 5985080.6415 | 2099410.3284 | 37.7437183411386 | -122.494270675975 | (37.7437183411386, -122.494270675975) | |||
63286 | 63286 | 185197 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2500 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 41 | Width 0ft | 5985143.9825 | 2097895.1746 | 37.739561843599795 | -122.493940022036 | (37.7395618435998, -122.493940022036) | |||
71367 | 71367 | 187188 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 0ft | 5984927.7969 | 2099125.0247 | 37.7429260288422 | -122.49477813764099 | (37.7429260288422, -122.494778137641) | |||
146111 | 146111 | 223697 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1001 San Jose Ave | 50 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 6005304.12461 | 2097202.65687 | 37.738819299062904 | -122.424185667341 | (37.7388192990629, -122.424185667341) | ||||
152560 | 152560 | 186239 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1701 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 64 | Width 0ft | 5984787.4383 | 2103338.7401 | 37.754487521465 | -122.49557417650298 | (37.754487521465, -122.495574176503) | |||
175190 | 175190 | 186383 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 47 | Width 0ft | 5984821.7301 | 2102416.5017 | 37.751957317115895 | -122.49538757696999 | (37.7519573171159, -122.49538757697) | |||
58233 | 58233 | 186382 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 49 | Width 0ft | 5984814.4576 | 2102434.5482 | 37.75200644201529 | -122.495414056772 | (37.7520064420153, -122.495414056772) | |||
134264 | 134264 | 185433 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 49 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985073.6434 | 2099396.3323 | 37.7436795021074 | -122.49429384193199 | (37.7436795021074, -122.494293841932) | |||
136731 | 136731 | 185990 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2001 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | Width 0ft | 5984856.0211 | 2101024.0054 | 37.7481359117689 | -122.495166319529 | (37.7481359117689, -122.495166319529) | |||
137771 | 137771 | 181360 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 49 | unknown : Yard 19 | Tree 1 | Private 1 | 47 | Width 0ft | 5985113.1047 | 2098629.2701 | 37.7415756656355 | -122.494100873291 | (37.7415756656355, -122.494100873291) | |||
154075 | 154075 | 186715 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 0ft | 5984865.9056 | 2106138.7766 | 37.7621802374114 | -122.495509323915 | (37.7621802374114, -122.495509323915) | |||
156419 | 156419 | 187266 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2401 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984927.4181 | 2098377.3028 | 37.740872964274004 | -122.494724332889 | (37.740872964274, -122.494724332889) | |||
157396 | 157396 | 187187 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 45 | Width 0ft | 5984911.1302 | 2099149.4691 | 37.7429921709593 | -122.494837567523 | (37.7429921709593, -122.494837567523) | |||
166336 | 166336 | 185565 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 63 | Width 0ft | 5984901.9941 | 2099754.2184 | 37.7446521138241 | -122.494913737481 | (37.7446521138241, -122.494913737481) | |||
187359 | 187359 | 186164 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1700 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984969.5188 | 2103423.199 | 37.754730082816295 | -122.49495073100701 | (37.7547300828163, -122.494950731007) | |||
38529 | 38529 | 184787 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | Width 0ft | 5984684.7543 | 2105859.3786 | 37.7614024796931 | -122.49611523377199 | (37.7614024796931, -122.496115233772) | |||
48368 | 48368 | 187186 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 55 | Width 0ft | 5984928.1673 | 2099176.8766 | 37.7430684218097 | -122.494780679026 | (37.7430684218097, -122.494780679026) | |||
62551 | 62551 | 223750 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5200x Diamond Heights Blvd | 48 | Median : Yard 3 | Tree 1 | DPW 2 | 49 | 6001781.7092699995 | 2098716.14984 | 37.7427754806136 | -122.436472807673 | (37.7427754806136, -122.436472807673) | ||||
115225 | 115225 | 99164 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 48 | Median : Cutout 11 | Tree 1 | Private 1 | 24 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
116439 | 116439 | 186460 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 51 | Width 0ft | 5984775.2784 | 2103839.2958 | 37.7558611968 | -122.495653146825 | (37.7558611968, -122.495653146825) | |||
150480 | 150480 | 186577 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 48 | unknown : Yard 19 | Tree 1 | Private 1 | 29 | Width 0ft | 5984764.3916 | 2104600.9543 | 37.75795186201471 | -122.495746976697 | (37.7579518620147, -122.495746976697) | |||
181515 | 181515 | 185432 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 48 | unknown : Yard 19 | Tree 1 | Private 1 | 28 | Width 0ft | 5985081.6412 | 2099386.335 | 37.7436525202566 | -122.49426545113899 | (37.7436525202566, -122.494265451139) | |||
25247 | 25247 | 185431 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 47 | unknown : Yard 19 | Tree 1 | Private 1 | 40 | Width 0ft | 5985098.6365 | 2099386.335 | 37.743653514796705 | -122.49420668637899 | (37.7436535147967, -122.494206686379) | |||
38386 | 38386 | 186162 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1700 Sunset Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 0ft | 5984944.9381 | 2103398.2721 | 37.75466020146371 | -122.495033898572 | (37.7546602014637, -122.495033898572) | |||
45810 | 45810 | 185494 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 47 | unknown : Yard 19 | Tree 1 | Private 1 | 25 | Width 0ft | 5985136.346 | 2098616.6534 | 37.74154238350489 | -122.494019584309 | (37.7415423835049, -122.494019584309) | |||
74061 | 74061 | 187362 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2200 Sunset Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985051.5932 | 2099845.3222 | 37.7449110163112 | -122.49440317509199 | (37.7449110163112, -122.494403175092) | |||
168711 | 168711 | 187185 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984955.2043 | 2099180.2099 | 37.7430791567104 | -122.49468743945299 | (37.7430791567104, -122.494687439453) | |||
29091 | 29091 | 186379 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801 Sunset Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 80 | Width 0ft | 5984812.5721 | 2102477.6444 | 37.7521246619181 | -122.495423755128 | (37.7521246619181, -122.495423755128) | |||
34361 | 34361 | 185493 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 46 | unknown : Yard 19 | Tree 1 | Private 1 | 19 | Width 0ft | 5985113.7687 | 2098601.3804 | 37.741499126889295 | -122.49409652237499 | (37.7414991268893, -122.494096522375) | |||
48465 | 48465 | 187027 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501 Sunset Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984986.1024 | 2097857.9274 | 37.739450333989 | -122.494483149973 | (37.739450333989, -122.494483149973) | |||
69295 | 69295 | 186458 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601 Sunset Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 0ft | 5984770.6724 | 2103862.3256 | 37.7559241605194 | -122.495670774259 | (37.7559241605194, -122.495670774259) | |||
135866 | 135866 | 181413 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Sunset Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5984915.677999999 | 2104726.23 | 37.7583046928502 | -122.495233010459 | (37.7583046928502, -122.495233010459) | |||
153477 | 153477 | 185020 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 61 | Width 0ft | 5984996.6786 | 2096354.7134 | 37.7353235298613 | -122.494335807629 | (37.7353235298613, -122.494335807629) | |||
162125 | 162125 | 186100 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901 Sunset Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 49 | Width 0ft | 5984815.9085 | 2101712.5063 | 37.750023998252395 | -122.495355794424 | (37.7500239982524, -122.495355794424) | |||
179607 | 179607 | 185430 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 46 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985106.6343 | 2099374.8382 | 37.7436224157034 | -122.49417818512899 | (37.7436224157034, -122.494178185129) | |||
184827 | 184827 | 176107 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700x Mansell St | 46 | Median : Cutout 11 | Tree 1 | DPW 2 | 61 | Width 0ft | 6008982.60232 | 2089910.3513099998 | 37.7190031946297 | -122.41095224595699 | (37.7190031946297, -122.410952245957) | |||
25921 | 25921 | 181412 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984910.1084 | 2104727.9008 | 37.758308954313996 | -122.495252395507 | (37.758308954314, -122.495252395507) | |||
27316 | 27316 | 187183 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984940.3895 | 2099200.21 | 37.74313320442471 | -122.494740138503 | (37.7431332044247, -122.494740138503) | |||
37023 | 37023 | 206856 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 700 Junipero Serra Blvd | 45 | : 4 | Tree 1 | Private 1 | 26 | Width 0ft | 5991248.852630001 | 2092491.9705700001 | 37.725081312132296 | -122.47243842751101 | (37.7250813121323, -122.472438427511) | |||
55184 | 55184 | 187026 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 76 | Width 0ft | 5984957.5185 | 2097874.0689 | 37.7394929812704 | -122.49458316876199 | (37.7394929812704, -122.494583168762) | |||
170223 | 170223 | 223772 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 310 Liberty St | 45 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 3ft | 6003858.111380001 | 2103926.6096799998 | 37.7571999560244 | -122.429664736557 | (37.7571999560244, -122.429664736557) | |||
172749 | 172749 | 186574 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 45 | unknown : Yard 19 | Tree 1 | Private 1 | 46 | Width 0ft | 5984720.0068 | 2104642.8266 | 37.7580642323025 | -122.495903564638 | (37.7580642323025, -122.495903564638) | |||
72879 | 72879 | 185018 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 0ft | 5985002.5407 | 2096393.6547 | 37.735430795338004 | -122.494318409962 | (37.735430795338, -122.494318409962) | |||
75065 | 75065 | 186159 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1700 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 77 | Width 0ft | 5984932.8209 | 2103361.228 | 37.7545577792255 | -122.495073071066 | (37.7545577792255, -122.495073071066) | |||
98923 | 98923 | 185985 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2001 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 68 | Width 0ft | 5984835.0992 | 2101040.6776 | 37.7481804641628 | -122.495239894977 | (37.7481804641628, -122.495239894977) | |||
149694 | 149694 | 223692 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 701 Church St | 44 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6004344.5987 | 2104707.34802 | 37.7593712135304 | -122.428037909748 | (37.7593712135304, -122.428037909748) | ||||
164855 | 164855 | 184783 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | Width 0ft | 5984690.4501 | 2105882.5415 | 37.761466412150995 | -122.496097243606 | (37.761466412151, -122.496097243606) | |||
129 | 129 | 20398 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 262X Sunset Blvd | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
31264 | 31264 | 185017 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985031.8513 | 2096412.4973 | 37.735484247333396 | -122.494218462115 | (37.7354842473334, -122.494218462115) | |||
37856 | 37856 | 185490 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 43 | unknown : Yard 19 | Tree 1 | Private 1 | 18 | Width 0ft | 5985127.7135 | 2098570.8346 | 37.741416072315204 | -122.49404605602501 | (37.7414160723152, -122.494046056025) | |||
38102 | 38102 | 187181 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 0ft | 5984923.7228 | 2099208.7285 | 37.7431556183483 | -122.49479839457199 | (37.7431556183483, -122.494798394572) | |||
64676 | 64676 | 187260 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2401 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 0ft | 5984965.4053 | 2098435.4576 | 37.7410348651069 | -122.494597275418 | (37.7410348651069, -122.494597275418) | |||
66207 | 66207 | 186686 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1401 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 0ft | 5984721.1583 | 2105332.5693 | 37.7599581409009 | -122.49595046480499 | (37.7599581409009, -122.495950464805) | |||
100797 | 100797 | 185900 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2000 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5985021.1381 | 2101287.9293 | 37.748870240258704 | -122.494614813113 | (37.7488702402587, -122.494614813113) | |||
126959 | 126959 | 12498 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
142696 | 142696 | 185115 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2801 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | Width 0ft | 5985005.2624 | 2095904.376 | 37.7340875257112 | -122.49427294726802 | (37.7340875257112, -122.494272947268) | |||
153445 | 153445 | 223711 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 43 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6004453.96026 | 2096061.62765 | 37.7356382512944 | -122.42704389176201 | (37.7356382512944, -122.427043891762) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");