Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 140943 | 140943 | 120977 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 794x Gates St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3030 | 3x3 | 6008103.0 | 2095407.0 | 37.7340464539486 | -122.414381414226 | (37.7340464539486, -122.414381414226) | |||
| 115010 | 115010 | 9648 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 420X Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999128.38767 | 2111347.91542 | 37.77730804103229 | -122.446555809153 | (37.7773080410323, -122.446555809153) | |||
| 106826 | 106826 | 107037 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1060 Clayton St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 99 | 5998985.0 | 2106259.0 | 37.7633269800406 | -122.446685590868 | (37.7633269800406, -122.446685590868) | ||||
| 128096 | 128096 | 108044 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2901X SUNSET BLVD OFF RAMP | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 99 | 5985539.0 | 2095817.0 | 37.7338788340947 | -122.492421243764 | (37.7338788340947, -122.492421243764) | ||||
| 144456 | 144456 | 108046 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2901X SUNSET BLVD ON RAMP | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 99 | 5985273.0 | 2095807.0 | 37.733835821368295 | -122.493340136435 | (37.7338358213683, -122.493340136435) | ||||
| 53598 | 53598 | 95407 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2X Cranleigh Dr | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 80 | 5991370.3 | 2095943.7 | 37.734565924896394 | -122.472270103664 | (37.7345659248964, -122.472270103664) | ||||
| 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) | ||||
| 30066 | 30066 | 178334 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 11 Pilgrim Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 79 | 6000689.70014 | 2093938.9080400001 | 37.729596178617705 | -122.439906202537 | (37.7295961786177, -122.439906202537) | ||||
| 126874 | 126874 | 95334 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 466 Gonzalez Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2011 12:00:00 AM | 75 | Permit Number 767212 | 5989603.4 | 2089229.6 | 37.7160282834266 | -122.477888136934 | (37.7160282834266, -122.477888136934) | ||
| 138404 | 138404 | 114251 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 129 FONT BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 75 | 5990853.0 | 2088876.0 | 37.715129831054796 | -122.473543194374 | (37.7151298310548, -122.473543194374) | ||||
| 33589 | 33589 | 178260 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 700x Mansell St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 74 | Width 0ft | 6009513.566769999 | 2090039.51327 | 37.7193876062417 | -122.409126009759 | (37.7193876062417, -122.409126009759) | |||
| 178256 | 178256 | 186462 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1601 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 71 | Width 0ft | 5984739.2681 | 2103826.734 | 37.755824596750706 | -122.495776753709 | (37.7558245967507, -122.495776753709) | |||
| 58024 | 58024 | 185970 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2001 Sunset Blvd | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 68 | Width 0ft | 5984877.0596 | 2101205.8095 | 37.748636327835 | -122.495106974471 | (37.748636327835, -122.495106974471) | |||
| 126430 | 126430 | 114212 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 302 SERRANO DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 64 | 5988825.0 | 2090618.0 | 37.7197952736455 | -122.480680205506 | (37.7197952736455, -122.480680205506) | ||||
| 42147 | 42147 | 186117 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1700 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 62 | Width 0ft | 5984960.6905 | 2103014.1557 | 37.753606445966 | -122.494951102458 | (37.753606445966, -122.494951102458) | |||
| 140296 | 140296 | 113659 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 855x CLIPPER ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 62 | 3x3 | 5999765.0 | 2100345.0 | 37.7471331091489 | -122.443562976791 | (37.7471331091489, -122.443562976791) | |||
| 153696 | 153696 | 181520 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1400 Sunset Blvd | 80 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 62 | Width 0ft | 5984870.8428 | 2105613.4659 | 37.7607381702444 | -122.49545350347601 | (37.7607381702444, -122.495453503476) | |||
| 129985 | 129985 | 187042 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2501 Sunset Blvd | 61 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 61 | Width 0ft | 5984985.4298 | 2097743.9282 | 37.7391372834544 | -122.494477074058 | (37.7391372834544, -122.494477074058) | |||
| 20371 | 20371 | 9649 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 420X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5999128.38767 | 2111347.91542 | 37.77730804103229 | -122.446555809153 | (37.7773080410323, -122.446555809153) | |||
| 53910 | 53910 | 186717 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1300 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 60 | Width 0ft | 5984851.2442 | 2106154.1898 | 37.7622216992221 | -122.49556116823601 | (37.7622216992221, -122.495561168236) | |||
| 90152 | 90152 | 107496 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 846x JUNIPERO SERRA BLVD | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 60 | 5991242.0 | 2091754.0 | 37.7230546314384 | -122.47240834171801 | (37.7230546314384, -122.472408341718) | ||||
| 110042 | 110042 | 20966 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2002X Sunset Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | ||||
| 118868 | 118868 | 104135 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 254 WINDING WAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 6x9 | 6001720.0 | 2086577.0 | 37.7094406229145 | -122.435817826478 | (37.7094406229145, -122.435817826478) | |||
| 129039 | 129039 | 114213 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 230 SERRANO DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 60 | 5988981.0 | 2090766.0 | 37.720210710128896 | -122.48015180069099 | (37.7202107101289, -122.480151800691) | ||||
| 28218 | 28218 | 185207 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2500 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 59 | Width 0ft | 5985138.0061 | 2098023.9982 | 37.7399152089238 | -122.493970177095 | (37.7399152089238, -122.493970177095) | |||
| 159089 | 159089 | 178238 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Hahn St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 59 | Width 10ft | 6007397.50689 | 2087251.0490299999 | 37.7116122971515 | -122.416243073555 | (37.7116122971515, -122.416243073555) | |||
| 159960 | 159960 | 178246 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 334 Schwerin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 59 | Width 8ft | 6008498.73338 | 2086169.5102900001 | 37.7087044750874 | -122.412360530312 | (37.7087044750874, -122.412360530312) | |||
| 50946 | 50946 | 211088 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1888 Funston Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 56 | 5992224.9428199995 | 2102558.27283 | 37.7527772781709 | -122.46979675801201 | (37.7527772781709, -122.469796758012) | ||||
| 64705 | 64705 | 194501 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1121 Jamestown Ave | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 56 | 6013422.70006 | 2090021.7257 | 37.7195569863524 | -122.395612244507 | (37.7195569863524, -122.395612244507) | ||||
| 89670 | 89670 | 114428 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 34x HIGUERA AVE | 2 | Median : Yard 3 | Tree 1 | Private 1 | 56 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||||
| 97649 | 97649 | 114386 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 429x ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 56 | 5988163.0 | 2090444.0 | 37.7192790152529 | -122.482955732568 | (37.7192790152529, -122.482955732568) | ||||
| 99051 | 99051 | 181587 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200 Sunset Blvd | 84 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 56 | Width 0ft | 5984853.6973 | 2106515.0588 | 37.76321268798 | -122.49557930195299 | (37.76321268798, -122.495579301953) | |||
| 116683 | 116683 | 114385 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 438x SERRANO DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 56 | 5988379.0 | 2090615.0 | 37.7197611043299 | -122.48222163222201 | (37.7197611043299, -122.482221632222) | ||||
| 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) | ||||
| 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) | |||
| 30723 | 30723 | 186703 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1401 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 54 | Width 0ft | 5984732.2545 | 2105118.3921 | 37.759370719968 | -122.495896289119 | (37.759370719968, -122.495896289119) | |||
| 38561 | 38561 | 181583 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200 Sunset Blvd | 109 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 54 | Width 0ft | 5984816.8597 | 2106789.1308 | 37.7639630555258 | -122.495726926548 | (37.7639630555258, -122.495726926548) | |||
| 68976 | 68976 | 132202 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 956 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 54 | 6008925.4683300005 | 2118706.00298 | 37.7980663000818 | -122.413184855205 | (37.7980663000818, -122.413184855205) | ||||
| 89796 | 89796 | 111400 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 5 | Median : Yard 3 | Tree 1 | Private 1 | 54 | Permit Number 779360 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) | |||
| 166992 | 166992 | 184791 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1301 Sunset Blvd | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 54 | Width 0ft | 5984706.0186 | 2105846.4681 | 37.7613682765764 | -122.496040738032 | (37.7613682765764, -122.496040738032) | |||
| 25318 | 25318 | 178237 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunnydale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 53 | Width 10ft | 6007383.79648 | 2087366.7973099998 | 37.7119293468405 | -122.416298653474 | (37.7119293468405, -122.416298653474) | |||
| 51304 | 51304 | 178234 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 53 | Width 10ft | 6007305.28319 | 2087396.3617599998 | 37.712006109362996 | -122.41657211120899 | (37.712006109363, -122.416572111209) | |||
| 109648 | 109648 | 111396 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 1 | Median : Yard 3 | Tree 1 | Private 1 | 53 | Permit Number 779360 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) | |||
| 55031 | 55031 | 233309 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200x Diamond Heights Blvd | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 52 | 6001152.90645 | 2099246.96263 | 37.744197216131 | -122.438685051778 | (37.744197216131, -122.438685051778) | ||||
| 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) | |||
| 182806 | 182806 | 178197 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 121 Blythdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 52 | Width 6ft | 6006521.5193300005 | 2086937.9712099999 | 37.7107033550432 | -122.419248532308 | (37.7107033550432, -122.419248532308) | |||
| 187681 | 187681 | 178232 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1617 Sunnydale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 52 | Width 10ft | 6007195.0497 | 2087434.8361799999 | 37.712105551909 | -122.41695583486 | (37.712105551909, -122.41695583486) | |||
| 31371 | 31371 | 187276 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2401 Sunset Blvd | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 51 | Width 0ft | 5984967.9188 | 2098306.3128 | 37.7406804154025 | -122.49457906646299 | (37.7406804154025, -122.494579066463) | |||
| 37678 | 37678 | 211285 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 446 Circular Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 51 | 5999677.3469 | 2093670.53528 | 37.728801609603295 | -122.44338673172301 | (37.7288016096033, -122.443386731723) | ||||
| 41063 | 41063 | 186319 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1800 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 51 | Width 0ft | 5984980.8659 | 2102864.5329 | 37.7531968040129 | -122.494870301435 | (37.7531968040129, -122.494870301435) | |||
| 68421 | 68421 | 178235 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunnydale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 51 | Width 10ft | 6007325.54279 | 2087388.64 | 37.711986046404796 | -122.416501541435 | (37.7119860464048, -122.416501541435) | |||
| 71551 | 71551 | 186584 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 51 | Width 0ft | 5984772.2426 | 2104560.8615 | 37.75784223811 | -122.495716867723 | (37.75784223811, -122.495716867723) | |||
| 161965 | 161965 | 178236 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunnydale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 51 | Width 10ft | 6007352.75953 | 2087377.91644 | 37.7119581323275 | -122.416406713298 | (37.7119581323275, -122.416406713298) | |||
| 166770 | 166770 | 106909 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 254 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 51 | 6x6 | 6001705.95388 | 2086562.81591 | 37.709400878615796 | -122.435865357921 | (37.7094008786158, -122.435865357921) | |||
| 180324 | 180324 | 184024 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1600 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 51 | Width 0ft | 5984939.2873 | 2103786.5467 | 37.75572596536521 | -122.495082069611 | (37.7557259653652, -122.495082069611) | |||
| 36932 | 36932 | 211104 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2187x 09th Ave | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 50 | 5993600.40313 | 2100945.49901 | 37.7484284211296 | -122.464923087237 | (37.7484284211296, -122.464923087237) | ||||
| 76136 | 76136 | 111405 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 10 | Median : Yard 3 | Tree 1 | Private 1 | 50 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) | ||||
| 79133 | 79133 | 105258 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 132 GONZALEZ DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 50 | 5990327.0 | 2090136.0 | 37.7185590045312 | -122.47545320091999 | (37.7185590045312, -122.47545320092) | ||||
| 98788 | 98788 | 111423 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200x SAN MARCOS AVE | 8 | Median : Yard 3 | Tree 1 | Private 1 | 50 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
| 110442 | 110442 | 9647 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 420X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 5999128.38767 | 2111347.91542 | 37.77730804103229 | -122.446555809153 | (37.7773080410323, -122.446555809153) | |||
| 113606 | 113606 | 111093 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 100x FONT BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2015 12:00:00 AM | 50 | 3x3 | Permit Number 775594 | 5990916.0 | 2088996.0 | 37.715462969911 | -122.473334188491 | (37.715462969911, -122.473334188491) | |
| 127431 | 127431 | 2296 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 14M | 5990276.209646201 | 2088591.5343604 | 37.7143153385926 | -122.47551605113199 | (37.7143153385926, -122.475516051132) | |||
| 133535 | 133535 | 211084 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1779 11th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 50 | Width 5ft | 5992780.3551 | 2103260.1992200003 | 37.754736674267505 | -122.467927108843 | (37.7547366742675, -122.467927108843) | |||
| 145548 | 145548 | 20677 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1501X Sunset Blvd | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 5984817.9532367 | 2104951.7766639 | 37.7589182591611 | -122.49558761620101 | (37.7589182591611, -122.495587616201) | ||||
| 182200 | 182200 | 186282 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1800 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 50 | Width 0ft | 5984990.9341 | 2102534.7003 | 37.752291763805104 | -122.494811167736 | (37.7522917638051, -122.494811167736) | |||
| 54571 | 54571 | 211276 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 232 Edna St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 49 | 5998791.497719999 | 2095472.56851 | 37.7336990117025 | -122.446578756609 | (37.7336990117025, -122.446578756609) | ||||
| 57532 | 57532 | 186009 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1900 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 49 | Width 0ft | 5985014.7934 | 2101653.1332 | 37.749872618941495 | -122.49466367324499 | (37.7498726189415, -122.494663673245) | |||
| 72947 | 72947 | 186547 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 18 | unknown : Yard 19 | Tree 1 | Private 1 | 49 | Width 0ft | 5984724.5081 | 2104844.7562 | 37.7586189383832 | -122.495902893491 | (37.7586189383832, -122.495902893491) | |||
| 6407 | 6407 | 20308 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
| 11124 | 11124 | 20380 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 262X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
| 11765 | 11765 | 20396 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 262X Sunset Blvd | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
| 13746 | 13746 | 20338 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | ||||||||
| 13748 | 13748 | 20343 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | ||||||||
| 14683 | 14683 | 20337 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | ||||||||
| 15202 | 15202 | 20339 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | ||||||||
| 16056 | 16056 | 20402 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 262X Sunset Blvd | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
| 16063 | 16063 | 20307 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
| 22163 | 22163 | 4978 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200X Diamond Heights Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 12 | 6001055.51411 | 2099325.5229599997 | 37.7444073831894 | -122.439027441656 | (37.7444073831894, -122.439027441656) | |||
| 24665 | 24665 | 20951 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1992X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5984875.945426799 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | |||
| 43629 | 43629 | 211101 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2187x 09th Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 48 | 5993549.05492 | 2100852.54328 | 37.7481702275711 | -122.465093896362 | (37.7481702275711, -122.465093896362) | ||||
| 56493 | 56493 | 211115 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 48 | Width 8ft | 5994174.89833 | 2101193.52417 | 37.749142543105 | -122.46295450185801 | (37.749142543105, -122.462954501858) | |||
| 66635 | 66635 | 21451 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2701X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | 5985119.006821499 | 2096832.7848434 | 37.73664334454379 | -122.49394810120701 | (37.7366433445438, -122.493948101207) | |||
| 77103 | 77103 | 178215 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 250 Blythdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 48 | Width 6ft | 6005849.57581 | 2087139.50656 | 37.7112188626237 | -122.42158522818701 | (37.7112188626237, -122.421585228187) | |||
| 78201 | 78201 | 20481 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 79229 | 79229 | 21225 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2392X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
| 80012 | 80012 | 21274 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2492X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5984994.4282385 | 2098239.2478178 | 37.740497824548 | -122.494482465671 | (37.740497824548, -122.494482465671) | |||
| 80024 | 80024 | 21417 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2692X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
| 81113 | 81113 | 21272 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2492X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5984994.4282385 | 2098239.2478178 | 37.740497824548 | -122.494482465671 | (37.740497824548, -122.494482465671) | |||
| 82085 | 82085 | 21354 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2592X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | |||
| 82693 | 82693 | 20498 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 82811 | 82811 | 114380 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 437X SERRANO DR | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 48 | 5988907.0 | 2090368.0 | 37.7191136019865 | -122.48037847439699 | (37.7191136019865, -122.480378474397) | |||||
| 83887 | 83887 | 21488 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2792X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985060.3629888 | 2096294.4798015 | 37.735161871163605 | -122.49411119238 | (37.7351618711636, -122.49411119238) | |||
| 84187 | 84187 | 21423 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2692X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
| 84388 | 84388 | 20971 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2002X Sunset Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | ||||
| 85037 | 85037 | 21216 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2392X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
| 89044 | 89044 | 99160 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 302X Pacheco St | 44 | Median : Cutout 11 | Tree 1 | Private 1 | 48 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 92102 | 92102 | 21365 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2592X Sunset Blvd | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | |||
| 92790 | 92790 | 21497 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2792X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985060.3629888 | 2096294.4798015 | 37.735161871163605 | -122.49411119238 | (37.7351618711636, -122.49411119238) | |||
| 93006 | 93006 | 6387 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 40 Entrada Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60M | 5992282.41809 | 2092443.27672 | 37.725007378570105 | -122.468861992007 | (37.7250073785701, -122.468861992007) | |||
| 95691 | 95691 | 111404 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 9 | Median : Yard 3 | Tree 1 | Private 1 | 48 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) |
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");