Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 608 | 608 | 233928 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 8 Octavia St Frontage East | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | Width 8ft | 6005775.18179 | 2109348.30824 | 37.77219502161479 | -122.423420179704 | (37.7721950216148, -122.423420179704) | |||
| 9337 | 9337 | 113319 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 VALENCIA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005986.0 | 2109035.0 | 37.7713466487942 | -122.42266867187 | (37.7713466487942, -122.42266867187) | |||
| 9471 | 9471 | 18535 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 270 PROSPECT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6006489.0 | 2098160.0 | 37.74151478014 | -122.420156839009 | (37.74151478014, -122.420156839009) | |||
| 9735 | 9735 | 173670 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 251x Lathrop Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012236.0 | 2086860.0 | 37.7108094381203 | -122.399492405366 | (37.7108094381203, -122.399492405366) | ||||
| 13733 | 13733 | 29537 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 2600X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6015071.7012 | 2091079.6967 | 37.7225535544976 | -122.38998606447299 | (37.7225535544976, -122.389986064473) | |||
| 14133 | 14133 | 29536 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 2600X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6015127.6919 | 2091149.846 | 37.7227492757118 | -122.38979741293699 | (37.7227492757118, -122.389797412937) | |||
| 14829 | 14829 | 95065 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 4801 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014916.5089 | 2095299.5463 | 37.7341318071091 | -122.390817297505 | (37.7341318071091, -122.390817297505) | |||
| 17598 | 17598 | 9369 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 276 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2x2 | 6001136.50681 | 2098095.27018 | 37.7410340073111 | -122.438659251142 | (37.7410340073111, -122.438659251142) | |||
| 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) | ||
| 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) | |||
| 23714 | 23714 | 234376 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750 Harrison St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6008587.75214 | 2108113.66978 | 37.7689633348285 | -122.41360388622499 | (37.7689633348285, -122.413603886225) | |||
| 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) | |||
| 24075 | 24075 | 194304 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 500 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 6014519.25252 | 2117262.79206 | 37.7944160283404 | -122.393727518235 | (37.7944160283404, -122.393727518235) | |||
| 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) | |||
| 25123 | 25123 | 210904 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1539 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5990882.40967 | 2107206.58351 | 37.7654626131273 | -122.47477868020201 | (37.7654626131273, -122.474778680202) | |||
| 25380 | 25380 | 124656 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1 Presidio Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 7ft | 5995441.43994 | 2115441.36584 | 37.7883362746058 | -122.45960662195401 | (37.7883362746058, -122.459606621954) | |||
| 25705 | 25705 | 234339 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 420 Dolores St | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | Width 3ft | 6004868.93824 | 2105500.74139 | 37.7615793351331 | -122.426280973507 | (37.7615793351331, -122.426280973507) | |||
| 26354 | 26354 | 234378 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1 Bird St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 37 | Width 5ft | 6005998.07456 | 2105729.78745 | 37.7622720010628 | -122.42239202167299 | (37.7622720010628, -122.422392021673) | |||
| 26482 | 26482 | 210923 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1540 Plymouth Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 41 | Width 3ft | 5995839.221390001 | 2094293.33064 | 37.7302920326405 | -122.456700326779 | (37.7302920326405, -122.456700326779) | |||
| 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) | |||
| 28249 | 28249 | 194306 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 500 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6014568.03404 | 2117229.07965 | 37.7943261725661 | -122.393556366426 | (37.7943261725661, -122.393556366426) | |||
| 29021 | 29021 | 234332 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 420 Dolores St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 6004849.34041 | 2105800.52772 | 37.7624013694379 | -122.42637009990601 | (37.7624013694379, -122.426370099906) | |||
| 29139 | 29139 | 194295 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1942 Quesada Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | Width 10ft | 6013443.13195 | 2096013.71128 | 37.7360108970885 | -122.395961290278 | (37.7360108970885, -122.395961290278) | |||
| 30108 | 30108 | 210927 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 234 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | 6000492.41263 | 2094973.31916 | 37.732425199355 | -122.44066241093701 | (37.732425199355, -122.440662410937) | ||||
| 30590 | 30590 | 118002 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 7 Shore View Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5984637.38492 | 2112844.95185 | 37.780580098776795 | -122.49679463074699 | (37.7805800987768, -122.496794630747) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 32528 | 32528 | 247549 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 815 Buena Vista Ave West | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | Width 2ft | 6000106.41756 | 2108406.30035 | 37.7692869261681 | -122.44296119951099 | (37.7692869261681, -122.442961199511) | |||
| 33897 | 33897 | 132069 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 45 Havens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | 6007646.13343 | 2119391.20002 | 37.7998757746973 | -122.417660327771 | (37.7998757746973, -122.417660327771) | ||||
| 34765 | 34765 | 143058 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 426 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 0ft | 6010776.1378 | 2120354.2833 | 37.8026957973236 | -122.406897202115 | (37.8026957973236, -122.406897202115) | |||
| 34789 | 34789 | 119450 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 800 33rd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | 5985749.05602 | 2110390.9661 | 37.7739072286205 | -122.49276808877701 | (37.7739072286205, -122.492768088777) | ||||
| 34895 | 34895 | 67033 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 174 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1992 12:00:00 AM | 30 | 5x5 | Permit Number 30405 | 5992451.37715 | 2114312.24159 | 37.7850636224737 | -122.469869417746 | (37.7850636224737, -122.469869417746) | |
| 35095 | 35095 | 132128 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6014303.114130001 | 2117497.5911 | 37.7950487184753 | -122.39449183764299 | (37.7950487184753, -122.394491837643) | |||
| 35628 | 35628 | 210924 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1540 Plymouth Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 43 | Width 3ft | 5995827.117740001 | 2094309.51389 | 37.730335772973206 | -122.45674334043699 | (37.7303357729732, -122.456743340437) | |||
| 35925 | 35925 | 234399 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 319 Virginia Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | Width 3ft | 6006918.01461 | 2098154.19018 | 37.7415229912067 | -122.418673038125 | (37.7415229912067, -122.418673038125) | |||
| 36940 | 36940 | 233930 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 451 Florida St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | Width 9ft | 6009251.7265800005 | 2106253.20346 | 37.763892184592706 | -122.41117579493 | (37.7638921845927, -122.41117579493) | |||
| 37148 | 37148 | 96681 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 375@32nd Ave 32nd Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | 25 | Permit Number 768040 | 5985880.88078 | 2113443.18167 | 37.7822954478301 | -122.49253691723301 | (37.7822954478301, -122.492536917233) | ||
| 39365 | 39365 | 234337 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 420 Dolores St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | Width 3ft | 6004866.4127400005 | 2105541.3308900003 | 37.7616906415182 | -122.42629259813299 | (37.7616906415182, -122.426292598133) | |||
| 39479 | 39479 | 234374 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 581 Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 9ft | 6004996.87402 | 2105008.5457599997 | 37.760235113069896 | -122.425803460464 | (37.7602351130699, -122.425803460464) | |||
| 39519 | 39519 | 118599 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 249 Point Lobos Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 5981986.20635 | 2112598.8818200002 | 37.7797487653148 | -122.50594791191901 | (37.7797487653148, -122.505947911919) | ||||
| 39528 | 39528 | 194389 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1031 Key Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 36 | 6013123.75243 | 2089902.89375 | 37.7192140640518 | -122.396637279208 | (37.7192140640518, -122.396637279208) | ||||
| 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) | |||
| 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) | |||
| 42394 | 42394 | 201687 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 401 08th St | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6010195.30306 | 2109846.89146 | 37.7738124981919 | -122.408165701983 | (37.7738124981919, -122.408165701983) | ||||
| 42834 | 42834 | 194390 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1031 Key Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | 6013152.66051 | 2089880.8718700001 | 37.719155205216104 | -122.396535811395 | (37.7191552052161, -122.396535811395) | ||||
| 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) | |||
| 43396 | 43396 | 194272 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1022 Minna St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6007547.687530001 | 2109714.25342 | 37.7732997020571 | -122.41731485230801 | (37.7732997020571, -122.417314852308) | |||
| 43567 | 43567 | 194300 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 550 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 5ft | 6014431.69544 | 2117339.12323 | 37.7946207500099 | -122.39403582470699 | (37.7946207500099, -122.394035824707) | |||
| 44771 | 44771 | 234338 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 420 Dolores St | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 37 | Width 3ft | 6004867.72819 | 2105514.5268599996 | 37.761617118366104 | -122.42628614009199 | (37.7616171183661, -122.426286140092) | |||
| 44784 | 44784 | 132123 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6014232.87879 | 2117626.20085 | 37.795397945911205 | -122.394743875326 | (37.7953979459112, -122.394743875326) | |||
| 45534 | 45534 | 124659 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 199 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 37 | Width 8ft | 5995478.86593 | 2115238.56038 | 37.7877815776324 | -122.45946244145901 | (37.7877815776324, -122.459462441459) | |||
| 45951 | 45951 | 132119 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 6014187.59198 | 2117732.03905 | 37.795686034729 | -122.39490799262501 | (37.795686034729, -122.394907992625) | |||
| 46040 | 46040 | 187495 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Walbridge St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6005184.36761 | 2086469.76682 | 37.709342367834395 | -122.423836763664 | (37.7093423678344, -122.423836763664) | ||||
| 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) | |||
| 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) | ||||
| 48105 | 48105 | 118707 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 4201 Balboa St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 2ft | 5982546.62842 | 2110970.49419 | 37.775310661099795 | -122.503888560039 | (37.7753106610998, -122.503888560039) | |||
| 48294 | 48294 | 194299 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 550 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 6014410.76303 | 2117359.45162 | 37.794675403602 | -122.39410967794599 | (37.794675403602, -122.394109677946) | |||
| 48345 | 48345 | 194388 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1031 Key Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 40 | 6013107.94825 | 2089911.6587099999 | 37.7192372512804 | -122.39669252276501 | (37.7192372512804, -122.396692522765) | ||||
| 48420 | 48420 | 187504 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Walbridge St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6005101.69485 | 2086503.71935 | 37.7094309267755 | -122.424124907354 | (37.7094309267755, -122.424124907354) | ||||
| 48507 | 48507 | 118600 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 249 Point Lobos Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 37 | 5981958.17368 | 2112601.6345 | 37.779754673268705 | -122.506045091658 | (37.7797546732687, -122.506045091658) | ||||
| 48676 | 48676 | 210905 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1545 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5990857.32948 | 2107205.82169 | 37.76545906800929 | -122.47486537036501 | (37.7654590680093, -122.474865370365) | |||
| 48989 | 48989 | 233929 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 8 Octavia St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | 6005769.81739 | 2109368.12443 | 37.77224912933389 | -122.42344014465901 | (37.7722491293339, -122.423440144659) | ||||
| 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) | |||
| 53743 | 53743 | 118598 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 249 Point Lobos Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 5982022.838269999 | 2112594.06181 | 37.7797376871414 | -122.50582083083799 | (37.7797376871414, -122.505820830838) | ||||
| 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) | |||
| 54210 | 54210 | 132125 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6014258.525909999 | 2117571.02815 | 37.79524788055 | -122.39465126585199 | (37.79524788055, -122.394651265852) | |||
| 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) | ||||
| 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) | ||||
| 54517 | 54517 | 132120 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 5ft | 6014198.1938 | 2117703.48543 | 37.795608222695996 | -122.394869307388 | (37.795608222696, -122.394869307388) | |||
| 54583 | 54583 | 132068 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 3601 Broderick St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5999659.130480001 | 2120925.06177 | 37.803634670174496 | -122.445408603735 | (37.8036346701745, -122.445408603735) | |||
| 54710 | 54710 | 132121 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6014209.141 | 2117675.2625 | 37.7955313378499 | -122.39482945031999 | (37.7955313378499, -122.39482945032) | |||
| 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) | |||
| 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) | |||
| 56280 | 56280 | 194309 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 380 The Embarcadero | 1 | : 4 | Tree 1 | Private 1 | 24 | Width 7ft | 6015233.93882 | 2116624.33128 | 37.79270265166021 | -122.39120994708 | (37.7927026516602, -122.39120994708) | |||
| 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) | |||
| 58910 | 58910 | 234395 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 217 Ogden Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 6008499.5527 | 2096078.48845 | 37.735912484272205 | -122.413057867339 | (37.7359124842722, -122.413057867339) | |||
| 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) | ||||
| 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) | |||
| 59904 | 59904 | 187497 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Walbridge St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6005151.09396 | 2086478.68565 | 37.7093649785846 | -122.42395239669399 | (37.7093649785846, -122.423952396694) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 62627 | 62627 | 132124 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6014245.1809 | 2117597.9501799997 | 37.7953210601821 | -122.39469932831301 | (37.7953210601821, -122.394699328313) | |||
| 62633 | 62633 | 185382 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2615 34th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | Width 0ft | 5985803.8248 | 2097379.5833 | 37.7381847526444 | -122.491620661903 | (37.7381847526444, -122.491620661903) | |||
| 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) | |||
| 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) | |||
| 64753 | 64753 | 233931 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 451 Florida St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 9ft | 6009251.45318 | 2106264.05651 | 37.763921969247704 | -122.411177507234 | (37.7639219692477, -122.411177507234) | |||
| 66140 | 66140 | 118759 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 544 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 43 | Width 5ft | 5981951.74748 | 2112030.16523 | 37.7781852088244 | -122.50602493975501 | (37.7781852088244, -122.506024939755) | |||
| 68513 | 68513 | 210928 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 617 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 37 | 5997342.33131 | 2095240.63361 | 37.732979290542104 | -122.451572201795 | (37.7329792905421, -122.451572201795) | ||||
| 69742 | 69742 | 210912 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 443 Gennessee St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | 5997433.76219 | 2094954.34243 | 37.732198438902294 | -122.451235463255 | (37.7321984389023, -122.451235463255) | ||||
| 70062 | 70062 | 234377 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750 Harrison St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6008587.9096 | 2108086.3181 | 37.768888242332004 | -122.413601406792 | (37.768888242332, -122.413601406792) | |||
| 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) | |||
| 71126 | 71126 | 194298 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 550 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 5ft | 6014390.53553 | 2117381.11551 | 37.794733763298105 | -122.394181185735 | (37.7947337632981, -122.394181185735) | |||
| 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) | |||
| 72122 | 72122 | 234341 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 420 Dolores St | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | Width 3ft | 6004869.93402 | 2105476.5468200003 | 37.7615129588681 | -122.42627580688401 | (37.7615129588681, -122.426275806884) | |||
| 72198 | 72198 | 245079 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 154 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 38 | Width 0ft | 6000824.0394 | 2109520.8819 | 37.7723881764486 | -122.440558941181 | (37.7723881764486, -122.440558941181) | |||
| 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) | |||
| 73625 | 73625 | 178085 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 210 Tocoloma Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6012726.322790001 | 2087488.8573099999 | 37.712563474091894 | -122.397841808652 | (37.7125634740919, -122.397841808652) | |||
| 76008 | 76008 | 201682 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 401 08th St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6010248.09063 | 2109749.24504 | 37.773547339368704 | -122.40797621303899 | (37.7735473393687, -122.407976213039) |
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");