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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
178034 | 178034 | 132194 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 24 Priest St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | Width 10ft | 6008339.232919999 | 2117055.47626 | 37.7935014331032 | -122.415096515291 | (37.7935014331032, -122.415096515291) | |||
177908 | 177908 | 187084 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2600 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 0ft | 5985178.0339 | 2097042.9902 | 37.737223965797206 | -122.493759507537 | (37.7372239657972, -122.493759507537) | |||
177535 | 177535 | 178290 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 900 Brotherhood Way | 19 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5988714.13201 | 2088715.1658 | 37.7145641230155 | -122.48092418840099 | (37.7145641230155, -122.480924188401) | |||
177528 | 177528 | 211105 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2187x 09th Ave | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 41 | 5993636.389719999 | 2101004.93506 | 37.748593692259895 | -122.464802962985 | (37.7485936922599, -122.464802962985) | ||||
177434 | 177434 | 211173 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800x Junipero Serra Blvd | 54 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 0ft | 5991356.551080001 | 2092861.75062 | 37.7261028691334 | -122.472093069844 | (37.7261028691334, -122.472093069844) | |||
177084 | 177084 | 178301 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 654 Brotherhood Way | 24 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5989693.78349 | 2088724.55965 | 37.7146468129717 | -122.477538839844 | (37.7146468129717, -122.477538839844) | |||
176916 | 176916 | 185437 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 0ft | 5985090.6387 | 2099444.319 | 37.7438122551545 | -122.494238613422 | (37.7438122551545, -122.494238613422) | |||
176861 | 176861 | 178196 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 147 Blythdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | Width 6ft | 6006332.21017 | 2086970.8429400001 | 37.710782950433995 | -122.41990515969 | (37.710782950434, -122.41990515969) | |||
176836 | 176836 | 186992 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2501 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984981.0582 | 2098115.5185 | 37.7401573146496 | -122.494519574531 | (37.7401573146496, -122.494519574531) | |||
176783 | 176783 | 247061 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 626 30th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | 6002557.97851 | 2098322.0779 | 37.7417375307638 | -122.43376053241998 | (37.7417375307638, -122.43376053242) | ||||
176645 | 176645 | 178270 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 35 Tomaso Ct | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 3ft | 6009167.93697 | 2086263.08528 | 37.7089989437285 | -122.41005426658701 | (37.7089989437285, -122.410054266587) | |||
176528 | 176528 | 186025 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1900 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | Width 0ft | 5985000.2752 | 2101937.2072 | 37.7506517585534 | -122.49473481825399 | (37.7506517585534, -122.494734818254) | |||
176444 | 176444 | 178182 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1500 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | Width 6ft | 6007434.89131 | 2087402.51035 | 37.712030280443294 | -122.416124582492 | (37.7120302804433, -122.416124582492) | |||
176206 | 176206 | 211110 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | Width 8ft | 5994195.56932 | 2101082.15648 | 37.7488379463106 | -122.46287494332701 | (37.7488379463106, -122.462874943327) | |||
176148 | 176148 | 181552 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1300 Sunset Blvd | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984844.1088 | 2106036.7549 | 37.7618988380398 | -122.495577184448 | (37.7618988380398, -122.495577184448) | |||
176136 | 176136 | 184015 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1600 Sunset Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 0ft | 5984934.8251 | 2103757.0731 | 37.7556447777824 | -122.49509532781799 | (37.7556447777824, -122.495095327818) | |||
176020 | 176020 | 178272 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 35 Tomaso Ct | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | Width 3ft | 6009218.69223 | 2086367.8804 | 37.709289534449894 | -122.409886240875 | (37.7092895344499, -122.409886240875) | |||
176004 | 176004 | 181572 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200 Sunset Blvd | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 0ft | 5984856.9891 | 2106764.1427 | 37.7638967952022 | -122.495586289783 | (37.7638967952022, -122.495586289783) | |||
175959 | 175959 | 119516 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 741 31st Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 45 | 5986357.0692 | 2110765.11995 | 37.774970084143895 | -122.49069243431101 | (37.7749700841439, -122.490692434311) | ||||
175941 | 175941 | 118463 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 545 Point Lobos Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 5981101.15577 | 2112608.26384 | 37.7797223901441 | -122.509010330711 | (37.7797223901441, -122.509010330711) | ||||
175533 | 175533 | 249825 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 391 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | Width 0ft | 6010996.75714 | 2119996.47458 | 37.801725684664795 | -122.406108520815 | (37.8017256846648, -122.406108520815) | |||
175519 | 175519 | 211235 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 5ft | 5993688.66706 | 2100390.50163 | 37.7469096280744 | -122.46457758119301 | (37.7469096280744, -122.464577581193) | |||
175124 | 175124 | 233302 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 5210 Diamond Heights Blvd | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 3ft | 6001111.77836 | 2099221.88221 | 37.7441260114235 | -122.438825466546 | (37.7441260114235, -122.438825466546) | |||
175113 | 175113 | 211119 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | Width 8ft | 5994174.87266 | 2101366.65398 | 37.749617912142504 | -122.46296714991999 | (37.7496179121425, -122.46296714992) | |||
175105 | 175105 | 178223 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1700 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 10ft | 6006618.16278 | 2087672.71077 | 37.7127262378868 | -122.418966588549 | (37.7127262378868, -122.418966588549) | |||
174895 | 174895 | 211206 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 700 Junipero Serra Blvd | 152 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5991178.15034 | 2091465.1240400001 | 37.7222577538669 | -122.472608003665 | (37.7222577538669, -122.472608003665) | |||
174717 | 174717 | 211151 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 100 Terrace Dr | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | 5993575.924430001 | 2096738.7427299998 | 37.7368763164955 | -122.464702297369 | (37.7368763164955, -122.464702297369) | ||||
174327 | 174327 | 181523 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1300 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 0ft | 5984877.5263 | 2105725.9717 | 37.7610474710834 | -122.495438686338 | (37.7610474710834, -122.495438686338) | |||
174250 | 174250 | 178218 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 49 Brookdale Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 44 | Width 6ft | 6006609.77482 | 2087372.85272 | 37.7119024184269 | -122.41897432542801 | (37.7119024184269, -122.418974325428) | |||
174176 | 174176 | 178309 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | 5989840.96696 | 2090677.1262700001 | 37.720016616367005 | -122.477172722251 | (37.720016616367, -122.477172722251) | ||||
174057 | 174057 | 211196 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 700 Junipero Serra Blvd | 75 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991238.32858 | 2092253.9287900003 | 37.72442709941971 | -122.47245746163601 | (37.7244270994197, -122.472457461636) | |||
173937 | 173937 | 186014 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1900 Sunset Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 0ft | 5985006.5664 | 2101766.8596 | 37.7501843989591 | -122.494700505622 | (37.7501843989591, -122.494700505622) | |||
173908 | 173908 | 211094 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 66 Aerial Way | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 39 | Width 4ft | 5992285.42513 | 2102561.07483 | 37.752788467513206 | -122.46958780504801 | (37.7527884675132, -122.469587805048) | |||
173711 | 173711 | 178339 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 401 Ocean Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5998892.86431 | 2091522.3790099998 | 37.722858504605796 | -122.44594429029199 | (37.7228585046058, -122.445944290292) | ||||
173649 | 173649 | 185168 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2500 Sunset Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 0ft | 5985132.0298 | 2097721.8603 | 37.7390852696928 | -122.493968579127 | (37.7390852696928, -122.493968579127) | |||
173607 | 173607 | 185925 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2000 Sunset Blvd | 68 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 37 | Width 0ft | 5985014.3494 | 2101464.7083 | 37.7493552297288 | -122.49465131902201 | (37.7493552297288, -122.494651319022) | |||
173550 | 173550 | 211257 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100x Casitas Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 3ft | 5995466.651769999 | 2096989.01448 | 37.737672324406 | -122.45818336818 | (37.737672324406, -122.45818336818) | |||
173459 | 173459 | 187089 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2600 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985162.5166 | 2097113.5233 | 37.7374167229836 | -122.4938183534 | (37.7374167229836, -122.4938183534) | |||
173433 | 173433 | 184989 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2701 Sunset Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 0ft | 5984998.3534 | 2096603.0166 | 37.736005402170704 | -122.49434831439699 | (37.7360054021707, -122.494348314397) | |||
173276 | 173276 | 247543 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1101 Waller St | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 80 | 6000225.31856 | 2108498.53576 | 37.7695469597628 | -122.442556551344 | (37.7695469597628, -122.442556551344) | ||||
173273 | 173273 | 249898 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1497 Montgomery St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 0ft | 6011364.51666 | 2120462.68134 | 37.8030263372523 | -122.404868738822 | (37.8030263372523, -122.404868738822) | |||
173256 | 173256 | 178189 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2 Brookdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | Width 6ft | 6006392.34206 | 2087435.2297599998 | 37.7120614464552 | -122.41973025866501 | (37.7120614464552, -122.419730258665) | |||
173233 | 173233 | 211130 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 36 | Median : Yard 3 | Tree 1 | DPW 2 | 48 | Width 8ft | 5994106.02259 | 2101525.20056 | 37.7500492746747 | -122.46321673696 | (37.7500492746747, -122.46321673696) | |||
173224 | 173224 | 201556 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | 6019865.267469999 | 2093672.4938299998 | 37.729937570248 | -122.37359504397101 | (37.729937570248, -122.373595043971) | ||||
173146 | 173146 | 211265 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50 Garcia Ave | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 42 | Width 3ft | 5995078.90453 | 2099284.38743 | 37.743952561863395 | -122.459690195758 | (37.7439525618634, -122.459690195758) | |||
173119 | 173119 | 211243 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 5ft | 5993495.594269999 | 2100380.49402 | 37.746871017502706 | -122.46524447706999 | (37.7468710175027, -122.46524447707) | |||
172986 | 172986 | 178202 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 121 Santos St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 6ft | 6006601.88887 | 2086790.1113 | 37.710301888699796 | -122.418960276213 | (37.7103018886998, -122.418960276213) | |||
172925 | 172925 | 187375 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2200 Sunset Blvd | 61 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 0ft | 5985070.5518 | 2099977.6937 | 37.745275582043 | -122.49434737621799 | (37.745275582043, -122.494347376218) | |||
172904 | 172904 | 234530 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 San Jose Av Off Ramp | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6003016.336130001 | 2095337.77177 | 37.7335693096769 | -122.431962635665 | (37.7335693096769, -122.431962635665) | ||||
172840 | 172840 | 211195 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 700 Junipero Serra Blvd | 69 | : 4 | Tree 1 | Private 1 | 52 | Width 0ft | 5991251.708930001 | 2092296.84954 | 37.7245457235837 | -122.47241433557801 | (37.7245457235837, -122.472414335578) | |||
172768 | 172768 | 178314 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 36 | 5989006.41886 | 2090486.3279799998 | 37.7194442778983 | -122.48004348051501 | (37.7194442778983, -122.480043480515) | ||||
172544 | 172544 | 186824 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200 Sunset Blvd | 101 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 0ft | 5984835.6469 | 2106654.305 | 37.7635939619503 | -122.495652002752 | (37.7635939619503, -122.495652002752) | |||
172377 | 172377 | 249791 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 173 Chestnut St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6010901.74911 | 2121032.7944400003 | 37.8045658498059 | -122.406510361262 | (37.8045658498059, -122.406510361262) | |||
172327 | 172327 | 194517 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 15 Reuel Ct | 1 | : 4 | Tree 1 | Private 1 | 31 | 6017370.3907699995 | 2096095.6605599998 | 37.7364536252419 | -122.382388741749 | (37.7364536252419, -122.382388741749) | ||||
172276 | 172276 | 211159 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800x Portola Dr | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | Width 4ft | 5996511.507119999 | 2099115.91924 | 37.7435722673589 | -122.454724443377 | (37.7435722673589, -122.454724443377) | |||
172192 | 172192 | 194481 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1300x De Haro St | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6012253.2004 | 2102155.0186 | 37.752807341589296 | -122.400506643765 | (37.7528073415893, -122.400506643765) | ||||
172142 | 172142 | 187600 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 748 University St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6008716.51879 | 2090699.9570400002 | 37.721156362249296 | -122.411927764864 | (37.7211563622493, -122.411927764864) | ||||
172078 | 172078 | 247084 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2301 Castro St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6002719.58969 | 2098590.79204 | 37.74248452655279 | -122.43322093111799 | (37.7424845265528, -122.433220931118) | ||||
172015 | 172015 | 211109 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 8ft | 5994204.70393 | 2101056.5968 | 37.7487682920423 | -122.462841502058 | (37.7487682920423, -122.462841502058) | |||
171928 | 171928 | 211170 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 201 Congo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 10ft | 6000065.7506099995 | 2094388.3297700002 | 37.7307946484584 | -122.442095501327 | (37.7307946484584, -122.442095501327) | |||
171904 | 171904 | 211124 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 29 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | Width 8ft | 5994160.0585 | 2101416.01346 | 37.749752587415294 | -122.46302195820101 | (37.7497525874153, -122.463021958201) | |||
171862 | 171862 | 178194 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 162 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 41 | Width 6ft | 6005696.94597 | 2087371.4071400003 | 37.7118470049107 | -122.422129220003 | (37.7118470049107, -122.422129220003) | |||
171851 | 171851 | 247117 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2301 Castro St | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6002710.25835 | 2098630.25767 | 37.7425923606407 | -122.433256015449 | (37.7425923606407, -122.433256015449) | ||||
171802 | 171802 | 211192 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 700 Junipero Serra Blvd | 38 | : 4 | Tree 1 | Private 1 | 44 | Width 0ft | 5991267.47079 | 2092567.84203 | 37.7252907138862 | -122.472379595658 | (37.7252907138862, -122.472379595658) | |||
171779 | 171779 | 211114 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 8ft | 5994176.51166 | 2101165.80889 | 37.7490665369056 | -122.462946912466 | (37.7490665369056, -122.462946912466) | |||
171757 | 171757 | 186309 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1800 Sunset Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984996.975 | 2102766.2677 | 37.7529279377915 | -122.494807349326 | (37.7529279377915, -122.494807349326) | |||
171750 | 171750 | 181485 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1400 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 0ft | 5984881.7035 | 2105355.8723 | 37.760031526051 | -122.49539694358 | (37.760031526051, -122.49539694358) | |||
171734 | 171734 | 185198 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2500 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 0ft | 5985172.5362 | 2097912.4396 | 37.7396109192876 | -122.49384256912901 | (37.7396109192876, -122.493842569129) | |||
171657 | 171657 | 186307 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1800 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984989.7259 | 2102761.8378 | 37.75291535017521 | -122.49483209112302 | (37.7529153501752, -122.494832091123) | |||
171651 | 171651 | 194479 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1300x De Haro St | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6012266.007180001 | 2102082.8221 | 37.7526098199098 | -122.40045728448099 | (37.7526098199098, -122.400457284481) | ||||
171542 | 171542 | 233283 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1000 San Jose Ave | 76 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6005053.15059 | 2097036.60001 | 37.738349170383394 | -122.425041606983 | (37.7383491703834, -122.425041606983) | ||||
171534 | 171534 | 194505 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 299x Cashmere St | 25 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6016625.92106 | 2096014.8365599997 | 37.7361905483545 | -122.384957083216 | (37.7361905483545, -122.384957083216) | ||||
171527 | 171527 | 184033 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1600 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984960.4323 | 2103807.95 | 37.7557859707791 | -122.495010522673 | (37.7557859707791, -122.495010522673) | |||
171209 | 171209 | 181342 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2500 Sunset Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 0ft | 5985138.0061 | 2097698.619 | 37.7390218049938 | -122.493946203747 | (37.7390218049938, -122.493946203747) | |||
170811 | 170811 | 211087 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1840 Funston Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 56 | 5992084.81362 | 2102739.60541 | 37.753267069622105 | -122.47029454986999 | (37.7532670696221, -122.47029454987) | ||||
170782 | 170782 | 181363 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1600 Sunset Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 0ft | 5984948.0631 | 2103735.3775 | 37.7555859826584 | -122.495047947606 | (37.7555859826584, -122.495047947606) | |||
170770 | 170770 | 181344 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2500 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 45 | Width 0ft | 5985120.0771 | 2097886.5421 | 37.7395367423416 | -122.494022039299 | (37.7395367423416, -122.494022039299) | |||
170631 | 170631 | 185657 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2100 Sunset Blvd | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 0ft | 5985055.7286 | 2100552.4719 | 37.7468528992705 | -122.494440993785 | (37.7468528992705, -122.494440993785) | |||
170595 | 170595 | 233325 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 3618 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004228.24087 | 2103086.3399400003 | 37.754913724709 | -122.428324798868 | (37.754913724709, -122.428324798868) | |||
170451 | 170451 | 218352 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 373 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 0ft | 5993483.673280001 | 2100023.2547400002 | 37.745889441656104 | -122.46525975385599 | (37.7458894416561, -122.465259753856) | |||
170434 | 170434 | 185686 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2101 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 47 | Width 0ft | 5984874.4912 | 2100600.5003 | 37.746974163667105 | -122.495071227361 | (37.7469741636671, -122.495071227361) | |||
170195 | 170195 | 178211 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 21 Santos St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | Width 6ft | 6006699.73291 | 2087365.61068 | 37.711887598496396 | -122.41866289109699 | (37.7118875984964, -122.418662891097) | |||
169921 | 169921 | 186028 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1900 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 0ft | 5984994.4679 | 2101990.4409 | 37.750797583777704 | -122.494758824409 | (37.7507975837777, -122.494758824409) | |||
169718 | 169718 | 184987 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2701 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 0ft | 5985012.5901 | 2096619.3468 | 37.7360510736865 | -122.494300296463 | (37.7360510736865, -122.494300296463) | |||
169505 | 169505 | 178249 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 525 Morse St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 5999648.3814 | 2087534.2831 | 37.7119512120476 | -122.443046364399 | (37.7119512120476, -122.443046364399) | |||
169305 | 169305 | 233324 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 25 Stoneman St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 3ft | 6008213.5814 | 2099395.52315 | 37.745004274037 | -122.414281204321 | (37.745004274037, -122.414281204321) | |||
169296 | 169296 | 211238 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 5ft | 5993641.0282 | 2100369.29908 | 37.7468486648357 | -122.464740771274 | (37.7468486648357, -122.464740771274) | |||
169207 | 169207 | 181544 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1300 Sunset Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 55 | Width 0ft | 5984863.0454 | 2105947.6415 | 37.761655266447 | -122.49550511839199 | (37.761655266447, -122.495505118392) | |||
169058 | 169058 | 187370 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2200 Sunset Blvd | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5985063.4423 | 2099909.9845 | 37.7450892548894 | -122.494366969215 | (37.7450892548894, -122.494366969215) | |||
169035 | 169035 | 181551 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1300 Sunset Blvd | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984870.8428 | 2106030.0714 | 37.761882052464706 | -122.495484230494 | (37.7618820524647, -122.495484230494) | |||
168987 | 168987 | 178233 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 47 | Width 10ft | 6007279.31595 | 2087405.7889599998 | 37.7120305340486 | -122.41666252905 | (37.7120305340486, -122.41666252905) | |||
168432 | 168432 | 248087 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 14 Montcalm St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6010655.20977 | 2100360.58155 | 37.747790964577 | -122.40590641976699 | (37.747790964577, -122.405906419767) | ||||
168181 | 168181 | 184975 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2701 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | Width 0ft | 5985012.1713 | 2096778.8806 | 37.736489086361296 | -122.49431350011601 | (37.7364890863613, -122.494313500116) | |||
167684 | 167684 | 178313 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 43 | 5989165.0392 | 2090617.5248599998 | 37.7198137266005 | -122.479504788413 | (37.7198137266005, -122.479504788413) | ||||
167614 | 167614 | 194515 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 301x Cashmere St | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 6016017.1360599995 | 2095897.09694 | 37.7358335669715 | -122.38705371226901 | (37.7358335669715, -122.387053712269) | ||||
167395 | 167395 | 181452 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1400 Sunset Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984896.1844 | 2105108.0255 | 37.7593518557065 | -122.495328583345 | (37.7593518557065, -122.495328583345) | |||
167368 | 167368 | 186130 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1700 Sunset Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 0ft | 5984953.2471 | 2103121.6529 | 37.753901167902605 | -122.494984768777 | (37.7539011679026, -122.494984768777) | |||
167355 | 167355 | 178285 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 900 Brotherhood Way | 14 | : 4 | Tree 1 | Private 1 | 18 | Width 0ft | 5988379.49875 | 2088734.13698 | 37.714596755810106 | -122.48208219144199 | (37.7145967558101, -122.482082191442) | |||
167268 | 167268 | 211083 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1779 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 5ft | 5992782.50738 | 2103319.93898 | 37.7549008284376 | -122.46792401068501 | (37.7549008284376, -122.467924010685) | |||
167193 | 167193 | 185978 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2001 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 0ft | 5984834.9358 | 2101095.1072 | 37.7483299034009 | -122.495244473331 | (37.7483299034009, -122.495244473331) |
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");