Data source: data.sfgov.org
This data as json, CSV (advanced)
PermitNotes ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9172 | 9172 | 173599 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 100X Warren Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 5995367.0 | 2102770.0 | 37.7535397418859 | -122.458946354326 | (37.7535397418859, -122.458946354326) | |||
| 9640 | 9640 | 114128 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9648 | 9648 | 114133 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9649 | 9649 | 114125 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9650 | 9650 | 114131 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9662 | 9662 | 114130 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9664 | 9664 | 114135 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9666 | 9666 | 114127 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9669 | 9669 | 114126 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9671 | 9671 | 114132 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9673 | 9673 | 114129 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9678 | 9678 | 114134 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9683 | 9683 | 173631 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 99X Everglade Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5986361.0 | 2095495.0 | 37.733042731061104 | -122.48955570953301 | (37.7330427310611, -122.489555709533) | ||||
| 9720 | 9720 | 173652 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 65 ZIRCON PL | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6002398.2 | 2098694.7 | 37.7427515964219 | -122.43433962698201 | (37.7427515964219, -122.434339626982) | |||||
| 10134 | 10134 | 173877 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2651 San Jose Ave | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 3x3 | 5997397.0 | 2088796.0 | 37.7152869722449 | -122.450918658158 | (37.7152869722449, -122.450918658158) | ||||
| 10255 | 10255 | 112606 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 100X Monument Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10x10 | 5999003.0 | 2105766.0 | 37.761974353511896 | -122.446587863076 | (37.7619743535119, -122.446587863076) | ||||
| 10256 | 10256 | 173933 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 190 Beacon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003193.0 | 2097540.0 | 37.739626138558705 | -122.43150902083299 | (37.7396261385587, -122.431509020833) | |||||
| 13268 | 13268 | 187627 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 88 States St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001213.0 | 2106258.0 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | |||||
| 13271 | 13271 | 187638 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
| 13275 | 13275 | 187637 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
| 13307 | 13307 | 187654 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 375 Woodside Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | 5997267.0 | 2099886.0 | 37.7457300260474 | -122.452167701039 | (37.7457300260474, -122.452167701039) | ||||
| 13314 | 13314 | 187669 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 554 Valley St | 1 | Median : Yard 3 | Tree 1 | Private 1 | 6002324.0 | 2099197.0 | 37.7441265828549 | -122.434632098307 | (37.7441265828549, -122.434632098307) | |||||
| 16807 | 16807 | 106757 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 999 Key Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/02/2014 12:00:00 AM | 36 | 6013321.202330001 | 2089752.82506 | 37.718812992515105 | -122.395944254446 | (37.7188129925151, -122.395944254446) | |||
| 18889 | 18889 | 106642 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4540X 17TH ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5999139.0 | 2105833.0 | 37.762166086231204 | -122.446122313424 | (37.7621660862312, -122.446122313424) | ||||
| 19685 | 19685 | 92559 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 222 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52905 | 5996693.0 | 2111182.0 | 37.776713072168704 | -122.454968563419 | (37.7767130721687, -122.454968563419) | |||
| 22920 | 22920 | 251148 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
| 22923 | 22923 | 251152 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
| 22924 | 22924 | 251154 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
| 22925 | 22925 | 251150 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
| 22926 | 22926 | 251147 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 113x Gladeview Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997915.0 | 2102038.0 | 37.7516759885035 | -122.450082102397 | (37.7516759885035, -122.450082102397) | ||||
| 22927 | 22927 | 251157 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
| 22928 | 22928 | 251155 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
| 22929 | 22929 | 251156 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
| 22930 | 22930 | 251151 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
| 22931 | 22931 | 251158 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
| 22932 | 22932 | 251153 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
| 22933 | 22933 | 251149 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
| 22934 | 22934 | 251159 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 625 Brotherhood Way | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991521.0 | 2087959.0 | 37.7126506341802 | -122.471167551627 | (37.7126506341802, -122.471167551627) | ||||
| 23418 | 23418 | 186415 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984728.3813 | 2104210.7037 | 37.756878233428004 | -122.49584272637699 | (37.756878233428, -122.495842726377) | |||
| 23514 | 23514 | 190971 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 42 | 6011272.24417 | 2104307.20268 | 37.7586620081736 | -122.40405043579099 | (37.7586620081736, -122.404050435791) | ||||
| 23551 | 23551 | 181443 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | Width 0ft | 5984892.2857 | 2105061.2409 | 37.759223169955796 | -122.495338616437 | (37.7592231699558, -122.495338616437) | |||
| 23770 | 23770 | 186402 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801 Sunset Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984820.6527 | 2102319.266 | 37.7516902715465 | -122.495384132242 | (37.7516902715465, -122.495384132242) | |||
| 23880 | 23880 | 187141 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 52 | Width 0ft | 5984898.7676 | 2099479.6664 | 37.7438980796356 | -122.494904654416 | (37.7438980796356, -122.494904654416) | |||
| 24024 | 24024 | 206902 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 901 Monterey Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5996057.83075 | 2094626.65779 | 37.7312198182223 | -122.45596865725 | (37.7312198182223, -122.45596865725) | |||
| 24028 | 24028 | 186361 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984795.4735 | 2102590.7965 | 37.752434345234 | -122.495491228463 | (37.752434345234, -122.495491228463) | |||
| 24119 | 24119 | 184645 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3430 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 37 | Width 0ft | 5983573.582 | 2103608.0944 | 37.7551559377943 | -122.49979184963699 | (37.7551559377943, -122.499791849637) | |||
| 24155 | 24155 | 249927 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 12 | Back Yard : Yard 13 | Tree 1 | Private 1 | 31 | Width 0ft | 6011132.35015 | 2120388.99651 | 37.8028110368738 | -122.40566696715099 | (37.8028110368738, -122.405666967151) | |||
| 24212 | 24212 | 181351 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 32 | Width 0ft | 5985090.6387 | 2098949.4558 | 37.7424534945744 | -122.49420214621 | (37.7424534945744, -122.49420214621) | |||
| 24265 | 24265 | 184994 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 52 | Width 0ft | 5984981.6045 | 2096535.6021 | 37.735819319769895 | -122.494401253367 | (37.7358193197699, -122.494401253367) | |||
| 24279 | 24279 | 138266 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2600 GEARY BLVD | 34 | unknown : Yard 19 | Tree 1 | Private 1 | 19 | Width 0ft | 5999024.6838 | 2113178.2607 | 37.7823277718518 | -122.44704630425699 | (37.7823277718518, -122.447046304257) | |||
| 24438 | 24438 | 118836 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 600 46th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 3ft | 5981651.25866 | 2111619.12831 | 37.77703893001029 | -122.50703392298401 | (37.7770389300103, -122.507033922984) | |||
| 24469 | 24469 | 186067 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 51 | Width 0ft | 5984814.1882 | 2102091.1256 | 37.751063482205 | -122.495389663196 | (37.751063482205, -122.495389663196) | |||
| 24493 | 24493 | 190983 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6016115.94828 | 2100251.3725900003 | 37.7477949890666 | -122.387015672733 | (37.7477949890666, -122.387015672733) | ||||
| 24565 | 24565 | 176109 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 520 Carter St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6005252.95246 | 2086362.20208 | 37.7090508894465 | -122.42359208063299 | (37.7090508894465, -122.423592080633) | ||||
| 24654 | 24654 | 190986 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6016149.69105 | 2100259.24355 | 37.747818469462 | -122.38689953970601 | (37.747818469462, -122.386899539706) | ||||
| 24694 | 24694 | 206882 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 355 Parnassus Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 5ft | 5996132.622880001 | 2106470.43448 | 37.7637441750665 | -122.456566260324 | (37.7637441750665, -122.456566260324) | |||
| 24834 | 24834 | 185543 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201 Sunset Blvd | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 46 | Width 0ft | 5984873.6046 | 2099981.069 | 37.7452733220295 | -122.49502862542 | (37.7452733220295, -122.49502862542) | |||
| 25090 | 25090 | 223699 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 72 | 6004901.063490001 | 2096745.81285 | 37.737542142145706 | -122.425546760699 | (37.7375421421457, -122.425546760699) | ||||
| 25143 | 25143 | 126422 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 71 MacOndray Ln | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | 6008381.99212 | 2119124.63634 | 37.7991852374601 | -122.415095094385 | (37.7991852374601, -122.415095094385) | ||||
| 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) | |||
| 25480 | 25480 | 181380 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 0ft | 5984920.3702 | 2104474.5517 | 37.757613928882606 | -122.49519822357901 | (37.7576139288826, -122.495198223579) | |||
| 25632 | 25632 | 185934 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2000 Sunset Blvd | 77 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 0ft | 5984996.9702 | 2101528.251 | 37.74952868337 | -122.494716099913 | (37.74952868337, -122.494716099913) | |||
| 25637 | 25637 | 190976 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6011280.21235 | 2104227.17617 | 37.758442718371704 | -122.404017246303 | (37.7584427183717, -122.404017246303) | ||||
| 25672 | 25672 | 247989 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 130 Mullen Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 10ft | 6009899.29934 | 2099821.3308900003 | 37.7462679959733 | -122.40848229933901 | (37.7462679959733, -122.408482299339) | |||
| 25740 | 25740 | 187008 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501 Sunset Blvd | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984967.4388 | 2098043.05 | 37.739957538540295 | -122.49456132318899 | (37.7399575385403, -122.494561323189) | |||
| 25920 | 25920 | 205918 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 506 Congo St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | Width 5ft | 6000129.127169999 | 2095289.54923 | 37.7332727986918 | -122.441941059826 | (37.7332727986918, -122.441941059826) | |||
| 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) | |||
| 26008 | 26008 | 186451 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601 Sunset Blvd | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 41 | Width 0ft | 5984745.9677 | 2103899.5919999997 | 37.7560250369708 | -122.495758958747 | (37.7560250369708, -122.495758958747) | |||
| 26075 | 26075 | 206897 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Pizarro Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5995088.9482 | 2093956.7124599998 | 37.729324653504 | -122.459269738418 | (37.729324653504, -122.459269738418) | |||
| 26145 | 26145 | 185549 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 70 | Width 0ft | 5984904.1167 | 2099896.1658 | 37.745041987094396 | -122.49491686223999 | (37.7450419870944, -122.49491686224) | |||
| 26174 | 26174 | 206899 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 901 Monterey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5996026.341440001 | 2094620.2534900003 | 37.731200426151794 | -122.456077057924 | (37.7312004261518, -122.456077057924) | |||
| 26275 | 26275 | 223757 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 5745 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 6000755.6342 | 2096957.8752099997 | 37.7378893137452 | -122.439894635432 | (37.7378893137452, -122.439894635432) | |||
| 26631 | 26631 | 185883 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2000 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985034.4251 | 2101120.3406 | 37.7484108651264 | -122.494556514447 | (37.7484108651264, -122.494556514447) | |||
| 26683 | 26683 | 206855 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 400 Junipero Serra Blvd | 23 | : 4 | Tree 1 | Private 1 | 48 | Width 0ft | 5991362.72494 | 2093965.51745 | 37.7291338947086 | -122.472152147225 | (37.7291338947086, -122.472152147225) | |||
| 26684 | 26684 | 185578 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 80 | Width 0ft | 5984888.727999999 | 2099615.9854 | 37.744271786934796 | -122.49494941784201 | (37.7442717869348, -122.494949417842) | |||
| 26770 | 26770 | 186065 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 0ft | 5984846.241 | 2102114.0204 | 37.751128221750704 | -122.49528051122299 | (37.7511282217507, -122.495280511223) | |||
| 26807 | 26807 | 223746 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 591 27th St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6002725.9014 | 2100031.26808 | 37.7464400956267 | -122.43330201489599 | (37.7464400956267, -122.433302014896) | |||
| 26964 | 26964 | 186346 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 47 | Width 0ft | 5984814.4902 | 2102762.482 | 37.752906859827704 | -122.49543812761401 | (37.7529068598277, -122.495438127614) | |||
| 27038 | 27038 | 119401 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3150 Cabrillo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5985750.26334 | 2110481.7384 | 37.774156534172505 | -122.492770599571 | (37.7741565341725, -122.492770599571) | |||
| 27053 | 27053 | 187052 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501 Sunset Blvd | 71 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | Width 0ft | 5984975.6777 | 2097633.6281 | 37.7388338582522 | -122.494502663013 | (37.7388338582522, -122.494502663013) | |||
| 27191 | 27191 | 186631 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 7 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980860.0426 | 2105683.7293 | 37.7606954284135 | -122.50933003298901 | (37.7606954284135, -122.509330032989) | |||
| 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) | |||
| 27465 | 27465 | 118640 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 495 45th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 5981891.5492 | 2112442.21245 | 37.7793130253265 | -122.50626374607401 | (37.7793130253265, -122.506263746074) | |||
| 27513 | 27513 | 186961 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2800 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | Width 0ft | 5985200.1141 | 2096126.2386 | 37.7347081021486 | -122.493615636331 | (37.7347081021486, -122.493615636331) | |||
| 27837 | 27837 | 187145 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | Width 0ft | 5984892.4139 | 2099447.2487 | 37.743808697483395 | -122.49492423393801 | (37.7438086974834, -122.494924233938) | |||
| 27914 | 27914 | 186438 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | Width 0ft | 5984733.406 | 2103998.8295 | 37.756296779959996 | -122.495809720693 | (37.75629677996, -122.495809720693) | |||
| 28068 | 28068 | 126421 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 957 Green St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | 6008400.762999999 | 2118955.03362 | 37.7987206054154 | -122.415018129477 | (37.7987206054154, -122.415018129477) | ||||
| 28097 | 28097 | 184746 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 73 | Width 0ft | 5984670.325 | 2106153.0915 | 37.7622080878104 | -122.49618680876499 | (37.7622080878104, -122.496186808765) | |||
| 28368 | 28368 | 185036 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984991.2351 | 2096277.6682 | 37.7351116657323 | -122.494348950198 | (37.7351116657323, -122.494348950198) | |||
| 28508 | 28508 | 206910 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 901 Valdez Ave | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5996121.33012 | 2094628.67592 | 37.7312290039204 | -122.455749275714 | (37.7312290039204, -122.455749275714) | |||
| 28511 | 28511 | 176155 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900 Brotherhood Way | 9 | : 4 | Tree 1 | Private 1 | 25 | Width 0ft | 5988052.58895 | 2088755.4955 | 37.71463638173179 | -122.48321367528798 | (37.7146363817318, -122.483213675288) | |||
| 28570 | 28570 | 187221 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2401 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 73 | Width 0ft | 5984920.4721 | 2098768.3716 | 37.7419463270938 | -122.494777174832 | (37.7419463270938, -122.494777174832) | |||
| 28666 | 28666 | 223807 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 177 Moffitt St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6002423.3723 | 2097053.0195400002 | 37.7382453517447 | -122.434135255635 | (37.7382453517447, -122.434135255635) | |||
| 28705 | 28705 | 206872 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900 Junipero Serra Blvd | 41 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991149.64989 | 2090725.7488 | 37.7202259623434 | -122.47265264062 | (37.7202259623434, -122.47265264062) | |||
| 28910 | 28910 | 114708 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 500X CONGO ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x10 | 6000185.0 | 2095264.0 | 37.733205830187 | -122.441746059696 | (37.733205830187, -122.441746059696) | ||||
| 29069 | 29069 | 186197 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1701 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 66 | Width 0ft | 5984786.367000001 | 2103519.1304 | 37.7549827606067 | -122.49559118568399 | (37.7549827606067, -122.495591185684) | |||
| 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) | |||
| 29197 | 29197 | 186442 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601 Sunset Blvd | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | Width 0ft | 5984767.7413 | 2103942.7205 | 37.756144730979294 | -122.49568684061 | (37.7561447309793, -122.49568684061) | |||
| 29359 | 29359 | 181512 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 72 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984867.501 | 2105563.3396 | 37.760600341747896 | -122.495461364037 | (37.7606003417479, -122.495461364037) | |||
| 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) |
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");