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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
55424 | 55424 | 210903 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1939 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 2ft | 5991246.46009 | 2102193.40392 | 37.7517188372786 | -122.47315388853599 | (37.7517188372786, -122.473153888536) | |||
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) | ||||
22227 | 22227 | 25067 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000X Dolores St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005110.57075 | 2102123.34784 | 37.7523194593995 | -122.425204931964 | (37.7523194593995, -122.425204931964) | |||
132845 | 132845 | 234388 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1069 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 5ft | 6005149.23502 | 2102137.71701 | 37.7523610979942 | -122.425072246905 | (37.7523610979942, -122.425072246905) | |||
21757 | 21757 | 25064 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005102.4225699995 | 2102227.07793 | 37.7526038178156 | -122.425240490271 | (37.7526038178156, -122.425240490271) | |||
71688 | 71688 | 182873 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1845 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 5987506.6654 | 2102709.2443 | 37.7529179526447 | -122.486124291657 | (37.7529179526447, -122.486124291657) | |||
17722 | 17722 | 25061 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005097.79962 | 2102345.06954 | 37.7529275341834 | -122.425264872687 | (37.7529275341834, -122.425264872687) | |||
59740 | 59740 | 182872 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1845 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 0ft | 5987505.5699 | 2102718.6655 | 37.7529437568716 | -122.48612877158999 | (37.7529437568716, -122.48612877159) | |||
183295 | 183295 | 194277 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1301 Rhode Island St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 48 | Width 7ft | 6012002.23785 | 2102241.02504 | 37.7530294975215 | -122.401380567153 | (37.7530294975215, -122.401380567153) | |||
17056 | 17056 | 25058 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005092.48697 | 2102458.1018 | 37.753237594341996 | -122.425291287561 | (37.753237594342, -122.425291287561) | |||
121202 | 121202 | 27482 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 990X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/20/1999 12:00:00 AM | 20 | 20 | 6005038.29077 | 2102581.9809991 | 37.7535746757806 | -122.425487524624 | (37.7535746757806, -122.425487524624) | ||
150698 | 150698 | 234330 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 900x Dolores St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6005083.062580001 | 2102603.58555 | 37.7536365264144 | -122.42533423108699 | (37.7536365264144, -122.425334231087) | ||||
55136 | 55136 | 234387 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 986 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6005043.99676 | 2102621.6014400003 | 37.7536837866767 | -122.425470611492 | (37.7536837866767, -122.425470611492) | |||
20528 | 20528 | 5557 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 977 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/2006 12:00:00 AM | 32 | 3x3 | 6005125.10547 | 2102657.90315 | 37.753788045101 | -122.42519270209499 | (37.753788045101, -122.425192702095) | ||
155084 | 155084 | 234329 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 900x Dolores St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6005081.6594 | 2102660.65252 | 37.7537931397475 | -122.425343144298 | (37.7537931397475, -122.425343144298) | ||||
130104 | 130104 | 210913 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1800 18th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5990641.4505900005 | 2103071.06132 | 37.754093605056795 | -122.47531013997101 | (37.7540936050568, -122.475310139971) | |||
17224 | 17224 | 25054 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 900X Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 20 | 6005073.8483 | 2102816.15893 | 37.7542196827988 | -122.42538122246201 | (37.7542196827988, -122.425381222462) | |||
17694 | 17694 | 25052 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 900X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005070.62845 | 2102872.02457 | 37.7543728949014 | -122.42539633287 | (37.7543728949014, -122.42539633287) | |||
54411 | 54411 | 234398 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 3980 22nd St | 8 | : 4 | Tree 1 | Private 1 | 32 | 6001905.073469999 | 2102956.38941 | 37.7544251823875 | -122.436349651817 | (37.7544251823875, -122.436349651817) | ||||
132990 | 132990 | 234397 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 3932 22nd St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 25 | Width 4ft | 6002267.50929 | 2102984.90864 | 37.7545240763369 | -122.435098296447 | (37.7545240763369, -122.435098296447) | |||
20953 | 20953 | 25048 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 900X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6005066.31799 | 2102985.06573 | 37.7546830360144 | -122.425419283594 | (37.7546830360144, -122.425419283594) | |||
18527 | 18527 | 25047 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 900X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005062.19129 | 2103039.48532 | 37.754832226347396 | -122.425437427413 | (37.7548322263474, -122.425437427413) | |||
158189 | 158189 | 234383 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 3483 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005156.87556 | 2103096.1087599997 | 37.7549930502992 | -122.425114011399 | (37.7549930502992, -122.425114011399) | |||
136550 | 136550 | 186179 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700 Sunset Blvd | 64 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984928.6664 | 2103564.4514 | 37.755115531312704 | -122.49510242297701 | (37.7551155313127, -122.495102422977) | |||
180226 | 180226 | 186180 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984958.094 | 2103565.49 | 37.755120105782204 | -122.49500073187099 | (37.7551201057822, -122.495000731871) | |||
90899 | 90899 | 25044 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 892X Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005007.5951373 | 2103153.9131268 | 37.755143333537205 | -122.425634379859 | (37.7551433335372, -122.425634379859) | |||
114876 | 114876 | 25046 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 892X Dolores St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005007.5951373 | 2103153.9131268 | 37.755143333537205 | -122.425634379859 | (37.7551433335372, -122.425634379859) | |||
124852 | 124852 | 25043 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 892X Dolores St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005007.5951373 | 2103153.9131268 | 37.755143333537205 | -122.425634379859 | (37.7551433335372, -122.425634379859) | |||
17579 | 17579 | 27481 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 850X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/04/1999 12:00:00 AM | 90 | 20 | 6005053.38343 | 2103172.36846 | 37.755196594762 | -122.425477343801 | (37.755196594762, -122.425477343801) | ||
175193 | 175193 | 182680 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2701 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5985854.1638 | 2103629.5919999997 | 37.7553485282392 | -122.491906624733 | (37.7553485282392, -122.491906624733) | |||
61791 | 61791 | 182681 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2701 Moraga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5985882.7747 | 2103629.0901 | 37.75534882242739 | -122.491807644065 | (37.7553488224274, -122.491807644065) | |||
167096 | 167096 | 234328 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 850x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6005051.1738 | 2103243.46642 | 37.7553916882954 | -122.425490044948 | (37.7553916882954, -122.425490044948) | ||||
174328 | 174328 | 234327 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 850x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | 6005045.03345 | 2103276.5066400003 | 37.755482062073604 | -122.425513631455 | (37.7554820620736, -122.425513631455) | ||||
164848 | 164848 | 234326 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 850x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6005043.60607 | 2103360.12702 | 37.755711583428294 | -122.425524518639 | (37.7557115834283, -122.425524518639) | ||||
18925 | 18925 | 25041 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005036.0793699995 | 2103453.27666 | 37.7559669252599 | -122.42555717752899 | (37.7559669252599, -122.425557177529) | |||
19066 | 19066 | 25040 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005037.4743800005 | 2103495.5655400003 | 37.7560831194465 | -122.42555536268499 | (37.7560831194465, -122.425555362685) | |||
60454 | 60454 | 234382 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2624 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6010280.44455 | 2103423.11774 | 37.7561790447523 | -122.40741821967501 | (37.7561790447523, -122.407418219675) | |||
19480 | 19480 | 25039 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005035.06937 | 2103531.66337 | 37.756182099743 | -122.42556624900801 | (37.756182099743, -122.425566249008) | |||
18866 | 18866 | 25038 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005033.4036 | 2103578.1948599997 | 37.756309770193 | -122.425575321353 | (37.756309770193, -122.425575321353) | |||
21891 | 21891 | 25037 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005031.31461 | 2103614.04185 | 37.7564080795924 | -122.425585096976 | (37.7564080795924, -122.425585096976) | |||
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) | |||
32517 | 32517 | 234386 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 800 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6004984.24145 | 2103652.12046 | 37.7565099745835 | -122.42575060280899 | (37.7565099745835, -122.425750602809) | |||
108592 | 108592 | 25034 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 794X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004985.41588 | 2103704.6857762 | 37.7566543729812 | -122.425750282521 | (37.7566543729812, -122.425750282521) | |||
121919 | 121919 | 26536 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 794X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/23/1997 12:00:00 AM | 50 | 20 | 6004985.41588 | 2103704.6857762 | 37.7566543729812 | -122.425750282521 | (37.7566543729812, -122.425750282521) | ||
123535 | 123535 | 25035 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 794X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 20 | 6004985.41588 | 2103704.6857762 | 37.7566543729812 | -122.425750282521 | (37.7566543729812, -122.425750282521) | |||
140592 | 140592 | 26537 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 794X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/23/1997 12:00:00 AM | 20 | 6004985.41588 | 2103704.6857762 | 37.7566543729812 | -122.425750282521 | (37.7566543729812, -122.425750282521) | |||
138553 | 138553 | 116529 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 745X SANCHEZ ST | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6003713.0 | 2103768.0 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | ||||
19629 | 19629 | 25032 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 750X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005021.65336 | 2103769.84125 | 37.756835322312604 | -122.42562959723 | (37.7568353223126, -122.42562959723) | |||
18060 | 18060 | 25021 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 750X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005015.543430001 | 2103801.2681 | 37.7569212678239 | -122.425652964336 | (37.7569212678239, -122.425652964336) | |||
21632 | 21632 | 25036 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 750X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005017.04415 | 2103831.36773 | 37.7570039991458 | -122.42564991650801 | (37.7570039991458, -122.425649916508) | |||
17523 | 17523 | 5503 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 773 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5x5 | 6005056.9343 | 2103834.44184 | 37.757014693887704 | -122.42551217994301 | (37.7570146938877, -122.425512179943) | |||
137503 | 137503 | 234343 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 769 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 7ft | 6005056.066269999 | 2103868.0427200003 | 37.7571069049763 | -122.42551757317601 | (37.7571069049763, -122.425517573176) | |||
174148 | 174148 | 234400 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 4 Corwin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | Width 3ft | 6001132.8816599995 | 2103964.26051 | 37.7571486461001 | -122.439092314277 | (37.7571486461001, -122.439092314277) | |||
19989 | 19989 | 25018 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 750X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005012.95019 | 2103889.3731400003 | 37.757163037054 | -122.42566820334 | (37.757163037054, -122.42566820334) | |||
17311 | 17311 | 25026 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 750X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005011.77925 | 2103932.39938 | 37.7572811108424 | -122.42567531518499 | (37.7572811108424, -122.425675315185) | |||
42292 | 42292 | 234344 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 751 Dolores St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6005051.924 | 2103931.9938 | 37.757282265587 | -122.42553644996299 | (37.757282265587, -122.425536449963) | |||
47741 | 47741 | 194278 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750 22nd St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6012817.610719999 | 2103799.38432 | 37.7573538722899 | -122.398670182286 | (37.7573538722899, -122.398670182286) | ||||
188962 | 188962 | 182197 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1584 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | Width 0ft | 5985008.2078 | 2104414.5267 | 37.7574542590905 | -122.494890024235 | (37.7574542590905, -122.494890024235) | |||
24676 | 24676 | 25027 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 740X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6004958.5167563 | 2104022.9997464 | 37.75752686832129 | -122.425865966748 | (37.7575268683213, -122.425865966748) | |||
69271 | 69271 | 25030 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 740X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004958.5167563 | 2104022.9997464 | 37.75752686832129 | -122.425865966748 | (37.7575268683213, -122.425865966748) | |||
18233 | 18233 | 25024 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005003.848780001 | 2104046.64903 | 37.757594365417496 | -122.42571087345699 | (37.7575943654175, -122.425710873457) | |||
21311 | 21311 | 25022 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004995.79572 | 2104126.38242 | 37.75781283950229 | -122.425744399279 | (37.7578128395023, -122.425744399279) | |||
18700 | 18700 | 25031 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6005006.55303 | 2104135.2293700003 | 37.7578377390251 | -122.425707825673 | (37.7578377390251, -122.425707825673) | |||
19160 | 19160 | 25028 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/23/1997 12:00:00 AM | 70 | 20 | 6005001.93677 | 2104182.12883 | 37.75796625306 | -122.425727128704 | (37.75796625306, -122.425727128704) | ||
63620 | 63620 | 234384 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 899 Hampshire St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6010216.7904900005 | 2104076.88773 | 37.757970587791 | -122.407684453188 | (37.757970587791, -122.407684453188) | |||
77825 | 77825 | 25016 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 710X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004949.2547318 | 2104210.5607702998 | 37.758041343361796 | -122.425911349448 | (37.7580413433618, -122.425911349448) | |||
80924 | 80924 | 25025 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 710X Dolores St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004949.2547318 | 2104210.5607702998 | 37.758041343361796 | -122.425911349448 | (37.7580413433618, -122.425911349448) | |||
85048 | 85048 | 25019 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 710X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004949.2547318 | 2104210.5607702998 | 37.758041343361796 | -122.425911349448 | (37.7580413433618, -122.425911349448) | |||
88715 | 88715 | 25017 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 710X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004949.2547318 | 2104210.5607702998 | 37.758041343361796 | -122.425911349448 | (37.7580413433618, -122.425911349448) | |||
96774 | 96774 | 25020 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 710X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004949.2547318 | 2104210.5607702998 | 37.758041343361796 | -122.425911349448 | (37.7580413433618, -122.425911349448) | |||
17518 | 17518 | 25033 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004995.411590001 | 2104224.22732 | 37.7580814768833 | -122.425752691957 | (37.7580814768833, -122.425752691957) | |||
101187 | 101187 | 5485 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | |||
131012 | 131012 | 234358 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6004991.05597 | 2104342.31446 | 37.7584054702508 | -122.425776160656 | (37.7584054702508, -122.425776160656) | ||||
179789 | 179789 | 234357 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6004986.096919999 | 2104380.3629099997 | 37.758509662101204 | -122.425796019476 | (37.7585096621012, -122.425796019476) | ||||
72691 | 72691 | 234342 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 500 Dolores St | 27 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | Width 6ft | 6004943.9168300005 | 2104413.64545 | 37.7585986644128 | -122.425944266413 | (37.7585986644128, -122.425944266413) | |||
38595 | 38595 | 234356 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6004985.9304599995 | 2104422.99085 | 37.7586266989802 | -122.42579962935301 | (37.7586266989802, -122.425799629353) | ||||
157237 | 157237 | 234355 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6004978.4588 | 2104465.76881 | 37.7587437349524 | -122.425828514675 | (37.7587437349524, -122.425828514675) | ||||
87718 | 87718 | 96830 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004936.0 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | |||
110274 | 110274 | 96826 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004936.0 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | |||
120614 | 120614 | 96829 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004936.0 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | |||
121479 | 121479 | 96828 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004936.0 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | |||
144123 | 144123 | 96827 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004936.0 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | |||
27355 | 27355 | 234354 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6004979.813630001 | 2104508.3497200003 | 37.7588607286626 | -122.425826859935 | (37.7588607286626, -122.425826859935) | ||||
182038 | 182038 | 234353 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 600x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6004972.999969999 | 2104631.70012 | 37.7591990347337 | -122.425859204936 | (37.7591990347337, -122.425859204936) | ||||
95346 | 95346 | 96821 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 610X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | |||
118260 | 118260 | 96823 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 610X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | |||
127732 | 127732 | 96824 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 610X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | |||
128933 | 128933 | 96822 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 610X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | |||
141757 | 141757 | 96825 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 610X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | |||
130698 | 130698 | 234352 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 600x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 45 | 6004969.77736 | 2104678.02917 | 37.7593260612613 | -122.425873648056 | (37.7593260612613, -122.425873648056) | ||||
177827 | 177827 | 234351 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 600x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6004966.99113 | 2104720.1905900002 | 37.759441669116796 | -122.425886285347 | (37.7594416691168, -122.425886285347) | ||||
171635 | 171635 | 234401 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 3899 19th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | Width 3ft | 6003740.055819999 | 2104771.47672 | 37.75951307439 | -122.430133288745 | (37.75951307439, -122.430133288745) | |||
165757 | 165757 | 234350 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 600x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6004963.57632 | 2104757.16703 | 37.759543004714 | -122.425900727537 | (37.759543004714, -122.425900727537) | ||||
161954 | 161954 | 234349 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 600x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | 6004962.28051 | 2104795.65924 | 37.7596486220069 | -122.42590794909599 | (37.7596486220069, -122.425907949096) | ||||
62437 | 62437 | 182268 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1466 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 37 | Width 0ft | 5985290.7143 | 2105238.2671 | 37.759732554956 | -122.493973725026 | (37.759732554956, -122.493973725026) | |||
187792 | 187792 | 210906 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1113 Kirkham St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 5991529.16752 | 2105177.12145 | 37.7599277068135 | -122.47239375186301 | (37.7599277068135, -122.472393751863) | |||
176402 | 176402 | 210907 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1009 Kirkham St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 32 | Width 3ft | 5991740.69924 | 2105187.8933900003 | 37.7599695243799 | -122.47166295830499 | (37.7599695243799, -122.471662958305) | |||
18179 | 18179 | 25015 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 550X Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004955.918219999 | 2104917.6837 | 37.7599833128008 | -122.42593863935 | (37.7599833128008, -122.42593863935) | |||
126077 | 126077 | 51202 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 567 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47573 | 6003673.55383836 | 2104968.22861825 | 37.760049541377796 | -122.43037732338999 | (37.7600495413778, -122.43037732339) |
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");