Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 148568 | 148568 | 176105 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700x Mansell St | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 105 | Width 0ft | 6009225.48687 | 2089982.90412 | 37.7192160263732 | -122.41011780460899 | (37.7192160263732, -122.410117804609) | |||
| 6290 | 6290 | 14424 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 100 | 12 | 5998854.1192 | 2113097.3779 | 37.7820959422738 | -122.44763055563999 | (37.7820959422738, -122.44763055564) | |||
| 7655 | 7655 | 4730 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1175X Columbus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 100 | 3x3 | 6007911.57425 | 2121225.41132 | 37.8049269905411 | -122.41687182377 | (37.8049269905411, -122.41687182377) | |||
| 88522 | 88522 | 13394 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 Marietta Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 100 | 5 | 5999367.9101935 | 2097504.6578797 | 37.7393115562077 | -122.444731949771 | (37.7393115562077, -122.444731949771) | |||
| 118001 | 118001 | 13409 | DPW Maintained 3 | Corymbia citriodora :: Lemon Scented Gum 301 | 364 Marietta Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 100 | 5 | 5999660.108164 | 2097381.7238333 | 37.738990678772396 | -122.443712833155 | (37.7389906787724, -122.443712833155) | |||
| 10449 | 10449 | 98333 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 12X Canyon Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 99 | 6003235.70781 | 2086338.01389 | 37.708870401808205 | -122.43056224915199 | (37.7088704018082, -122.430562249152) | ||||
| 6165 | 6165 | 14421 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 3X3 | 5998843.9665 | 2113055.4136 | 37.7819801389805 | -122.44766265742399 | (37.7819801389805, -122.447662657424) | |||
| 16926 | 16926 | 24992 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 340 Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004882.50848 | 2106257.6214799997 | 37.763658315014204 | -122.426287928865 | (37.7636583150142, -122.426287928865) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 17162 | 17162 | 25069 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005114.64614 | 2102050.12648 | 37.752118640770995 | -122.42518562892599 | (37.752118640771, -122.425185628926) | |||
| 17207 | 17207 | 25101 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 1450X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005235.8244 | 2099843.7861200003 | 37.746067383302496 | -122.424609642834 | (37.7460673833025, -122.424609642834) | |||
| 17252 | 17252 | 24963 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004800.736959999 | 2107633.50365 | 37.7674315357679 | -122.42666873508999 | (37.7674315357679, -122.42666873509) | |||
| 17260 | 17260 | 24994 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 300 Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004873.5625 | 2106448.79257 | 37.7641827195917 | -122.42633248217399 | (37.7641827195917, -122.426332482174) | |||
| 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) | |||
| 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) | |||
| 17442 | 17442 | 25157 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004782.44605 | 2108032.94108 | 37.7685272607631 | -122.42676044975201 | (37.7685272607631, -122.426760449752) | |||
| 17575 | 17575 | 24996 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004898.747380001 | 2105973.30508 | 37.7628785677218 | -122.42621152066002 | (37.7628785677218, -122.42621152066) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 17780 | 17780 | 25133 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 1600X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005290.85076 | 2098882.50869 | 37.743431042298106 | -122.42435100951599 | (37.7434310422981, -122.424351009516) | |||
| 17821 | 17821 | 25151 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004775.21348 | 2108066.2440299997 | 37.768618293721104 | -122.42678783858999 | (37.7686182937211, -122.42678783859) | |||
| 17966 | 17966 | 25063 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005101.20924 | 2102268.05958 | 37.7527162753581 | -122.42524760211501 | (37.7527162753581, -122.425247602115) | |||
| 18053 | 18053 | 24998 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004918.80727 | 2105618.72906 | 37.7619061199926 | -122.426116896691 | (37.7619061199926, -122.426116896691) | |||
| 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) | |||
| 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) | |||
| 18236 | 18236 | 25007 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004931.59557 | 2105384.6255099997 | 37.7612640499245 | -122.426056000898 | (37.7612640499245, -122.426056000898) | |||
| 18263 | 18263 | 25057 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 900X Dolores St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005079.27857 | 2102722.52778 | 37.753962900284904 | -122.425355780639 | (37.7539629002849, -122.425355780639) | |||
| 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) | |||
| 18340 | 18340 | 25152 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 50X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004796.34623 | 2107853.39536 | 37.768035057311 | -122.42669958273999 | (37.768035057311, -122.42669958274) | |||
| 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) | |||
| 18533 | 18533 | 24993 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 300 Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004868.62064 | 2106470.5041400003 | 37.764242055039794 | -122.426351120609 | (37.7642420550398, -122.426351120609) | |||
| 18703 | 18703 | 24975 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 200 Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004832.79825 | 2107115.15692 | 37.76601009251021 | -122.426520926121 | (37.7660100925102, -122.426520926121) | |||
| 18812 | 18812 | 25066 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005105.419480001 | 2102158.55982 | 37.7524158523077 | -122.425225251269 | (37.7524158523077, -122.425225251269) | |||
| 18853 | 18853 | 24967 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 150 Dolores St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004824.658890001 | 2107297.38564 | 37.7665099887808 | -122.42656205570499 | (37.7665099887808, -122.426562055705) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 19185 | 19185 | 25013 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 550X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004948.9055699995 | 2104970.0682099997 | 37.7601267519689 | -122.425966621772 | (37.7601267519689, -122.425966621772) | |||
| 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) | |||
| 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) | |||
| 19325 | 19325 | 25154 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 50X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004786.45589 | 2107937.0696900003 | 37.7682642477152 | -122.42673975183901 | (37.7682642477152, -122.426739751839) | |||
| 19333 | 19333 | 24968 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004810.58196 | 2107534.1310400004 | 37.767159239034704 | -122.426627605497 | (37.7671592390347, -122.426627605497) | |||
| 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) | |||
| 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) | |||
| 19826 | 19826 | 24965 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004804.04595 | 2107595.6918 | 37.767327900586 | -122.42665459683799 | (37.767327900586, -122.426654596838) | |||
| 19960 | 19960 | 25156 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 50X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004792.45266 | 2107880.8578 | 37.768110242434204 | -122.426715006093 | (37.7681102424342, -122.426715006093) | |||
| 20149 | 20149 | 25149 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20x10 | 6004775.29887 | 2108114.09165 | 37.768749676587205 | -122.42679095116002 | (37.7687496765872, -122.42679095116) | |||
| 20197 | 20197 | 25001 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004908.3831400005 | 2105867.13213 | 37.7625875866685 | -122.426170634793 | (37.7625875866685, -122.426170634793) | |||
| 20270 | 20270 | 25000 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004920.85287 | 2105575.60223 | 37.761787819564205 | -122.42610675143801 | (37.7617878195642, -122.426106751438) | |||
| 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) | |||
| 20422 | 20422 | 24978 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 270 Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004857.55515 | 2106727.96369 | 37.764948352008 | -122.42640772573601 | (37.764948352008, -122.426407725736) | |||
| 20452 | 20452 | 24966 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004812.73188 | 2107584.41194 | 37.76729741985871 | -122.426623750096 | (37.7672974198587, -122.426623750096) | |||
| 20630 | 20630 | 24974 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 200 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004833.67989 | 2107139.93189 | 37.7660781684855 | -122.426519640982 | (37.7660781684855, -122.426519640982) | |||
| 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) | |||
| 20697 | 20697 | 24979 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 270 Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004857.886419999 | 2106701.08852 | 37.7648745779366 | -122.426404666261 | (37.7648745779366, -122.426404666261) | |||
| 20703 | 20703 | 24999 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004906.6428 | 2105904.72298 | 37.7626907038434 | -122.42617933032899 | (37.7626907038434, -122.426179330329) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 21462 | 21462 | 25153 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 50X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004788.48534 | 2107965.7019599997 | 37.768342979778204 | -122.426734771418 | (37.7683429797782, -122.426734771418) | |||
| 21480 | 21480 | 24990 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 300 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004865.2254 | 2106541.92962 | 37.7644379804469 | -122.426367949619 | (37.7644379804469, -122.426367949619) | |||
| 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) | |||
| 21589 | 21589 | 25051 | DPW Maintained 3 | Phoenix spp :: Date palm (species unknown) 319 | 900X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005068.020819999 | 2102892.3798700003 | 37.7544286384789 | -122.42540679920799 | (37.7544286384789, -122.425406799208) | |||
| 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) | |||
| 21636 | 21636 | 24991 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 340 Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004880.84753 | 2106292.81252 | 37.763754847342206 | -122.42629617923299 | (37.7637548473422, -122.426296179233) | |||
| 21644 | 21644 | 25132 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 1600X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005290.57321 | 2098924.72185 | 37.743546934357 | -122.42435497101201 | (37.743546934357, -122.424354971012) | |||
| 21785 | 21785 | 25131 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1600X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005285.7039 | 2098966.45887 | 37.74366125975121 | -122.42437477586901 | (37.7436612597512, -122.424374775869) | |||
| 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) | |||
| 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) | |||
| 21954 | 21954 | 25134 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 1600X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005292.60846 | 2098839.2697400004 | 37.7433124172319 | -122.424341857108 | (37.7433124172319, -122.424341857108) | |||
| 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) | |||
| 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) | |||
| 21999 | 21999 | 25056 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 900X Dolores St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005074.95095 | 2102753.03228 | 37.7540464140318 | -122.42537291722999 | (37.7540464140318, -122.42537291723) | |||
| 22009 | 22009 | 24961 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2005 12:00:00 AM | 90 | 20 | 6004800.95891 | 2107734.51921 | 37.76770891277079 | -122.42667516163999 | (37.7677089127708, -122.42667516164) | ||
| 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) | |||
| 27176 | 27176 | 24980 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 292 Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004817.953366901 | 2106647.0197827998 | 37.7647238606763 | -122.42653893424699 | (37.7647238606763, -122.426538934247) | |||
| 82856 | 82856 | 25006 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 470X Dolores St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004864.935087999 | 2105663.9116336997 | 37.762027135623605 | -122.426306436493 | (37.7620271356236, -122.426306436493) | |||
| 82993 | 82993 | 24964 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 198 Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004804.6555297 | 2107199.7616194002 | 37.766240805753604 | -122.426624291348 | (37.7662408057536, -122.426624291348) | |||
| 86637 | 86637 | 24981 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 292 Dolores St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004817.953366901 | 2106647.0197827998 | 37.7647238606763 | -122.42653893424699 | (37.7647238606763, -122.426538934247) | |||
| 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) | |||
| 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) | |||
| 92821 | 92821 | 25014 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X Dolores St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004896.4850004995 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | |||
| 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) | |||
| 100281 | 100281 | 24985 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 292 Dolores St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004817.953366901 | 2106647.0197827998 | 37.7647238606763 | -122.42653893424699 | (37.7647238606763, -122.426538934247) | |||
| 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) | |||
| 108461 | 108461 | 24995 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 398 Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004868.194201699 | 2106023.8985612 | 37.7630157583963 | -122.42632079587099 | (37.7630157583963, -122.426320795871) | |||
| 109140 | 109140 | 25155 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 60X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004737.5115877995 | 2107959.1242988 | 37.768322037027 | -122.426910616409 | (37.768322037027, -122.426910616409) | |||
| 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) | |||
| 113614 | 113614 | 24982 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 292 Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004817.953366901 | 2106647.0197827998 | 37.7647238606763 | -122.42653893424699 | (37.7647238606763, -122.426538934247) | |||
| 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) |
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");