Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
47801 | 47801 | 234359 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x Dolores St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6005116.63925 | 2102018.48994 | 37.752031886768705 | -122.42517648553302 | (37.7520318867687, -122.425176485533) | ||||
27286 | 27286 | 132113 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6013330.52243 | 2119204.92075 | 37.7996825238869 | -122.39797700193701 | (37.7996825238869, -122.397977001937) | |||
62709 | 62709 | 132071 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6013261.919290001 | 2119233.02284 | 37.7997558644996 | -122.39821636821199 | (37.7997558644996, -122.398216368212) | |||
66065 | 66065 | 132114 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6013298.81612 | 2119255.09608 | 37.799818527453105 | -122.39809024008001 | (37.7998185274531, -122.39809024008) | |||
68393 | 68393 | 132116 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6013189.6161 | 2119421.22304 | 37.800268589579204 | -122.39847977871901 | (37.8002685895792, -122.398479778719) | |||
115831 | 115831 | 132073 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 10ft | 6013155.58738 | 2119398.1180000002 | 37.800203252927105 | -122.39859590999501 | (37.8002032529271, -122.398595909995) | |||
131771 | 131771 | 132074 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6013098.86351 | 2119482.52775 | 37.800431861502396 | -122.39879812525601 | (37.8004318615024, -122.398798125256) | |||
133036 | 133036 | 132072 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 10ft | 6013209.184309999 | 2119314.66631 | 37.799977100409 | -122.39840458371201 | (37.799977100409, -122.398404583712) | |||
137882 | 137882 | 132117 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 10ft | 6013132.776319999 | 2119506.7755299998 | 37.800500329583 | -122.398682475136 | (37.800500329583, -122.398682475136) | |||
147998 | 147998 | 132115 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6013243.85901 | 2119336.7003900004 | 37.8000395322586 | -122.398286142085 | (37.8000395322586, -122.398286142085) | |||
25390 | 25390 | 132077 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6012714.4120000005 | 2120058.1365799997 | 37.8019909162964 | -122.400168938451 | (37.8019909162964, -122.400168938451) | |||
32862 | 32862 | 132075 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6012816.85763 | 2119903.53523 | 37.8015721299035 | -122.399803563704 | (37.8015721299035, -122.399803563704) | |||
37174 | 37174 | 132080 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 10ft | 6012562.54875 | 2120282.53748 | 37.802598598112 | -122.40071023410101 | (37.802598598112, -122.400710234101) | |||
48115 | 48115 | 132100 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 10ft | 6012551.63717 | 2120363.68822 | 37.802820809805496 | -122.400753698321 | (37.8028208098055, -122.400753698321) | |||
49479 | 49479 | 132094 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 10ft | 6012848.0944 | 2119927.2949200002 | 37.8016391096046 | -122.39969713882601 | (37.8016391096046, -122.399697138826) | |||
56654 | 56654 | 132101 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 10ft | 6012520.61539 | 2120407.16114 | 37.802938445615 | -122.40086410632 | (37.802938445615, -122.40086410632) | |||
59618 | 59618 | 132097 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 10ft | 6012695.81427 | 2120154.0888900002 | 37.8022533411719 | -122.400240038841 | (37.8022533411719, -122.400240038841) | |||
61544 | 61544 | 132098 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6012646.4501 | 2120224.08688 | 37.802442786052396 | -122.40041578348699 | (37.8024427860524, -122.400415783487) | |||
75574 | 75574 | 132078 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6012663.130340001 | 2120132.51785 | 37.8021922897941 | -122.40035162582899 | (37.8021922897941, -122.400351625829) | |||
76777 | 76777 | 132095 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6012798.77066 | 2120004.26494 | 37.801847701082394 | -122.39987323058901 | (37.8018477010824, -122.399873230589) | |||
129992 | 129992 | 132099 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 10ft | 6012592.45443 | 2120302.68635 | 37.8026555899447 | -122.40060816104099 | (37.8026555899447, -122.400608161041) | |||
135157 | 135157 | 132081 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6012501.69351 | 2120366.8481099997 | 37.802826700352995 | -122.400926752172 | (37.802826700353, -122.400926752172) | |||
150555 | 150555 | 132096 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6012742.85934 | 2120080.46122 | 37.8020538004962 | -122.400072065282 | (37.8020538004962, -122.400072065282) | |||
164266 | 164266 | 132076 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 10ft | 6012766.891340001 | 2119978.53875 | 37.8017752858665 | -122.399981740966 | (37.8017752858665, -122.399981740966) | |||
176286 | 176286 | 132079 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6012611.87531 | 2120208.19637 | 37.8023972264213 | -122.40053431322399 | (37.8023972264213, -122.400534313224) | |||
186566 | 186566 | 132093 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 10ft | 6012902.31977 | 2119848.32419 | 37.8014252975988 | -122.39950394556699 | (37.8014252975988, -122.399503945567) | |||
33156 | 33156 | 234362 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6005144.45634 | 2101528.47617 | 37.7506879938715 | -122.425045428228 | (37.7506879938715, -122.425045428228) | ||||
63890 | 63890 | 234360 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6005142.56045 | 2101579.1271 | 37.7508269625113 | -122.425055587855 | (37.7508269625113, -122.425055587855) | ||||
132937 | 132937 | 234364 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6005148.136969999 | 2101464.62312 | 37.7505128760752 | -122.425028157637 | (37.7505128760752, -122.425028157637) | ||||
151204 | 151204 | 234363 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6005145.85028 | 2101496.26634 | 37.7505996318694 | -122.425038316369 | (37.7505996318694, -122.425038316369) | ||||
154721 | 154721 | 234361 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6005142.97819 | 2101556.59196 | 37.75076510982829 | -122.42505254004699 | (37.7507651098283, -122.425052540047) | ||||
158301 | 158301 | 234365 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 6005150.81264 | 2101423.31762 | 37.7503996118641 | -122.425015966416 | (37.7503996118641, -122.425015966416) | ||||
151971 | 151971 | 194274 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Tennessee St | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6015578.255919999 | 2103421.32087 | 37.756469211897 | -122.389096301947 | (37.756469211897, -122.389096301947) | ||||
152917 | 152917 | 194273 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Tennessee St | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 8ft | 6015573.17514 | 2103426.7647700002 | 37.7564838780418 | -122.38911425333 | (37.7564838780418, -122.38911425333) | |||
47529 | 47529 | 132102 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 10ft | 6012409.883230001 | 2120572.1173400003 | 37.8033851982182 | -122.401258897879 | (37.8033851982182, -122.401258897879) | |||
65398 | 65398 | 132082 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6012375.04896 | 2120549.1986599998 | 37.803320325622295 | -122.40137783233999 | (37.8033203256223, -122.40137783234) | |||
70617 | 70617 | 132083 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6012328.94165 | 2120621.527 | 37.8035163490725 | -122.401542475719 | (37.8035163490725, -122.401542475719) | |||
176923 | 176923 | 132084 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 10ft | 6012274.61558 | 2120706.35336 | 37.8037462301721 | -122.401736440606 | (37.8037462301721, -122.401736440606) | |||
153490 | 153490 | 132085 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6012153.585109999 | 2120867.04559 | 37.8041806971541 | -122.402166580042 | (37.8041806971541, -122.402166580042) | |||
71379 | 71379 | 234345 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1350x Dolores St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 6005211.50018 | 2100294.54181 | 37.7473036813364 | -122.424725813644 | (37.7473036813364, -122.424725813644) | ||||
133800 | 133800 | 234346 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1350x Dolores St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 6005214.83803 | 2100265.33674 | 37.74722367943539 | -122.424712194312 | (37.7472236794354, -122.424712194312) | ||||
25048 | 25048 | 132103 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 10ft | 6012095.78368 | 2120981.89347 | 37.8044928149639 | -122.402374687645 | (37.8044928149639, -122.402374687645) | |||
136050 | 136050 | 132086 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6011972.21269 | 2121045.33445 | 37.8046601095467 | -122.402806783124 | (37.8046601095467, -122.402806783124) | |||
168474 | 168474 | 132105 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400x The Embarcadero | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6012001.46692 | 2121074.30881 | 37.8047412994387 | -122.402707584299 | (37.8047412994387, -122.402707584299) | |||
177459 | 177459 | 132104 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | Width 10ft | 6012041.8343 | 2121038.82925 | 37.8046461349625 | -122.402565391602 | (37.8046461349625, -122.402565391602) | |||
30823 | 30823 | 132092 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6011191.46105 | 2121714.3637599996 | 37.806453474602 | -122.405555813649 | (37.806453474602, -122.405555813649) | |||
41127 | 41127 | 132091 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6011272.98764 | 2121658.8993 | 37.806305741188204 | -122.405269766312 | (37.8063057411882, -122.405269766312) | |||
50014 | 50014 | 132109 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6011459.50109 | 2121569.1071 | 37.8060696196846 | -122.40461797546301 | (37.8060696196846, -122.404617975463) | |||
62222 | 62222 | 132090 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6011358.77785 | 2121601.92287 | 37.8061540939119 | -122.40496885853999 | (37.8061540939119, -122.40496885854) | |||
69507 | 69507 | 132112 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6011208.1934400005 | 2121737.88602 | 37.8065189965151 | -122.40549956557501 | (37.8065189965151, -122.405499565575) | |||
70221 | 70221 | 132087 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6011581.4658 | 2121414.5973099996 | 37.8056521894584 | -122.40418501304501 | (37.8056521894584, -122.404185013045) | |||
70595 | 70595 | 132088 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 10ft | 6011509.10408 | 2121480.92062 | 37.8058302534199 | -122.404440103948 | (37.8058302534199, -122.404440103948) | |||
149311 | 149311 | 132111 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 10ft | 6011290.22315 | 2121683.26622 | 37.806373610322105 | -122.40521183646999 | (37.8063736103221, -122.40521183647) | |||
155474 | 155474 | 132089 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6011437.6783 | 2121540.455 | 37.805989728403894 | -122.404691478852 | (37.8059897284039, -122.404691478852) | |||
166867 | 166867 | 132106 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6011673.52168 | 2121373.1691 | 37.8055435810345 | -122.40386352159099 | (37.8055435810345, -122.403863521591) | |||
168748 | 168748 | 132110 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6011374.63029 | 2121626.67271 | 37.8062229369941 | -122.404915741893 | (37.8062229369941, -122.404915741893) | |||
181994 | 181994 | 132108 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6011532.668269999 | 2121506.48507 | 37.8059017639302 | -122.404360356561 | (37.8059017639302, -122.404360356561) | |||
182470 | 182470 | 132107 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 10ft | 6011604.73213 | 2121437.1460700002 | 37.805715402812204 | -122.40410608402901 | (37.8057154028122, -122.404106084029) | |||
24494 | 24494 | 233935 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 150x Dolores St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6004826.52958 | 2107279.95522 | 37.766462234780604 | -122.426554344032 | (37.7664622347806, -122.426554344032) | ||||
72308 | 72308 | 233934 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 150x Dolores St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 6004824.15396 | 2107326.99928 | 37.7665912721916 | -122.42656591108101 | (37.7665912721916, -122.426565911081) | ||||
73360 | 73360 | 233933 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 150x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 6004817.19467 | 2107404.1110799997 | 37.76680260927 | -122.426595473608 | (37.76680260927, -122.426595473608) | ||||
182641 | 182641 | 233932 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 150x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6004814.58298 | 2107439.6885599997 | 37.7669001488458 | -122.426607040704 | (37.7669001488458, -122.426607040704) | ||||
47477 | 47477 | 234367 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1650x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 44 | 6005309.50054 | 2098532.58451 | 37.7424712831236 | -122.424261641173 | (37.7424712831236, -122.424261641173) | ||||
22823 | 22823 | 251110 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
22825 | 22825 | 251109 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
22828 | 22828 | 251115 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 19 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
22831 | 22831 | 251116 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 20 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
22832 | 22832 | 251108 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
22833 | 22833 | 251113 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 15 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
22838 | 22838 | 251111 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
22839 | 22839 | 251114 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 16 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
27134 | 27134 | 194292 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 43 | Median : Yard 3 | Tree 1 | DPW 2 | 38 | 6014354.24031 | 2095291.86255 | 37.734079495961396 | -122.392760714642 | (37.7340794959614, -122.392760714642) | ||||
27594 | 27594 | 194293 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 46 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6014318.796490001 | 2095319.19207 | 37.7341525685742 | -122.392885167337 | (37.7341525685742, -122.392885167337) | ||||
35608 | 35608 | 194288 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 37 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 6014411.93404 | 2095259.01392 | 37.733992504551296 | -122.392558950849 | (37.7339925045513, -122.392558950849) | ||||
35928 | 35928 | 194284 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6014504.15008 | 2095180.2076400002 | 37.733781239407 | -122.392234619349 | (37.733781239407, -122.392234619349) | ||||
39870 | 39870 | 194287 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 32 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6014435.322380001 | 2095233.3766599998 | 37.733923408722795 | -122.392476296866 | (37.7339234087228, -122.392476296866) | ||||
54350 | 54350 | 194294 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 49 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6014297.19865 | 2095334.47415 | 37.7341933303645 | -122.392960907318 | (37.7341933303645, -122.392960907318) | ||||
54354 | 54354 | 194291 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 41 | Median : Yard 3 | Tree 1 | DPW 2 | 38 | 6014364.32912 | 2095287.3135099998 | 37.7340675655682 | -122.39272551607701 | (37.7340675655682, -122.392725516077) | ||||
58702 | 58702 | 194289 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 38 | Median : Yard 3 | Tree 1 | DPW 2 | 48 | 6014396.14271 | 2095264.76436 | 37.734007417094 | -122.39261394888901 | (37.734007417094, -122.392613948889) | ||||
70141 | 70141 | 194290 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 40 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6014381.3022300005 | 2095272.57767 | 37.7340280466394 | -122.39266580380101 | (37.7340280466394, -122.392665803801) | ||||
150397 | 150397 | 194286 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 29 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | 6014450.16973 | 2095221.3993900002 | 37.7338913460907 | -122.392424127176 | (37.7338913460907, -122.392424127176) | ||||
166815 | 166815 | 194285 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6014471.94536 | 2095201.4069599998 | 37.7338376601657 | -122.39234744377701 | (37.7338376601657, -122.392347443777) | ||||
47964 | 47964 | 234371 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 6005338.50183 | 2098008.71997 | 37.7410345073494 | -122.42412411595 | (37.7410345073494, -122.42412411595) | ||||
68375 | 68375 | 234369 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6005339.90624 | 2098058.76544 | 37.7411720001789 | -122.42412281821899 | (37.7411720001789, -122.424122818219) | ||||
123736 | 123736 | 234368 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6005333.75186 | 2098133.92444 | 37.7413780222889 | -122.42414944174 | (37.7413780222889, -122.42414944174) | ||||
148964 | 148964 | 234370 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 6005335.592730001 | 2098044.06455 | 37.7411313913144 | -122.42413668757 | (37.7411313913144, -122.42413668757) | ||||
94540 | 94540 | 106114 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1752X DOLORES ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 6005197.0 | 2098194.1 | 37.741535528464496 | -122.424626562024 | (37.7415355284645, -122.424626562024) | |||||
58200 | 58200 | 246535 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1x Octavia St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 8ft | 6005703.308569999 | 2109325.61851 | 37.7721286642513 | -122.423667182089 | (37.7721286642513, -122.423667182089) | |||
137727 | 137727 | 246536 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1x Octavia St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | Width 8ft | 6005696.49055 | 2109344.97624 | 37.7721814310539 | -122.42369214280501 | (37.7721814310539, -122.423692142805) | |||
35273 | 35273 | 233937 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 230x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | 6004843.94175 | 2106947.59382 | 37.7655506342911 | -122.42647045077801 | (37.7655506342911, -122.426470450778) | ||||
41120 | 41120 | 233936 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 230x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 6004841.8872 | 2106976.70647 | 37.7656304545194 | -122.42647963012699 | (37.7656304545194, -122.426479630127) | ||||
170250 | 170250 | 233938 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 230x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 6004845.02149 | 2106914.0966 | 37.7654587199743 | -122.426464330874 | (37.7654587199743, -122.426464330874) | ||||
49252 | 49252 | 233940 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 270x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6004851.53435 | 2106800.76384 | 37.7651479034782 | -122.426433734123 | (37.7651479034782, -122.426433734123) | ||||
71756 | 71756 | 233939 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 270x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | 6004850.2917 | 2106826.33652 | 37.765218049699605 | -122.426439853137 | (37.7652180496996, -122.426439853137) | ||||
29492 | 29492 | 194379 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 300x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6015888.45756 | 2115624.95631 | 37.7899948982019 | -122.388875463533 | (37.7899948982019, -122.388875463533) | |||
42530 | 42530 | 194380 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 300x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6015792.97899 | 2115653.31942 | 37.79006748427221 | -122.38920779542102 | (37.7900674842722, -122.389207795421) | |||
48046 | 48046 | 194385 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 300x The Embarcadero | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 8ft | 6015616.39603 | 2115848.18198 | 37.7905927414207 | -122.38983237995701 | (37.7905927414207, -122.389832379957) | |||
134092 | 134092 | 194378 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 300x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | Width 8ft | 6015852.133669999 | 2115594.9283 | 37.7899104347693 | -122.388999044794 | (37.7899104347693, -122.388999044794) | |||
135215 | 135215 | 194383 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 300x The Embarcadero | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 8ft | 6015768.92359 | 2115752.8180400003 | 37.7903393511162 | -122.389297976729 | (37.7903393511162, -122.389297976729) | |||
153149 | 153149 | 194381 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 300x The Embarcadero | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 8ft | 6015827.50848 | 2115690.11268 | 37.79017042428 | -122.389090895237 | (37.79017042428, -122.389090895237) |
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");