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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29290 | 29290 | 204967 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500x Miramar Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5995373.3226 | 2092827.47447 | 37.7262403835647 | -122.45820493933 | (37.7262403835647, -122.45820493933) | ||||
48651 | 48651 | 212130 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Miramar Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 5995375.50202 | 2092861.84028 | 37.726334869051705 | -122.458199891406 | (37.7263348690517, -122.458199891406) | ||||
61473 | 61473 | 212131 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Miramar Ave | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 5995375.289340001 | 2092898.1948 | 37.7264346776031 | -122.45820325667201 | (37.7264346776031, -122.458203256672) | ||||
64686 | 64686 | 212132 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Miramar Ave | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 5995375.30973 | 2092922.4277599999 | 37.7265012166564 | -122.458204939309 | (37.7265012166564, -122.458204939309) | ||||
47939 | 47939 | 211068 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 500x Miramar Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 5995376.89131 | 2092998.0023 | 37.7267088170477 | -122.4582049393 | (37.7267088170477, -122.4582049393) | ||||
163476 | 163476 | 212133 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Miramar Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | 5995378.50307 | 2093028.5023400001 | 37.7267926554346 | -122.458201574049 | (37.7267926554346, -122.458201574049) | ||||
160874 | 160874 | 211069 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 500x Miramar Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | 5995377.19569 | 2093059.06381 | 37.7268764947539 | -122.458208304568 | (37.7268764947539, -122.458208304568) | ||||
175789 | 175789 | 204968 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500x Miramar Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 5995374.72288 | 2093080.44046 | 37.726935047798705 | -122.45821839946301 | (37.7269350477987, -122.458218399463) | ||||
72326 | 72326 | 212134 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Miramar Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5995376.36506 | 2093112.3941099998 | 37.727022879194 | -122.458215034219 | (37.727022879194, -122.458215034219) | ||||
43585 | 43585 | 212135 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Miramar Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 5995377.611959999 | 2093148.71744 | 37.7271226859638 | -122.45821335156201 | (37.7271226859638, -122.458213351562) | ||||
27755 | 27755 | 211070 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 500x Miramar Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 5995378.929819999 | 2093188.4321700002 | 37.7272318087773 | -122.45821166894699 | (37.7272318087773, -122.458211668947) | ||||
175644 | 175644 | 211071 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 500x Miramar Ave | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 5995380.09454 | 2093218.25605 | 37.727313764897 | -122.45820980016899 | (37.727313764897, -122.458209800169) | ||||
50835 | 50835 | 212136 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Miramar Ave | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 5995379.948 | 2093237.13475 | 37.7273655928402 | -122.458211672546 | (37.7273655928402, -122.458211672546) | ||||
187577 | 187577 | 205961 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 600x Wildwood Way | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 5995381.06521 | 2093316.38835 | 37.7275832683311 | -122.458213544042 | (37.7275832683311, -122.458213544042) | ||||
3208 | 3208 | 253368 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 236 Moncada Way | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 10x10 | 5992398.0 | 2093455.0 | 37.7277919980392 | -122.468536018982 | (37.7277919980392, -122.468536018982) | ||||
69754 | 69754 | 212137 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 602x Miramar Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | 5995383.74966 | 2093392.9126 | 37.7277935397334 | -122.458209800147 | (37.7277935397334, -122.458209800147) | ||||
85151 | 85151 | 99471 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Miramar Ave | 7 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995435.2 | 2093399.0 | 37.727813210556704 | -122.458032376835 | (37.7278132105567, -122.458032376835) | |
32049 | 32049 | 211072 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 602x Miramar Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 5995382.34021 | 2093429.0746900002 | 37.7278927511259 | -122.45821728880699 | (37.7278927511259, -122.458217288807) | ||||
147361 | 147361 | 212138 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 602x Miramar Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 5995385.58848 | 2093480.77927 | 37.7280349060874 | -122.458209800162 | (37.7280349060874, -122.458209800162) | ||||
186146 | 186146 | 212139 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 602x Miramar Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 5995385.05875 | 2093507.2159099998 | 37.728107464286204 | -122.45821354403999 | (37.7281074642862, -122.45821354404) | ||||
34133 | 34133 | 211073 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 602x Miramar Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 5995385.83715 | 2093544.41078 | 37.7282096371561 | -122.458213544022 | (37.7282096371561, -122.458213544022) | ||||
42314 | 42314 | 212140 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 602x Miramar Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 5995385.5779099995 | 2093583.7848200002 | 37.728317733874704 | -122.458217288803 | (37.7283177338747, -122.458217288803) | ||||
133898 | 133898 | 212141 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 602x Miramar Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 5995388.25082 | 2093607.9969900001 | 37.7283843682417 | -122.458209800164 | (37.7283843682417, -122.458209800164) | ||||
57865 | 57865 | 212142 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 602x Miramar Ave | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5995386.50296 | 2093627.98743 | 37.72843915673079 | -122.458217288806 | (37.7284391567308, -122.458217288806) | ||||
19556 | 19556 | 99478 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 650X Miramar Ave | 4 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.45808530293199 | (37.728535605791, -122.458085302932) | |
188939 | 188939 | 212143 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 650x Miramar Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5995395.28868 | 2093711.39383 | 37.7286686754144 | -122.45819295046199 | (37.7286686754144, -122.458192950462) | ||||
134170 | 134170 | 212144 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 650x Miramar Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995391.35311 | 2093756.23728 | 37.7287915785573 | -122.458209800162 | (37.7287915785573, -122.458209800162) | ||||
61634 | 61634 | 212145 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 650x Miramar Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5995391.25206 | 2093803.15728 | 37.7289204037391 | -122.458213544026 | (37.7289204037391, -122.458213544026) | ||||
187602 | 187602 | 212146 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 650x Miramar Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 5995392.59413 | 2093841.41892 | 37.7290255380777 | -122.458211672548 | (37.7290255380777, -122.458211672548) | ||||
52091 | 52091 | 211074 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 650x Miramar Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 5995392.34643 | 2093881.33119 | 37.729135113294504 | -122.458215416413 | (37.7291351132945, -122.458215416413) | ||||
29553 | 29553 | 211075 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 650x Miramar Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 5995390.83549 | 2093912.64173 | 37.7292209976493 | -122.458222905073 | (37.7292209976493, -122.458222905073) | ||||
41518 | 41518 | 203592 | DPW Maintained 3 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1485x Northwood Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995892.33391 | 2093907.44512 | 37.729235533389705 | -122.45648881700899 | (37.7292355333897, -122.456488817009) | ||||
69752 | 69752 | 219170 | DPW Maintained 3 | Heteromeles arbutifolia :: Toyon 322 | 1485x Northwood Dr | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 5995884.37538 | 2093916.02711 | 37.729258640557106 | -122.45651695051501 | (37.7292586405571, -122.456516950515) | ||||
65206 | 65206 | 204969 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650x Miramar Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 5995393.40684 | 2093932.00201 | 37.729274304053796 | -122.458215416425 | (37.7292743040538, -122.458215416425) | ||||
172713 | 172713 | 219171 | DPW Maintained 3 | Heteromeles arbutifolia :: Toyon 322 | 1485x Northwood Dr | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 5995877.5181599995 | 2093932.37838 | 37.72930314352 | -122.456541838346 | (37.72930314352, -122.456541838346) | ||||
43499 | 43499 | 204970 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650x Miramar Ave | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 5995394.3543300005 | 2093951.39661 | 37.729327611382 | -122.458213544044 | (37.729327611382, -122.458213544044) | ||||
72555 | 72555 | 204955 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1485x Northwood Dr | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 5995888.63962 | 2093952.75509 | 37.72935973156871 | -122.45650486362 | (37.7293597315687, -122.45650486362) | ||||
46600 | 46600 | 116804 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 131 LAKESHORE DR | 1 | Median : Yard 3 | Landscaping 2 | DPW 2 | 10x100 | 5984782.0 | 2094243.0 | 37.7295127607338 | -122.494922366174 | (37.7295127607338, -122.494922366174) | ||||
56364 | 56364 | 204718 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1485x Northwood Dr | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5995836.31697 | 2094012.72029 | 37.7295213774971 | -122.456690081702 | (37.7295213774971, -122.456690081702) | ||||
43116 | 43116 | 212147 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700x Miramar Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995390.97132 | 2094022.6530799998 | 37.729523070026104 | -122.458230394627 | (37.7295230700261, -122.458230394627) | ||||
156476 | 156476 | 212091 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1485x Northwood Dr | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 5995834.1462199995 | 2094028.6614299999 | 37.7295650233891 | -122.45669873857099 | (37.7295650233891, -122.456698738571) | ||||
75225 | 75225 | 204717 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1485x Northwood Dr | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995876.20042 | 2094034.0159599998 | 37.7295821401899 | -122.456553740875 | (37.7295821401899, -122.456553740875) | ||||
138714 | 138714 | 99482 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Miramar Ave | 1 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995446.3 | 2094052.9 | 37.7296092999141 | -122.458041307204 | (37.7296092999141, -122.458041307204) | |
58061 | 58061 | 212092 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1485x Northwood Dr | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 5995863.34016 | 2094047.68745 | 37.7296189404529 | -122.456599188129 | (37.7296189404529, -122.456599188129) | ||||
135651 | 135651 | 212093 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1485x Northwood Dr | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 5995874.68785 | 2094051.5020599999 | 37.7296300659678 | -122.456560233969 | (37.7296300659678, -122.456560233969) | ||||
56600 | 56600 | 211076 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 700x Miramar Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 74 | 5995394.80602 | 2094076.5012 | 37.7296711442905 | -122.458221033586 | (37.7296711442905, -122.458221033586) | ||||
179786 | 179786 | 212148 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700x Miramar Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995395.17866 | 2094120.1752900002 | 37.7297910841891 | -122.45822290508801 | (37.7297910841891, -122.458222905088) | ||||
49060 | 49060 | 212149 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700x Miramar Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995397.3757 | 2094149.6680599998 | 37.7298721904459 | -122.45821744347602 | (37.7298721904459, -122.458217443476) | ||||
44746 | 44746 | 212150 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700x Miramar Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 5995395.95716 | 2094183.25498 | 37.72996433048829 | -122.45822477747 | (37.7299643304883, -122.45822477747) | ||||
118289 | 118289 | 114805 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 210X GELLERT DR | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 3x3 | 5985389.0 | 2094462.0 | 37.73014959142171 | -122.492840061243 | (37.7301495914217, -122.492840061243) | |||
33003 | 33003 | 194020 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1100x Bay Shore Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6011361.40113 | 2093925.29225 | 37.7301604996095 | -122.403011863611 | (37.7301604996095, -122.403011863611) | ||||
173363 | 173363 | 194027 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1100x Bay Shore Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6011379.88735 | 2093929.83608 | 37.730174008312 | -122.40294827345501 | (37.730174008312, -122.402948273455) | ||||
148993 | 148993 | 212151 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Miramar Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5995396.67937 | 2094269.52475 | 37.7302012478931 | -122.458228522241 | (37.7302012478931, -122.458228522241) | ||||
131420 | 131420 | 194026 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1100x Bay Shore Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 6011390.96705 | 2093942.9768299998 | 37.730210708757504 | -122.40291089314199 | (37.7302107087575, -122.402910893142) | |||
174310 | 174310 | 194021 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1100x Bay Shore Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6011358.20125 | 2093944.86355 | 37.730214059626 | -122.403024302127 | (37.730214059626, -122.403024302127) | ||||
87236 | 87236 | 99491 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Miramar Ave | 5 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | |
98576 | 98576 | 99490 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Miramar Ave | 4 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | |
123683 | 123683 | 99488 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Miramar Ave | 1 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | |
38839 | 38839 | 194025 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1100x Bay Shore Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 6011395.816869999 | 2093961.4424599998 | 37.730261682333605 | -122.402895424807 | (37.7302616823336, -122.402895424807) | |||
73605 | 73605 | 194022 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1100x Bay Shore Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6011349.26404 | 2093964.0599200001 | 37.7302662697704 | -122.403056549132 | (37.7302662697704, -122.403056549132) | |||
150276 | 150276 | 194024 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1100x Bay Shore Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 10ft | 6011380.0136 | 2093972.7166799998 | 37.7302917565413 | -122.4029508518 | (37.7302917565413, -122.4029508518) | |||
182169 | 182169 | 212152 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Miramar Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 5995399.05929 | 2094305.60657 | 37.730300456589106 | -122.458222905079 | (37.7303004565891, -122.458222905079) | ||||
38678 | 38678 | 194023 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1100x Bay Shore Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 10ft | 6011366.79301 | 2093982.63877 | 37.730318262277606 | -122.402997255042 | (37.7303182622776, -122.402997255042) | |||
169173 | 169173 | 212153 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Miramar Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995398.99771 | 2094330.69415 | 37.730369337469504 | -122.458224933031 | (37.7303693374695, -122.458224933031) | ||||
48270 | 48270 | 212154 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Miramar Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 5995400.46902 | 2094347.10151 | 37.7304144726506 | -122.458221033597 | (37.7304144726506, -122.458221033597) | ||||
156541 | 156541 | 212155 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Miramar Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5995400.6273300005 | 2094380.5335900001 | 37.7305062781406 | -122.458222905082 | (37.7305062781406, -122.458222905082) | ||||
135702 | 135702 | 211288 | DPW Maintained 3 | Pinus thunbergii :: Japanese Black Pine 306 | 800x Miramar Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 5995401.87913 | 2094414.4819 | 37.7305995639058 | -122.458221033587 | (37.7305995639058, -122.458221033587) | ||||
76907 | 76907 | 180414 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1104x Alemany Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6003758.53299 | 2094425.58203 | 37.73110669070989 | -122.42933162228 | (37.7311066907099, -122.42933162228) | |||
180303 | 180303 | 180413 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1104x Alemany Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6003786.93346 | 2094435.4492400002 | 37.731135391684 | -122.42923414026001 | (37.731135391684, -122.42923414026) | |||
183887 | 183887 | 180412 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1104x Alemany Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6003814.30975 | 2094445.54262 | 37.7311646556118 | -122.42914021505501 | (37.7311646556118, -122.429140215055) | |||
31521 | 31521 | 175079 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1104x Alemany Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6003837.73065 | 2094453.4628599999 | 37.7311877286109 | -122.42905980937599 | (37.7311877286109, -122.429059809376) | |||
134097 | 134097 | 189485 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 10x Garlington Ct | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 8ft | 6016768.7449900005 | 2094679.8943900003 | 37.7325329624249 | -122.384370330438 | (37.7325329624249, -122.384370330438) | |||
104474 | 104474 | 97692 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 70x Benton Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 11/05/2011 12:00:00 AM | 6004768.61645 | 2094959.0484200001 | 37.732628603868704 | -122.425877544976 | (37.7326286038687, -122.425877544976) | ||||
184341 | 184341 | 222760 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 10x Benton Ave | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6004726.81144 | 2094996.18589 | 37.73272821244 | -122.426024717968 | (37.73272821244, -122.426024717968) | ||||
174181 | 174181 | 242061 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10x Benton Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6004744.49443 | 2095004.6976299998 | 37.732752583154394 | -122.42596418912301 | (37.7327525831544, -122.425964189123) | ||||
116920 | 116920 | 234415 | DPW Maintained 3 | Phoenix dactylifera :: Date Palm 65 | 10x Benton Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 6004760.79404 | 2095007.84902 | 37.732762157335 | -122.425908061504 | (37.732762157335, -122.425908061504) | ||||
135595 | 135595 | 248774 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 10x Lyell St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 10ft | 6003001.138169999 | 2095064.3103599998 | 37.7328175852443 | -122.43199565878 | (37.7328175852443, -122.43199565878) | |||
153921 | 153921 | 231443 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10x Benton Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6004814.81075 | 2095028.31001 | 37.7328213911887 | -122.425722767894 | (37.7328213911887, -122.425722767894) | ||||
167787 | 167787 | 234517 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 10x Benton Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | 6004828.724280001 | 2095028.54608 | 37.7328228256069 | -122.425674682059 | (37.7328228256069, -122.425674682059) | ||||
37447 | 37447 | 220241 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 10x Benton Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 42 | 6004791.23434 | 2095030.3631099998 | 37.7328256962469 | -122.425804423654 | (37.7328256962469, -122.425804423654) | ||||
127275 | 127275 | 234411 | DPW Maintained 3 | Phoenix dactylifera :: Date Palm 65 | 10x Benton Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | 6004755.33467 | 2095032.93123 | 37.7328307189427 | -122.42592872073601 | (37.7328307189427, -122.425928720736) | ||||
178221 | 178221 | 247571 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 350x Alemany Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 6008108.27012 | 2094965.3059 | 37.732833953824205 | -122.414331952177 | (37.7328339538242, -122.414331952177) | ||||
63738 | 63738 | 248650 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2x Lyell St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 10ft | 6002998.47059 | 2095072.4374099998 | 37.732839749044 | -122.432005461406 | (37.732839749044, -122.432005461406) | |||
53230 | 53230 | 248775 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 10x Lyell St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6002997.286669999 | 2095073.79392 | 37.732843406592295 | -122.432009651347 | (37.7328434065923, -122.432009651347) | |||
180124 | 180124 | 248649 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2x Lyell St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6002995.03876 | 2095080.26155 | 37.732861037793 | -122.43201788462 | (37.732861037793, -122.43201788462) | ||||
188426 | 188426 | 248776 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 10x Lyell St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 10ft | 6002998.16884 | 2095083.8511700002 | 37.73287107152721 | -122.43200731937999 | (37.7328710715272, -122.43200731938) | |||
163348 | 163348 | 247572 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 350x Alemany Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6008135.46244 | 2094979.0190299999 | 37.7328731345802 | -122.414238911006 | (37.7328731345802, -122.414238911006) | ||||
163293 | 163293 | 248777 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 10x Lyell St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6002988.77776 | 2095086.3960799999 | 37.7328775268597 | -122.43203996838699 | (37.7328775268597, -122.432039968387) | |||
39338 | 39338 | 248648 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2x Lyell St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6002994.42779 | 2095088.08837 | 37.7328824938235 | -122.432020555603 | (37.7328824938235, -122.432020555603) | ||||
187741 | 187741 | 248647 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2x Lyell St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6002988.020959999 | 2095088.4577900001 | 37.73288314494071 | -122.432042732011 | (37.7328831449407, -122.432042732011) | ||||
138011 | 138011 | 247573 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 350x Alemany Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6008162.04858 | 2094997.2690700002 | 37.7329247385863 | -122.41414828632901 | (37.7329247385863, -122.414148286329) | ||||
151195 | 151195 | 247574 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 350x Alemany Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6008213.28818 | 2095041.8138700002 | 37.7330499269008 | -122.413974287302 | (37.7330499269008, -122.413974287302) | ||||
152002 | 152002 | 212105 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1602x Monterey Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | Width 10ft | 5993074.71475 | 2095363.2347400002 | 37.7330706059279 | -122.466335248575 | (37.7330706059279, -122.466335248575) | |||
188895 | 188895 | 212106 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1602x Monterey Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | Width 10ft | 5993007.603759999 | 2095365.5409099997 | 37.733073065562 | -122.466567434662 | (37.733073065562, -122.466567434662) | |||
182431 | 182431 | 218284 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 50x Junipero Serra Frontage West | 0 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5991438.8932 | 2095398.7783700002 | 37.7330736770928 | -122.4719932523 | (37.7330736770928, -122.4719932523) | ||||
157513 | 157513 | 212104 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1602x Monterey Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 10ft | 5993129.9763400005 | 2095367.74637 | 37.733086182185 | -122.46614452395201 | (37.733086182185, -122.466144523952) | |||
70498 | 70498 | 212107 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1701x Monterey Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 10ft | 5992822.82885 | 2095375.69454 | 37.7330902803915 | -122.46720698303601 | (37.7330902803915, -122.467206983036) | |||
70013 | 70013 | 212108 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1701x Monterey Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | Width 10ft | 5992762.96057 | 2095380.2374200001 | 37.7330992978931 | -122.46741429204201 | (37.7330992978931, -122.467414292042) | |||
160424 | 160424 | 212109 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1701x Monterey Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | Width 10ft | 5992703.672809999 | 2095383.87275 | 37.7331058566417 | -122.467619528126 | (37.7331058566417, -122.467619528126) | |||
180863 | 180863 | 218285 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Junipero Serra Frontage West | 0 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 5991436.68421 | 2095414.89925 | 37.7331178131424 | -122.47200206387 | (37.7331178131424, -122.47200206387) |
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");