Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, PlantDate, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11148 | 11148 | 20065 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 STAIRWAY54 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 15ST | ||||||||
15304 | 15304 | 19794 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 STAIRWAY19 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 50ST | ||||||||
138478 | 138478 | 24290 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 386 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X17 | 6000963.19469 | 2086697.3561200001 | 37.709728074949204 | -122.43844208303699 | (37.7097280749492, -122.438442083037) | |||
32439 | 32439 | 194391 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 828x Jamestown Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | Width 5ft | 6014866.8225 | 2088973.5540099998 | 37.7167591360948 | -122.39054719349899 | (37.7167591360948, -122.390547193499) | |||
30035 | 30035 | 194392 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 860x Jamestown Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 5ft | 6014755.052209999 | 2089115.5775900001 | 37.7171429037943 | -122.39094345187799 | (37.7171429037943, -122.390943451878) | |||
151174 | 151174 | 194393 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 860x Jamestown Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 5ft | 6014647.11529 | 2089218.63866 | 37.7174198994758 | -122.391323741894 | (37.7174198994758, -122.391323741894) | |||
41784 | 41784 | 194394 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 920x Jamestown Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | Width 5ft | 6014490.42947 | 2089308.0420799998 | 37.717656686497506 | -122.39187158462799 | (37.7176566864975, -122.391871584628) | |||
183995 | 183995 | 194395 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 920x Jamestown Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 5ft | 6014427.53162 | 2089348.9061599998 | 37.7177653992236 | -122.392091851971 | (37.7177653992236, -122.392091851971) | |||
80229 | 80229 | 18563 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.39122125893199 | (37.7333138733401, -122.391221258932) | |||
85028 | 85028 | 18558 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.39122125893199 | (37.7333138733401, -122.391221258932) | |||
86395 | 86395 | 18554 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.39122125893199 | (37.7333138733401, -122.391221258932) | |||
13621 | 13621 | 18556 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014603.96741 | 2095108.67042 | 37.7335903547148 | -122.391884517749 | (37.7335903547148, -122.391884517749) | |||
16559 | 16559 | 18559 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014565.4208 | 2095135.4289 | 37.733661688034104 | -122.392019656183 | (37.7336616880341, -122.392019656183) | |||
14049 | 14049 | 18560 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014546.06488 | 2095149.2171099999 | 37.7336984729967 | -122.392087539714 | (37.7336984729967, -122.392087539714) | |||
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) | ||||
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) | ||||
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) | ||||
107507 | 107507 | 96673 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1449 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6014955.39834 | 2095258.9558 | 37.7340225115191 | -122.390680007822 | (37.7340225115191, -122.390680007822) | |||
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) | ||||
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) | ||||
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) | ||||
80018 | 80018 | 25143 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1798X Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 20 | 6005303.475850901 | 2097774.014097 | 37.740388080432204 | -122.42422853472999 | (37.7403880804322, -122.42422853473) | |||
99831 | 99831 | 25146 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1798X Dolores St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 20 | 6005303.475850901 | 2097774.014097 | 37.740388080432204 | -122.42422853472999 | (37.7403880804322, -122.42422853473) | |||
103351 | 103351 | 25147 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1798X Dolores St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005303.475850901 | 2097774.014097 | 37.740388080432204 | -122.42422853472999 | (37.7403880804322, -122.42422853473) | |||
113894 | 113894 | 25144 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1798X Dolores St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 20 | 6005303.475850901 | 2097774.014097 | 37.740388080432204 | -122.42422853472999 | (37.7403880804322, -122.42422853473) | |||
122371 | 122371 | 25145 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1798X Dolores St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005303.475850901 | 2097774.014097 | 37.740388080432204 | -122.42422853472999 | (37.7403880804322, -122.42422853473) | |||
19402 | 19402 | 25141 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005346.329580001 | 2097965.45382 | 37.740916150253604 | -122.424093974258 | (37.7409161502536, -122.424093974258) | |||
19258 | 19258 | 25140 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005337.960390001 | 2097982.3892099997 | 37.74096217846979 | -122.424124115947 | (37.7409621784698, -122.424124115947) | |||
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) | ||||
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) | ||||
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) | ||||
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) | |||||
78381 | 78381 | 23674 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 319 Virginia Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 12 | 6006936.2458165 | 2098250.5638735 | 37.741788638281996 | -122.418616833275 | (37.741788638282, -122.418616833275) | |||
17005 | 17005 | 25139 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005326.84877 | 2098252.91312 | 37.741704348480795 | -122.42418177058599 | (37.7417043484808, -122.424181770586) | |||
21419 | 21419 | 25138 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005319.278030001 | 2098285.9295200002 | 37.7417945765605 | -122.424210295287 | (37.7417945765605, -122.424210295287) | |||
20678 | 20678 | 25137 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005325.6404800005 | 2098301.13362 | 37.7418366828201 | -122.424189377061 | (37.7418366828201, -122.424189377061) | |||
17024 | 17024 | 25136 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005320.97591 | 2098341.7574 | 37.741947963130706 | -122.424208394127 | (37.7419479631307, -122.424208394127) | |||
19284 | 19284 | 25135 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005318.690690001 | 2098391.09531 | 37.742083304809206 | -122.424219803815 | (37.7420833048092, -122.424219803815) | |||
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) | ||||
18061 | 18061 | 25129 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1650X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005306.59795 | 2098578.64869 | 37.7425976010056 | -122.424274952941 | (37.7425976010056, -122.424274952941) | |||
19082 | 19082 | 25127 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1650X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005306.7238300005 | 2098611.50649 | 37.7426878281697 | -122.424276854096 | (37.7426878281697, -122.424276854096) | |||
21602 | 21602 | 25126 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1650X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005303.102530001 | 2098649.37036 | 37.7427915892743 | -122.424292067924 | (37.7427915892743, -122.424292067924) | |||
18142 | 18142 | 13388 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 218 Marietta Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 5 | 5997667.5215300005 | 2098758.8322 | 37.7426580336411 | -122.45070150968999 | (37.7426580336411, -122.45070150969) | |||
17398 | 17398 | 5707 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1600 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6005241.864159999 | 2098983.9941 | 37.74370693182271 | -122.424527610259 | (37.7437069318227, -122.424527610259) | |||
18284 | 18284 | 25123 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1550 Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005274.82817 | 2099143.28527 | 37.744146170621704 | -122.424424956245 | (37.7441461706217, -122.424424956245) | |||
19053 | 19053 | 25122 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1550 Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005275.20405 | 2099188.4733700003 | 37.7442702680707 | -122.42442687003 | (37.7442702680707, -122.42442687003) | |||
20326 | 20326 | 25115 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1550X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005272.16967 | 2099229.32207 | 37.7443822579348 | -122.424440267208 | (37.7443822579348, -122.424440267208) | |||
21512 | 21512 | 25120 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1550 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005269.99247 | 2099258.02767 | 37.744460954018 | -122.424449836913 | (37.744460954018, -122.424449836913) | |||
109462 | 109462 | 25117 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1548X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005242.6409807 | 2099315.8732106998 | 37.7446182400704 | -122.42454852673201 | (37.7446182400704, -122.424548526732) | |||
16918 | 16918 | 25119 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6005258.69008 | 2099408.1764 | 37.7448725899054 | -122.42449959638999 | (37.7448725899054, -122.42449959639) | |||
21986 | 21986 | 25118 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005257.61936 | 2099436.85892 | 37.74495128509079 | -122.42450533857 | (37.7449512850908, -122.42450533857) | |||
18928 | 18928 | 25116 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005256.05434 | 2099495.31423 | 37.7451117016422 | -122.42451490734301 | (37.7451117016422, -122.424514907343) | |||
18585 | 18585 | 25121 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500 Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20 | 6005252.19486 | 2099522.95164 | 37.745187369700105 | -122.424530218294 | (37.7451873697001, -122.424530218294) | |||
17235 | 17235 | 708 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1504X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/06/2015 02:27:00 PM | 3 | 6x6 | 6005213.6425 | 2099570.03766 | 37.745314479891896 | -122.42466687479799 | (37.7453144798919, -122.424666874798) | ||
86700 | 86700 | 25109 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1496 Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005218.8222955 | 2099617.195839 | 37.7454442580108 | -122.424652317948 | (37.7454442580108, -122.424652317948) | |||
22048 | 22048 | 25106 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1450X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005241.17775 | 2099713.8788799997 | 37.74571099007721 | -122.424581892451 | (37.7457109900772, -122.424581892451) | |||
19857 | 19857 | 5683 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1488 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/08/1997 12:00:00 AM | 12 | 6 | 6005201.38668 | 2099720.6305299997 | 37.745727281286705 | -122.42471996446301 | (37.7457272812867, -122.424719964463) | ||
20817 | 20817 | 25112 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1450 Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005235.506709999 | 2099747.61613 | 37.7458033045753 | -122.42460390154699 | (37.7458033045753, -122.424603901547) | |||
21855 | 21855 | 25111 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1450 Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005242.59316 | 2099769.2409599996 | 37.745863081619895 | -122.424580935573 | (37.7458630816199, -122.424580935573) | |||
20892 | 20892 | 25110 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1450 Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005236.31225 | 2099800.23492 | 37.7459478292265 | -122.42460485845301 | (37.7459478292265, -122.424604858453) | |||
21388 | 21388 | 25107 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005229.6240300005 | 2099972.88313 | 37.7464215039571 | -122.424640264758 | (37.7464215039571, -122.424640264758) | |||
17078 | 17078 | 25113 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400 Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6005228.94357 | 2100007.06865 | 37.7465153311328 | -122.424645049125 | (37.7465153311328, -122.424645049125) | |||
17629 | 17629 | 25102 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005226.05485 | 2100086.94121 | 37.7467344797311 | -122.424660718923 | (37.7467344797311, -122.424660718923) | |||
17004 | 17004 | 25108 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6005223.671490001 | 2100130.84124 | 37.7468548845426 | -122.424672082757 | (37.7468548845426, -122.424672082757) | |||
117928 | 117928 | 25097 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1388X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005167.2006822 | 2100254.8047856004 | 37.747192070496 | -122.424876171578 | (37.747192070496, -122.424876171578) | |||
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) | ||||
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) | ||||
17487 | 17487 | 25100 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1350X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 20 | 6005208.528519999 | 2100314.21379 | 37.7473575282405 | -122.424737488671 | (37.7473575282405, -122.424737488671) | |||
19964 | 19964 | 703 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1375X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6005257.21277 | 2100319.77841 | 37.747375556949 | -122.424569537574 | (37.747375556949, -122.424569537574) | |||
17756 | 17756 | 25098 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1350X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005207.855169999 | 2100363.5353099997 | 37.7474929157794 | -122.424743325238 | (37.7474929157794, -122.424743325238) | |||
19687 | 19687 | 25091 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1350 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005204.68058 | 2100428.03656 | 37.7476698420965 | -122.42475889070299 | (37.7476698420965, -122.424758890703) | |||
106112 | 106112 | 25094 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1348 Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005177.2486108 | 2100480.3758406 | 37.747812004334705 | -122.424857472056 | (37.7478120043347, -122.424857472056) | |||
20790 | 20790 | 25095 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300 Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005196.77931 | 2100544.39428 | 37.7479888873864 | -122.424794489489 | (37.7479888873864, -122.424794489489) | |||
17425 | 17425 | 25099 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005195.84744 | 2100584.78774 | 37.7480997459068 | -122.42480058509899 | (37.7480997459068, -122.424800585099) | |||
21503 | 21503 | 25093 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300 Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005193.32199 | 2100633.40551 | 37.7482330964805 | -122.424812776293 | (37.7482330964805, -122.424812776293) | |||
20879 | 20879 | 25092 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300 Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005189.02223 | 2100681.47449 | 37.7483648399821 | -122.424831064022 | (37.7483648399821, -122.424831064022) | |||
17620 | 17620 | 25096 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005188.030230001 | 2100718.94336 | 37.748467664846295 | -122.42483715961001 | (37.7484676648463, -122.42483715961) | |||
17276 | 17276 | 25090 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1250X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005182.99372 | 2100845.43458 | 37.7488146961375 | -122.424863573617 | (37.7488146961375, -122.424863573617) | |||
21135 | 21135 | 25089 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1250X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005180.26353 | 2100884.10883 | 37.748920732509 | -122.424875765702 | (37.748920732509, -122.424875765702) | |||
19587 | 19587 | 25088 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1250X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005178.85274 | 2100929.77786 | 37.7490460494561 | -122.424883892899 | (37.7490460494561, -122.424883892899) | |||
20929 | 20929 | 25087 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1250X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005179.035519999 | 2100967.22192 | 37.7491488725392 | -122.42488592444401 | (37.7491488725392, -122.424885924444) | |||
17792 | 17792 | 25085 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005165.443630001 | 2101134.8464599997 | 37.7496083631354 | -122.424944849843 | (37.7496083631354, -122.424944849843) | |||
17316 | 17316 | 25084 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005164.22411 | 2101175.53736 | 37.7497200220711 | -122.42495196167499 | (37.7497200220711, -122.424951961675) | |||
21959 | 21959 | 25083 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005162.35719 | 2101213.31575 | 37.74982364735521 | -122.424961105075 | (37.7498236473552, -122.424961105075) | |||
20716 | 20716 | 25082 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005158.72228 | 2101250.83835 | 37.7499264704292 | -122.424976344106 | (37.7499264704292, -122.424976344106) | |||
81675 | 81675 | 25075 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1198 DOLORES ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005087.7 | 2101404.7 | 37.7503449269028 | -122.425232889951 | (37.7503449269028, -122.425232889951) | |||
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) | ||||
92759 | 92759 | 25076 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1184 DOLORES ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005073.9 | 2101453.9 | 37.750479239095604 | -122.42528411198299 | (37.7504792390956, -122.425284111983) | |||
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) | ||||
93699 | 93699 | 25077 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1178 DOLORES ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005072.5 | 2101478.6 | 37.750546980486895 | -122.42529071074 | (37.7505469804869, -122.42529071074) | |||
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) | ||||
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) | ||||
121975 | 121975 | 25078 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1166 DOLORES ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005069.8 | 2101528.7 | 37.7506843909536 | -122.42530361228901 | (37.7506843909536, -122.425303612289) | |||
85336 | 85336 | 25079 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1162 DOLORES ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005068.3 | 2101554.8 | 37.7507559707678 | -122.42531065650499 | (37.7507559707678, -122.425310656505) | |||
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) | ||||
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) | ||||
100172 | 100172 | 25080 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1156 DOLORES ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005077.9 | 2101580.2 | 37.7508262556468 | -122.425279266089 | (37.7508262556468, -122.425279266089) | |||
20762 | 20762 | 25074 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005132.37065 | 2101712.1567700002 | 37.751191655576 | -122.425100289545 | (37.751191655576, -122.425100289545) |
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");