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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 63387 | 63387 | 210922 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 380 Kingston St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | Width 4ft | 5994038.377230001 | 2099205.2198900003 | 37.7436752972852 | -122.463282329909 | (37.7436752972852, -122.463282329909) | |||
| 174857 | 174857 | 234391 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1600 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6005241.74432 | 2098978.16752 | 37.743690926593295 | -122.424527610268 | (37.7436909265933, -122.424527610268) | |||
| 23789 | 23789 | 234390 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1600 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6005245.617219999 | 2098983.50062 | 37.7437057887861 | -122.42451459797199 | (37.7437057887861, -122.424514597972) | |||
| 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) | |||
| 43303 | 43303 | 210921 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 380 Kingston St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 37 | Width 4ft | 5994023.0507 | 2099217.557 | 37.7437082889086 | -122.46333622000601 | (37.7437082889086, -122.463336220006) | |||
| 142373 | 142373 | 87850 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 94 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50753 | 5997405.9 | 2099153.7 | 37.7437272652603 | -122.45163459365601 | (37.7437272652603, -122.451634593656) | |||
| 151219 | 151219 | 210920 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 380 Kingston St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 37 | Width 4ft | 5994018.2668699995 | 2099229.1721099997 | 37.7437399054734 | -122.463353603909 | (37.7437399054734, -122.463353603909) | |||
| 123442 | 123442 | 210919 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 380 Kingston St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 37 | Width 4ft | 5994015.85922 | 2099234.22929 | 37.7437536525071 | -122.463362295833 | (37.7437536525071, -122.463362295833) | |||
| 57644 | 57644 | 210918 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 380 Kingston St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 37 | Width 4ft | 5994017.59782 | 2099245.20708 | 37.7437838949233 | -122.463357080672 | (37.7437838949233, -122.463357080672) | |||
| 162688 | 162688 | 210917 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 380 Kingston St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 37 | Width 4ft | 5994023.9222099995 | 2099259.0924400003 | 37.7438223849926 | -122.46333621999399 | (37.7438223849926, -122.463336219994) | |||
| 159196 | 159196 | 210916 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 587 Dewey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 38 | Width 4ft | 5994027.5569 | 2099288.55437 | 37.7439034894442 | -122.46332578967 | (37.7439034894442, -122.46332578967) | |||
| 131685 | 131685 | 210910 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 151 Garcia Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5994660.64772 | 2099277.20114 | 37.743908769387005 | -122.461135900907 | (37.743908769387, -122.461135900907) | |||
| 70473 | 70473 | 210915 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 587 Dewey Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 38 | Width 4ft | 5994038.34106 | 2099299.34237 | 37.743933731866605 | -122.463289283487 | (37.7439337318666, -122.463289283487) | |||
| 24453 | 24453 | 185441 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985106.1344 | 2099492.3058 | 37.7439449206951 | -122.49418856991899 | (37.7439449206951, -122.494188569919) | |||
| 157052 | 157052 | 210909 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 151 Garcia Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5994659.02084 | 2099296.69557 | 37.7439622025921 | -122.46114293900601 | (37.7439622025921, -122.461142939006) | |||
| 76588 | 76588 | 247039 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 574 Valley St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | Width 6ft | 6002246.4280199995 | 2099186.76685 | 37.7440940809725 | -122.43489959305 | (37.7440940809725, -122.43489959305) | |||
| 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) | |||
| 163198 | 163198 | 234393 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1557 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003994.29589 | 2099192.81462 | 37.7442097715744 | -122.42885628561001 | (37.7442097715744, -122.42885628561) | |||
| 23525 | 23525 | 187316 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2200 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5985075.4607 | 2099608.8478 | 37.744263118481705 | -122.494303219592 | (37.7442631184817, -122.494303219592) | |||
| 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) | |||
| 28217 | 28217 | 210914 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 317 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 3ft | 5993048.097569999 | 2099658.5212 | 37.744862847537206 | -122.46673939310301 | (37.7448628475372, -122.466739393103) | |||
| 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) | |||
| 39811 | 39811 | 234396 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1351 Douglass St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 6ft | 6001401.68154 | 2099734.75899 | 37.74555073898829 | -122.43785977451701 | (37.7455507389883, -122.437859774517) | |||
| 54191 | 54191 | 234389 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1488 Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 6ft | 6005200.95707 | 2099699.7446 | 37.7456699090375 | -122.424719964457 | (37.7456699090375, -122.424719964457) | |||
| 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) | |||
| 20932 | 20932 | 5679 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1470 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2003 12:00:00 AM | 6 | 3x3 | 6005190.57812 | 2099817.1721900003 | 37.7459917521253 | -122.424764205708 | (37.7459917521253, -122.424764205708) | ||
| 149136 | 149136 | 234366 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 9 Duncan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006381.599330001 | 2099941.08815 | 37.746399194477206 | -122.420654601644 | (37.7463991944772, -122.420654601644) | |||
| 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) | ||||
| 185824 | 185824 | 234392 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1379 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 7ft | 6005257.78896 | 2100266.47383 | 37.7472292273428 | -122.424563754022 | (37.7472292273428, -122.424563754022) | |||
| 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) | |||
| 182456 | 182456 | 234394 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1350 Noe St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 6003187.2989 | 2100371.4904099996 | 37.7474004312881 | -122.431730842629 | (37.7474004312881, -122.431730842629) | ||||
| 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) | |||
| 59423 | 59423 | 194280 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Tulare St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6016126.44291 | 2100241.55687 | 37.747768618243605 | -122.38697869801202 | (37.7477686182436, -122.386978698012) | ||||
| 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) | |||
| 181517 | 181517 | 194279 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Tulare St | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6016113.78589 | 2100276.91255 | 37.7478649967659 | -122.387024931273 | (37.7478649967659, -122.387024931273) | ||||
| 54301 | 54301 | 194281 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Tulare St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | 6016211.24922 | 2100302.5214299997 | 37.7479407097974 | -122.38668969007601 | (37.7479407097974, -122.386689690076) | ||||
| 151716 | 151716 | 194282 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Tulare St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6016226.55416 | 2100307.94064 | 37.7479564371431 | -122.386637143603 | (37.7479564371431, -122.386637143603) | ||||
| 31219 | 31219 | 194283 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Tulare St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 44 | 6016255.79944 | 2100318.37917 | 37.747986718206604 | -122.386536741486 | (37.7479867182066, -122.386536741486) | ||||
| 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) | |||
| 188102 | 188102 | 234372 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 3782 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 3ft | 6005314.45638 | 2100807.30331 | 37.74871742098671 | -122.424406263843 | (37.7487174209867, -122.424406263843) | |||
| 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) | |||
| 47083 | 47083 | 186006 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1900 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985010.9219 | 2101633.2915 | 37.7498179124605 | -122.494675598244 | (37.7498179124605, -122.494675598244) | |||
| 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) | |||
| 32150 | 32150 | 186007 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1900 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985000.2752 | 2101640.5507 | 37.749837221065 | -122.49471294958 | (37.749837221065, -122.49471294958) | |||
| 52544 | 52544 | 186008 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1900 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985026.892000001 | 2101640.0667 | 37.749837450044495 | -122.494620873169 | (37.7498374500445, -122.494620873169) | |||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | |||
| 18230 | 18230 | 25073 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005132.2187 | 2101761.89405 | 37.7513282140435 | -122.42510435359199 | (37.7513282140435, -122.425104353592) | |||
| 21721 | 21721 | 25072 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005130.36391 | 2101800.2565200003 | 37.751433443721 | -122.425113497011 | (37.751433443721, -122.425113497011) | |||
| 16962 | 16962 | 25071 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005127.376540001 | 2101840.69033 | 37.751544296835206 | -122.42512670443001 | (37.7515442968352, -122.42512670443) | |||
| 18432 | 18432 | 25070 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005125.726319999 | 2101888.99536 | 37.751676838028395 | -122.425135847862 | (37.7516768380284, -122.425135847862) |
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");