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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1680 | 1680 | 251668 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 301x Laguna Honda Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5995349.0 | 2100852.0 | 37.7482723626065 | -122.458869747183 | (37.7482723626065, -122.458869747183) | ||||
2761 | 2761 | 253204 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2253 09th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5993186.0 | 2100608.0 | 37.7474778324271 | -122.466331547971 | (37.7474778324271, -122.466331547971) | ||||
2763 | 2763 | 253205 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2253 09th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5993186.0 | 2100608.0 | 37.7474778324271 | -122.466331547971 | (37.7474778324271, -122.466331547971) | ||||
13294 | 13294 | 187652 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 46 Cragmont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992908.0 | 2101735.0 | 37.750556241076204 | -122.467374782979 | (37.7505562410762, -122.467374782979) | ||||
15123 | 15123 | 116637 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2100 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2016 12:00:00 AM | 3 | 3x3 | 6011768.89448 | 2104683.8431599997 | 37.759723915951206 | -122.40235926517799 | (37.7597239159512, -122.402359265178) | ||
15480 | 15480 | 116639 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2100 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2016 12:00:00 AM | 3 | 3x3 | 6011723.51737 | 2104681.2870400003 | 37.7597143642338 | -122.402516023304 | (37.7597143642338, -122.402516023304) | ||
16694 | 16694 | 104424 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 917 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6011907.00978 | 2104135.17777 | 37.7582251112167 | -122.401843021952 | (37.7582251112167, -122.401843021952) | |||
16837 | 16837 | 116638 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2100 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2016 12:00:00 AM | 3 | 3x3 | 6011745.2802099995 | 2104684.37435 | 37.75972405623921 | -122.402440973074 | (37.7597240562392, -122.402440973074) | ||
25099 | 25099 | 224199 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005272.32245 | 2097108.7115200001 | 37.738559550591795 | -122.42428894459299 | (37.7385595505918, -122.424288944593) | ||||
28658 | 28658 | 187032 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984967.607000001 | 2097835.0603 | 37.73938646460329 | -122.494545412715 | (37.7393864646033, -122.494545412715) | |||
29001 | 29001 | 137844 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1957 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003342.7396 | 2115504.846 | 37.7889617474845 | -122.43227396506398 | (37.7889617474845, -122.432273965064) | |||
31769 | 31769 | 224212 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6005187.142969999 | 2097371.8747799997 | 37.739277327390795 | -122.42460216947501 | (37.7392773273908, -122.424602169475) | ||||
32548 | 32548 | 244479 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 124 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005906.1302 | 2110197.2252 | 37.7745333330343 | -122.423027565946 | (37.7745333330343, -122.423027565946) | |||
34116 | 34116 | 224214 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6005180.62218 | 2097351.71746 | 37.73922161167361 | -122.424623281961 | (37.7392216116736, -122.424623281961) | ||||
35856 | 35856 | 142225 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 641 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6004777.6628 | 2110866.818 | 37.7763081284007 | -122.42697885578698 | (37.7763081284007, -122.426978855787) | |||
37917 | 37917 | 199398 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1027 Jamestown Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6013845.577380001 | 2089711.9694400001 | 37.718729970701396 | -122.394128826289 | (37.7187299707014, -122.394128826289) | ||||
39778 | 39778 | 122380 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 557 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005149.0 | 2111246.0 | 37.777370259808 | -122.42572129147301 | (37.777370259808, -122.425721291473) | |||
39821 | 39821 | 224196 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005192.428069999 | 2096936.6445 | 37.73808258165379 | -122.424552945066 | (37.7380825816538, -122.424552945066) | ||||
41295 | 41295 | 187029 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | Width 0ft | 5984947.4301 | 2097843.1311 | 37.7394074439231 | -122.49461576933999 | (37.7394074439231, -122.49461576934) | |||
43878 | 43878 | 187030 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 0ft | 5984957.5185 | 2097843.1311 | 37.7394080343891 | -122.49458088860901 | (37.7394080343891, -122.494580888609) | |||
44361 | 44361 | 247091 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2301 Castro St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6002747.911280001 | 2098608.69961 | 37.7425353031757 | -122.43312428277099 | (37.7425353031757, -122.433124282771) | ||||
47306 | 47306 | 224452 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 57 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6003256.424219999 | 2095477.2065700002 | 37.7339657739995 | -122.43114253132099 | (37.7339657739995, -122.431142531321) | ||||
48344 | 48344 | 191716 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 561 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6011818.5901 | 2105765.65198 | 37.7626970962079 | -122.40226345320801 | (37.7626970962079, -122.402263453208) | |||
50324 | 50324 | 224208 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 66 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 8ft | 6005339.07699 | 2097371.10972 | 37.7392838060945 | -122.424076794516 | (37.7392838060945, -122.424076794516) | |||
53591 | 53591 | 113159 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 555 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005146.0 | 2111243.0 | 37.777361853017 | -122.425731455878 | (37.777361853017, -122.425731455878) | ||||
57509 | 57509 | 224451 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 56 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6003260.74151 | 2095484.4937599998 | 37.73398602761579 | -122.431128125086 | (37.7339860276158, -122.431128125086) | ||||
58693 | 58693 | 218793 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 616 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 10ft | 5998053.08406 | 2095010.8668400003 | 37.7323890825862 | -122.449098408785 | (37.7323890825862, -122.449098408785) | |||
61013 | 61013 | 199410 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 822 Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 4ft | 6015932.24155 | 2096672.73443 | 37.7379586091972 | -122.387401320018 | (37.7379586091972, -122.387401320018) | |||
62541 | 62541 | 224210 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 72 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6005362.146369999 | 2097481.1402 | 37.739587227456205 | -122.42400485326401 | (37.7395872274562, -122.424004853264) | ||||
62903 | 62903 | 224203 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 34 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6003487.067319999 | 2095623.9761599998 | 37.734381837255505 | -122.430355595758 | (37.7343818372555, -122.430355595758) | ||||
63643 | 63643 | 224453 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 58 | Front Yard : Yard 7 | Tree 1 | Private 1 | 35 | 6003249.48151 | 2095473.62453 | 37.733955545103505 | -122.43116627879499 | (37.7339555451035, -122.431166278795) | ||||
67534 | 67534 | 121262 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 505 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005321.0 | 2111256.0 | 37.7774074352434 | -122.42512699851002 | (37.7774074352434, -122.42512699851) | |||
68584 | 68584 | 139748 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1330 Laguna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6004640.4611 | 2113601.4606 | 37.783809022804206 | -122.427648355277 | (37.7838090228042, -122.427648355277) | |||
69429 | 69429 | 224202 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6003508.627309999 | 2095617.8291 | 37.7343661800531 | -122.430280617458 | (37.7343661800531, -122.430280617458) | ||||
71049 | 71049 | 224216 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6005148.6559 | 2097255.3705700003 | 37.73895525948029 | -122.424726954897 | (37.7389552594803, -122.424726954897) | ||||
72098 | 72098 | 187038 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984961.8902 | 2097789.6624 | 37.7392614795793 | -122.494561832752 | (37.7392614795793, -122.494561832752) | |||
72865 | 72865 | 224450 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 55 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6003275.39086 | 2095494.7434599998 | 37.7340150010873 | -122.431078209119 | (37.7340150010873, -122.431078209119) | ||||
78083 | 78083 | 113326 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 237 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004215.8 | 2097159.4 | 37.7386390150291 | -122.427945503988 | (37.7386390150291, -122.427945503988) | ||||
78473 | 78473 | 105080 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 3770 24TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x4 | 6004633.1 | 2101955.7 | 37.7518321521274 | -122.426844164794 | (37.7518321521274, -122.426844164794) | |||
81756 | 81756 | 97781 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 249 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | strip | 5992441.6 | 2097612.4 | 37.7392096976829 | -122.468687674985 | (37.7392096976829, -122.468687674985) | |||
82194 | 82194 | 109085 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 370 09TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 5993248.4 | 2113128.2 | 37.781858605411294 | -122.467025880438 | (37.7818586054113, -122.467025880438) | |||
87121 | 87121 | 109844 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 535 CLAY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 5x5 | 6012019.0 | 2117742.0 | 37.7955925645 | -122.402412455116 | (37.7955925645, -122.402412455116) | |||
87247 | 87247 | 95380 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 20 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.42990427345501 | (37.7697489175502, -122.429904273455) | ||||
88326 | 88326 | 109852 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 3250x 22nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6006518.0 | 2103190.0 | 37.7553276504831 | -122.420413510616 | (37.7553276504831, -122.420413510616) | |||
88594 | 88594 | 112580 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 274X SAN MARCOS AVE | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 3x20 | 5993121.0 | 2100271.0 | 37.7465487656332 | -122.46653182115801 | (37.7465487656332, -122.466531821158) | ||||
89065 | 89065 | 95379 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 20 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.42990427345501 | (37.7697489175502, -122.429904273455) | ||||
91437 | 91437 | 224213 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6005183.176969999 | 2097360.09127 | 37.7392447485499 | -122.42461504414801 | (37.7392447485499, -122.424615044148) | ||||
91579 | 91579 | 109086 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 370 09TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | 3x3 | 5993248.4 | 2113128.2 | 37.781858605411294 | -122.467025880438 | (37.7818586054113, -122.467025880438) | |||
91878 | 91878 | 109496 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 342 HILL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004048.2 | 2103384.6 | 37.755722487303295 | -122.428968694341 | (37.7557224873033, -122.428968694341) | ||||
94515 | 94515 | 107708 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1798X 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986575.46002 | 2103344.33269 | 37.7546074174257 | -122.489391225039 | (37.7546074174257, -122.489391225039) | ||||
95293 | 95293 | 104649 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 200 Wheeler Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6012242.2 | 2087732.7 | 37.7132060446128 | -122.399532207425 | (37.7132060446128, -122.399532207425) | |||||
98498 | 98498 | 109631 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 390 BUCKINGHAM WAY | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9x9 | 5989374.0 | 2093588.0 | 37.7279820381776 | -122.478999652651 | (37.7279820381776, -122.478999652651) | |||||
100492 | 100492 | 107709 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1798X 31st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986575.46002 | 2103344.33269 | 37.7546074174257 | -122.489391225039 | (37.7546074174257, -122.489391225039) | ||||
104967 | 104967 | 108502 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2300 33RD AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 32 | 5986128.8 | 2099536.7 | 37.7441266056665 | -122.49065574130199 | (37.7441266056665, -122.490655741302) | ||||
105735 | 105735 | 105666 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 317X DORADO TER | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 22 | 5994307.4 | 2093021.4 | 37.7267115488018 | -122.461903806308 | (37.7267115488018, -122.461903806308) | ||||
106381 | 106381 | 99751 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 500x Clipper St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 1046 Diamond St | 6001860.7 | 2100931.8 | 37.748863621629894 | -122.436358217698 | (37.7488636216299, -122.436358217698) | ||
107000 | 107000 | 113327 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 237 Fairmount St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775932 | 6004215.8 | 2097159.4 | 37.7386390150291 | -122.427945503988 | (37.7386390150291, -122.427945503988) | |||
107250 | 107250 | 109849 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 3250x 22ND ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6006518.0 | 2103190.0 | 37.7553276504831 | -122.420413510616 | (37.7553276504831, -122.420413510616) | |||
107433 | 107433 | 95381 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 20 Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.42990427345501 | (37.7697489175502, -122.429904273455) | ||||
107885 | 107885 | 95378 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 20 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.42990427345501 | (37.7697489175502, -122.429904273455) | ||||
107935 | 107935 | 111865 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2X CHRISTOPHER DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996768.0 | 2104018.0 | 37.75704687059729 | -122.45419155308399 | (37.7570468705973, -122.454191553084) | ||||
108418 | 108418 | 110145 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 64 WOODLAND AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3x15 | 5997139.6 | 2106104.1 | 37.76279607600021 | -122.45305700914801 | (37.7627960760002, -122.453057009148) | |||
111120 | 111120 | 97392 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 907 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2011 12:00:00 AM | 23 | 4x4 | Permit Number 768003 | 6001936.0 | 2101462.0 | 37.7503237031932 | -122.436135767062 | (37.7503237031932, -122.436135767062) | |
116832 | 116832 | 104991 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 669X NOE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6003139.0 | 2104447.0 | 37.7585880783392 | -122.432188863302 | (37.7585880783392, -122.432188863302) | |||
117160 | 117160 | 97394 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 907 Diamond St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2011 12:00:00 AM | 23 | 4x4 | Permit Number 768003 | 6001936.0 | 2101462.0 | 37.7503237031932 | -122.436135767062 | (37.7503237031932, -122.436135767062) | |
118120 | 118120 | 114914 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 200x MIDDLE POINT RD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | Private 3 | 3x3 | 6017974.0 | 2095171.0 | 37.7339480130439 | -122.380237547959 | (37.7339480130439, -122.380237547959) | |||
119012 | 119012 | 117457 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 90 NAVY RD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6018168.0 | 2093528.0 | 37.729447357984796 | -122.37945272934601 | (37.7294473579848, -122.379452729346) | ||||
119297 | 119297 | 104993 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 669X NOE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6003139.0 | 2104447.0 | 37.7585880783392 | -122.432188863302 | (37.7585880783392, -122.432188863302) | |||
119815 | 119815 | 109495 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 342 HILL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004048.2 | 2103384.6 | 37.755722487303295 | -122.428968694341 | (37.7557224873033, -122.428968694341) | ||||
120294 | 120294 | 113893 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 5x STORRIE ST | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 60 | 6000722.0 | 2105303.0 | 37.76080110933629 | -122.440609317727 | (37.7608011093363, -122.440609317727) | ||||
120953 | 120953 | 107712 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1798X 31st Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986575.46002 | 2103344.33269 | 37.7546074174257 | -122.489391225039 | (37.7546074174257, -122.489391225039) | ||||
122644 | 122644 | 110235 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2346x CASTRO ST | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 3x3 | 6002664.5 | 2098664.4 | 37.742683511585206 | -122.43341667357402 | (37.7426835115852, -122.433416673574) | ||||
128668 | 128668 | 113328 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 237 Fairmount St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775932 | 6004215.8 | 2097159.4 | 37.7386390150291 | -122.427945503988 | (37.7386390150291, -122.427945503988) | |||
131250 | 131250 | 224198 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6005259.16763 | 2097058.5140200001 | 37.7384209767501 | -122.424330858406 | (37.7384209767501, -122.424330858406) | ||||
131781 | 131781 | 187031 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 0ft | 5984966.2618 | 2097842.7948 | 37.7394076227298 | -122.494550633787 | (37.7394076227298, -122.494550633787) | |||
133023 | 133023 | 224217 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 115 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6005000.71693 | 2096893.74168 | 37.7379539516063 | -122.42521273450001 | (37.7379539516063, -122.4252127345) | ||||
134007 | 134007 | 224207 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 64 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | Width 8ft | 6005337.33065 | 2097353.93167 | 37.739236540443294 | -122.42408161128999 | (37.7392365404433, -122.42408161129) | |||
134903 | 134903 | 224201 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6003522.52197 | 2095626.54462 | 37.7343908979074 | -122.430233200698 | (37.7343908979074, -122.430233200698) | ||||
139574 | 139574 | 107711 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1798X 31st Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986575.46002 | 2103344.33269 | 37.7546074174257 | -122.489391225039 | (37.7546074174257, -122.489391225039) | ||||
140915 | 140915 | 109851 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 3250x 22ND ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6006518.0 | 2103190.0 | 37.7553276504831 | -122.420413510616 | (37.7553276504831, -122.420413510616) | |||
142725 | 142725 | 112581 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 274X SAN MARCOS AVE | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 3x20 | 5993121.0 | 2100271.0 | 37.7465487656332 | -122.46653182115801 | (37.7465487656332, -122.466531821158) | ||||
143010 | 143010 | 112970 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1409 MCKINNON AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6016184.0 | 2095282.0 | 37.734153872922896 | -122.386433919032 | (37.7341538729229, -122.386433919032) | |||||
143876 | 143876 | 111238 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 48X OAKHURST LN | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994967.0 | 2104000.0 | 37.7568940069608 | -122.460418748436 | (37.7568940069608, -122.460418748436) | ||||
144910 | 144910 | 113889 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1x STORRIE ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 90 | 6000722.0 | 2105303.0 | 37.76080110933629 | -122.440609317727 | (37.7608011093363, -122.440609317727) | ||||
145561 | 145561 | 105665 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 317X DORADO TER | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 24 | 5994307.4 | 2093021.4 | 37.7267115488018 | -122.461903806308 | (37.7267115488018, -122.461903806308) | ||||
147712 | 147712 | 224218 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 60 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6007258.1885 | 2099113.30571 | 37.744175654874894 | -122.417564790989 | (37.7441756548749, -122.417564790989) | |||
151415 | 151415 | 224206 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 59 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6005333.6743 | 2097319.7623400004 | 37.739142512726396 | -122.424091823995 | (37.7391425127264, -122.424091823995) | ||||
158093 | 158093 | 224205 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 58 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6005328.89296 | 2097313.9887099997 | 37.7391263896815 | -122.424107945232 | (37.7391263896815, -122.424107945232) | ||||
159148 | 159148 | 224215 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6005165.86979 | 2097298.42463 | 37.739074448424 | -122.424670499065 | (37.739074448424, -122.424670499065) | ||||
159794 | 159794 | 218792 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1259 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5995767.3383 | 2106956.01161 | 37.7650564658073 | -122.457864799536 | (37.7650564658073, -122.457864799536) | |||
159855 | 159855 | 224200 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6003533.27125 | 2095632.5118900002 | 37.7344078915187 | -122.430196462512 | (37.7344078915187, -122.430196462512) | ||||
161898 | 161898 | 199408 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 5 Cashmere St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6017196.63462 | 2095827.84715 | 37.7357086637323 | -122.38297086303801 | (37.7357086637323, -122.382970863038) | |||
164248 | 164248 | 122943 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 300 09th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 3ft | 5993109.61739 | 2113257.70524 | 37.7822061800557 | -122.467515420271 | (37.7822061800557, -122.467515420271) | |||
165999 | 165999 | 199400 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 299 Cashmere St | 16 | : 4 | Tree 1 | Private 1 | 38 | 6016698.52819 | 2095954.85127 | 37.7360298565815 | -122.384701870897 | (37.7360298565815, -122.384701870897) | ||||
166229 | 166229 | 183716 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1231 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5984571.0948 | 2106790.8677 | 37.7639534289968 | -122.49657706948 | (37.7639534289968, -122.49657706948) | |||
166378 | 166378 | 224204 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6003450.74753 | 2095594.0107 | 37.734297501527294 | -122.430479027684 | (37.7342975015273, -122.430479027684) | ||||
166595 | 166595 | 224209 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 70 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6005356.45271 | 2097454.81484 | 37.7395146225008 | -122.424022667913 | (37.7395146225008, -122.424022667913) | ||||
175024 | 175024 | 224211 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6005190.349119999 | 2097382.93272 | 37.739307871065996 | -122.424591870417 | (37.739307871066, -122.424591870417) | ||||
177574 | 177574 | 191717 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 554 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 6ft | 6011757.49983 | 2105782.3491 | 37.762739532526005 | -122.40247591803801 | (37.762739532526, -122.402475918038) | |||
178126 | 178126 | 224454 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 4090 20th St | 6 | : Yard 23 | Tree 1 | Private 1 | 12 | Width 3ft | 6003124.6046 | 2104168.08557 | 37.7578214298263 | -122.432218730236 | (37.7578214298263, -122.432218730236) |
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");