Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2252 | 2252 | 252990 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 52 Pierce St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 2x8 | 6002925.0 | 2108585.0 | 37.7699378868501 | -122.433224642796 | (37.7699378868501, -122.433224642796) | ||||
| 3368 | 3368 | 253427 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2 09th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | ||||
| 3369 | 3369 | 253425 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2 09th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | ||||
| 3370 | 3370 | 253423 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | ||||
| 3380 | 3380 | 253426 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2 09th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | ||||
| 5256 | 5256 | 253838 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1458 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5.5x4 | 5981900.0 | 2105162.0 | 37.759324170949604 | -122.505694672765 | (37.7593241709496, -122.505694672765) | |||
| 8287 | 8287 | 47845 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 8319 | 8319 | 47848 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 9991 | 9991 | 34375 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 157 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38127 | 6003918.97921609 | 2097483.80532691 | 37.7395129612854 | -122.428994891637 | (37.7395129612854, -122.428994891637) | ||
| 12078 | 12078 | 47847 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 12229 | 12229 | 47849 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 12714 | 12714 | 47846 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 16207 | 16207 | 47844 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 18031 | 18031 | 96327 | Significant Tree 6 | Cordyline australis :: Dracena Palm 141 | 296 Randall St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 767829 | 6003708.0 | 2097940.0 | 37.7407536226533 | -122.429756895294 | (37.7407536226533, -122.429756895294) | ||||
| 18680 | 18680 | 122353 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 155 Appleton Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006071.0 | 2097171.0 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | ||||
| 30540 | 30540 | 37494 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1050 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39963 | 5991661.12122197 | 2105245.54821547 | 37.7601232248942 | -122.47194237971901 | (37.7601232248942, -122.471942379719) | ||
| 51436 | 51436 | 38304 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 2000 Folsom St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.765290989194895 | -122.415396349695 | (37.7652909891949, -122.415396349695) | ||
| 53180 | 53180 | 52915 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3017th ST Ord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/2006 12:00:00 AM | Permit Number 48903 | 6000815.25066305 | 2106175.88788155 | 37.7632031545323 | -122.44034940790199 | (37.7632031545323, -122.440349407902) | |||
| 56275 | 56275 | 87953 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 495 Harkness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50978 | 6010151.0 | 2089645.9 | 37.7183425147467 | -122.406894902171 | (37.7183425147467, -122.406894902171) | ||
| 75291 | 75291 | 38313 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 2000 Folsom St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.765290989194895 | -122.415396349695 | (37.7652909891949, -122.415396349695) | ||
| 76396 | 76396 | 38314 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 2000 Folsom St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.765290989194895 | -122.415396349695 | (37.7652909891949, -122.415396349695) | ||
| 77802 | 77802 | 34649 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1735 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 40399 | 5987784.82467276 | 2103483.81569075 | 37.755060924081896 | -122.485219205847 | (37.7550609240819, -122.485219205847) | ||
| 77886 | 77886 | 39818 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 2101 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/1999 12:00:00 AM | Permit Number 41148 | 5981978.01419846 | 2100783.80216684 | 37.7473074654157 | -122.505100399713 | (37.7473074654157, -122.505100399713) | |||
| 79153 | 79153 | 100847 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Estero Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 79464 | 79464 | 84884 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 2895 HARRISON St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2007 12:00:00 AM | Permit No. 49261 | 6009003.0 | 2101605.0 | 37.7511153190475 | -122.41170761434401 | (37.7511153190475, -122.411707614344) | |||
| 80879 | 80879 | 45274 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 635 Crescent Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44117 | 6007835.54663504 | 2095717.89639114 | 37.734885079654 | -122.415328087742 | (37.734885079654, -122.415328087742) | ||
| 81792 | 81792 | 85021 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 299 Maywood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994525.0 | 2094707.0 | 37.7313523209144 | -122.46127371080699 | (37.7313523209144, -122.461273710807) | |||||
| 81862 | 81862 | 43115 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 200 Appleton Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/13/2003 12:00:00 AM | Permit Number 42938 | 6005863.0139999995 | 2096788.574 | 37.7377138611244 | -122.422223875233 | (37.7377138611244, -122.422223875233) | ||
| 82212 | 82212 | 31943 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1300 La Playa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 3x3 | Permit Number 767126 | 5980916.9213303 | 2106151.77480086 | 37.761983899941 | -122.50916807626999 | (37.761983899941, -122.50916807627) | |
| 82793 | 82793 | 95708 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 277 Athens St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767467 | 6004392.0 | 2091652.0 | 37.7235268927559 | -122.42694415274201 | (37.7235268927559, -122.426944152742) | ||
| 84154 | 84154 | 100531 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 689 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003067.0 | 2104228.0 | 37.7579826742399 | -122.432422230009 | (37.7579826742399, -122.432422230009) | ||||
| 85007 | 85007 | 39841 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3151 Ortega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.751379430941896 | -122.49724128025 | (37.7513794309419, -122.49724128025) | ||
| 85547 | 85547 | 105002 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3418 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | Permit Number 768912 | 6006889.6 | 2100911.6 | 37.7490926180804 | -122.41896681303899 | (37.7490926180804, -122.418966813039) | |||
| 85976 | 85976 | 101171 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 420 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002934.0 | 2105795.0 | 37.7622777366985 | -122.432994152167 | (37.7622777366985, -122.432994152167) | ||||
| 87119 | 87119 | 112572 | Significant Tree 6 | Cordyline australis :: Dracena Palm 141 | 162 GRAND VIEW AVE | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6000754.0 | 2103380.0 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | ||||
| 88355 | 88355 | 39819 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 2101 46th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/1999 12:00:00 AM | Permit Number 41148 | 5981978.01419846 | 2100783.80216684 | 37.7473074654157 | -122.505100399713 | (37.7473074654157, -122.505100399713) | |||
| 88393 | 88393 | 48360 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 246 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45771 | 6003531.328367599 | 2101591.65736703 | 37.7507702195134 | -122.430628266841 | (37.7507702195134, -122.430628266841) | |||
| 88738 | 88738 | 84911 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 5546 Anza St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2007 12:00:00 AM | Permit No. 49266 | 5981488.0 | 2111676.0 | 37.77718546664779 | -122.507602896513 | (37.7771854666478, -122.507602896513) | |||
| 89829 | 89829 | 48635 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1436 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45929 | 5990866.95707843 | 2105617.12188587 | 37.761097481488 | -122.474716107382 | (37.761097481488, -122.474716107382) | ||
| 90911 | 90911 | 87089 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 2533 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50041 | 5999658.0 | 2117512.0 | 37.7942632496373 | -122.445166988043 | (37.7942632496373, -122.445166988043) | |||
| 92494 | 92494 | 92495 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3626 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2009 12:00:00 AM | 3x3 | Permit Number 52865 | 5981730.0 | 2097424.0 | 37.7380677850415 | -122.505708970967 | (37.7380677850415, -122.505708970967) | |
| 93049 | 93049 | 84597 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 495 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50978 | 6010148.19523638 | 2089662.82896813 | 37.7183888412655 | -122.406905789617 | (37.7183888412655, -122.406905789617) | ||
| 93565 | 93565 | 44342 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 187 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53500 | 6009836.45355968 | 2099988.51839254 | 37.7467235364285 | -122.40871140598699 | (37.7467235364285, -122.408711405987) | ||
| 93688 | 93688 | 92427 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1601 39th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52817 | 5984021.0 | 2104223.4 | 37.75687164036479 | -122.49829001409701 | (37.7568716403648, -122.498290014097) | |
| 94222 | 94222 | 92433 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 2367 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52823 | 5983266.6 | 2099037.7 | 37.7425888819276 | -122.50051554919399 | (37.7425888819276, -122.500515549194) | |
| 94939 | 94939 | 96910 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1399X 48TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2011 12:00:00 AM | 3x3 | Permit Number 768110 | 5981210.0 | 2105881.0 | 37.7612577047615 | -122.50813435133699 | (37.7612577047615, -122.508134351337) | ||
| 96402 | 96402 | 39743 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3944 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41110 | 6002294.13129656 | 2103577.97626079 | 37.7561540096169 | -122.435048644634 | (37.7561540096169, -122.435048644634) | ||
| 96421 | 96421 | 94199 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 355 Ocean Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53723 | 5999419.6 | 2091436.9 | 37.7226538624451 | -122.444117342662 | (37.7226538624451, -122.444117342662) | |||
| 97243 | 97243 | 52914 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3017th ST Ord St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/2006 12:00:00 AM | Permit Number 48903 | 6000815.25066305 | 2106175.88788155 | 37.7632031545323 | -122.44034940790199 | (37.7632031545323, -122.440349407902) | |||
| 97316 | 97316 | 52308 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 464@ NOE 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/2005 12:00:00 AM | Permit Number 48468 | 6003585.05710238 | 2098376.65012733 | 37.7419456008039 | -122.43021312904301 | (37.7419456008039, -122.430213129043) | ||
| 97394 | 97394 | 58598 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4966 17th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 04/19/1979 12:00:00 AM | Permit Number 17804 | 5997580.2349427 | 2105651.04183436 | 37.761577335837295 | -122.45150033551 | (37.7615773358373, -122.45150033551) | |||
| 97832 | 97832 | 91387 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 45 Rosewood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2009 12:00:00 AM | 3x3 | Permit Number 52084 | 5994820.0 | 2095684.0 | 37.7340518973123 | -122.460324610216 | (37.7340518973123, -122.460324610216) | ||
| 97897 | 97897 | 87951 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 495 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50978 | 6010151.0 | 2089645.9 | 37.7183425147467 | -122.406894902171 | (37.7183425147467, -122.406894902171) | ||
| 98220 | 98220 | 105004 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3418 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16x4 | Permit Number 768912 | 6006889.6 | 2100911.6 | 37.7490926180804 | -122.41896681303899 | (37.7490926180804, -122.418966813039) | |||
| 99720 | 99720 | 39840 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3151 Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.751379430941896 | -122.49724128025 | (37.7513794309419, -122.49724128025) | ||
| 100652 | 100652 | 101029 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1010X Portola Dr | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | |||||
| 101064 | 101064 | 37495 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1050 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42243 | 5991661.12122197 | 2105245.54821547 | 37.7601232248942 | -122.47194237971901 | (37.7601232248942, -122.471942379719) | ||
| 101736 | 101736 | 94195 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 355 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999419.6 | 2091436.9 | 37.7226538624451 | -122.444117342662 | (37.7226538624451, -122.444117342662) | ||||
| 102259 | 102259 | 94194 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 355 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999419.6 | 2091436.9 | 37.7226538624451 | -122.444117342662 | (37.7226538624451, -122.444117342662) | ||||
| 102339 | 102339 | 113744 | Significant Tree 6 | Cordyline australis :: Dracena Palm 141 | 909 ASHBURY ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5999156.0 | 2107025.0 | 37.7654399906909 | -122.44614926226002 | (37.7654399906909, -122.44614926226) | ||||
| 102403 | 102403 | 38373 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3741 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2014 12:00:00 AM | Permit Number 40432 | 5982426.74388672 | 2102835.76429046 | 37.7529679717779 | -122.50370069063601 | (37.7529679717779, -122.503700690636) | ||
| 102533 | 102533 | 112571 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 162 GRAND VIEW AVE | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6000754.0 | 2103380.0 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | ||||
| 103769 | 103769 | 34376 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 159 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38128 | 6003933.5588278 | 2097472.84374368 | 37.73948368854229 | -122.42894370039 | (37.7394836885423, -122.42894370039) | ||
| 103781 | 103781 | 116969 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2648 BRYANT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009729.0 | 2101911.0 | 37.751996226816296 | -122.409218610644 | (37.7519962268163, -122.409218610644) | ||||
| 105205 | 105205 | 80063 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 830 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49842 | 5999067.87770464 | 2095624.46606775 | 37.734131869592204 | -122.44563415277 | (37.7341318695922, -122.44563415277) | ||
| 105312 | 105312 | 122403 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 400X Circular Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999746.0 | 2093731.0 | 37.7289715465039 | -122.443153734972 | (37.7289715465039, -122.443153734972) | ||||
| 105617 | 105617 | 97301 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1051 Portola Dr | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/20/2011 12:00:00 AM | Permit Number 768134 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | |||
| 105655 | 105655 | 100846 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Estero Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 106505 | 106505 | 51283 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3999 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2004 12:00:00 AM | Permit Number 47655 | 6004645.53227808 | 2095323.45859057 | 37.7336222359392 | -122.426329013444 | (37.7336222359392, -122.426329013444) | |||
| 106648 | 106648 | 51282 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3999 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2004 12:00:00 AM | Permit Number 47655 | 6004645.53227808 | 2095323.45859057 | 37.7336222359392 | -122.426329013444 | (37.7336222359392, -122.426329013444) | |||
| 106660 | 106660 | 88115 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 4133 Kirkham St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51116 | 5982072.0 | 2104866.0 | 37.758521560647395 | -122.505077887073 | (37.7585215606474, -122.505077887073) | |||
| 106849 | 106849 | 52483 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 650MAYFLOWER Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48593 | 6009757.299945901 | 2098381.34570201 | 37.742306158146796 | -122.408871740084 | (37.7423061581468, -122.408871740084) | ||
| 107077 | 107077 | 87952 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 495 Harkness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50978 | 6010151.0 | 2089645.9 | 37.7183425147467 | -122.406894902171 | (37.7183425147467, -122.406894902171) | ||
| 107765 | 107765 | 82985 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 460 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50922 | 6008017.64496893 | 2096716.02509924 | 37.737635955917604 | -122.414769124009 | (37.7376359559176, -122.414769124009) | ||
| 108413 | 108413 | 51417 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 5 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2004 12:00:00 AM | Permit Number 47742 | 5998697.89125775 | 2106894.30410502 | 37.765054960609206 | -122.447724339473 | (37.7650549606092, -122.447724339473) | |||
| 109900 | 109900 | 92405 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1549 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52804 | 5985246.8 | 2104672.6 | 37.7581768205908 | -122.494083909336 | (37.7581768205908, -122.494083909336) | |
| 109924 | 109924 | 38307 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 2000 Folsom St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.765290989194895 | -122.415396349695 | (37.7652909891949, -122.415396349695) | ||
| 110881 | 110881 | 84885 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 2895 HARRISON St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2007 12:00:00 AM | Permit No. 49261 | 6009003.0 | 2101605.0 | 37.7511153190475 | -122.41170761434401 | (37.7511153190475, -122.411707614344) | |||
| 110980 | 110980 | 92426 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1601 39th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52817 | 5984021.0 | 2104223.4 | 37.75687164036479 | -122.49829001409701 | (37.7568716403648, -122.498290014097) | |
| 111863 | 111863 | 88113 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3345 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51115 | 5984516.0 | 2104948.0 | 37.7588902030811 | -122.49663161711 | (37.7588902030811, -122.49663161711) | ||
| 112057 | 112057 | 88275 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1910 33rd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51266 | 5986038.6 | 2102202.7 | 37.7514414512274 | -122.49116379172399 | (37.7514414512274, -122.491163791724) | |||
| 112460 | 112460 | 45271 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 635 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2001 12:00:00 AM | Permit Number 44117 | 6007835.54663504 | 2095717.89639114 | 37.734885079654 | -122.415328087742 | (37.734885079654, -122.415328087742) | |||
| 112935 | 112935 | 105001 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3418 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6006889.6 | 2100911.6 | 37.7490926180804 | -122.41896681303899 | (37.7490926180804, -122.418966813039) | ||||
| 113311 | 113311 | 94193 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 355@ Delano Ave Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999419.6 | 2091436.9 | 37.7226538624451 | -122.444117342662 | (37.7226538624451, -122.444117342662) | ||||
| 113590 | 113590 | 121655 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 472 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994766.0 | 2100099.0 | 37.746171285406106 | -122.460831166054 | (37.7461712854061, -122.460831166054) | ||||
| 114450 | 114450 | 100532 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 685 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003065.0 | 2104250.0 | 37.7580429675673 | -122.432430718154 | (37.7580429675673, -122.432430718154) | ||||
| 115060 | 115060 | 39187 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1189 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40841 | 6007685.90483064 | 2102746.1551156 | 37.7541746987817 | -122.41634309806801 | (37.7541746987817, -122.416343098068) | ||
| 115100 | 115100 | 43116 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 200 Appleton Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/13/2003 12:00:00 AM | Permit Number 42938 | 6005863.0139999995 | 2096788.574 | 37.7377138611244 | -122.422223875233 | (37.7377138611244, -122.422223875233) | ||
| 115216 | 115216 | 87092 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 2533 Baker St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50041 | 5999658.0 | 2117512.0 | 37.7942632496373 | -122.445166988043 | (37.7942632496373, -122.445166988043) | |||
| 116601 | 116601 | 37496 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1050 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39963 | 5991661.12122197 | 2105245.54821547 | 37.7601232248942 | -122.47194237971901 | (37.7601232248942, -122.471942379719) | ||
| 116722 | 116722 | 94139 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 864 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53506 | 5999177.0 | 2107299.0 | 37.7661935250869 | -122.44609633854601 | (37.7661935250869, -122.446096338546) | ||
| 117877 | 117877 | 112570 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 162 GRAND VIEW AVE | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6000754.0 | 2103380.0 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | ||||
| 118355 | 118355 | 41859 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1050 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42243 | 5991661.12122197 | 2105245.54821547 | 37.7601232248942 | -122.47194237971901 | (37.7601232248942, -122.471942379719) | ||
| 118666 | 118666 | 51416 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 611 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2004 12:00:00 AM | Permit Number 47741 | 5996652.56500142 | 2107304.20235687 | 37.7660633258868 | -122.454828195737 | (37.7660633258868, -122.454828195737) | ||
| 119290 | 119290 | 92789 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 99 Buena Vista Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53006 | 6001506.4 | 2107657.3 | 37.7673100756575 | -122.438065079874 | (37.7673100756575, -122.438065079874) | |||
| 119712 | 119712 | 122589 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2500X Lyon St | 9 | Median : Cutout 11 | Tree 1 | Private 1 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | ||||
| 120307 | 120307 | 87090 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 2533 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50041 | 5999658.0 | 2117512.0 | 37.7942632496373 | -122.445166988043 | (37.7942632496373, -122.445166988043) | |||
| 120720 | 120720 | 97410 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 4 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5995213.5 | 2099104.4 | 37.743466100167 | -122.459211767689 | (37.743466100167, -122.459211767689) | |||||
| 120845 | 120845 | 92492 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1936 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2009 12:00:00 AM | 3x3 | Permit Number 52862 | 5986966.0 | 2097599.0 | 37.73885506412971 | -122.487618605313 | (37.7388550641297, -122.487618605313) | |
| 121468 | 121468 | 115243 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 625 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 775511 | 5981292.5 | 2111469.1 | 37.776605861396796 | -122.50826381996201 | (37.7766058613968, -122.508263819962) |
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");