Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
154853 | 154853 | 93871 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 400-422X Tocoloma Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2010 12:00:00 AM | 17 | 3x3 | Permit Number 53366 | 6012449.21929 | 2086625.36701 | 37.7101770646038 | -122.398739010112 | (37.7101770646038, -122.398739010112) | |
11231 | 11231 | 16408 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1186X Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 42 | TR | 6001104.60764 | 2087178.31507 | 37.7110567247495 | -122.43798776335 | (37.7110567247495, -122.43798776335) | |||
10497 | 10497 | 28546 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 5125 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000380.5163 | 2089281.6434 | 37.716790788359795 | -122.440641159733 | (37.7167907883598, -122.440641159733) | ||
140150 | 140150 | 28545 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 5098 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6000324.7175 | 2089317.7589200002 | 37.7168867757364 | -122.44083661746299 | (37.7168867757364, -122.440836617463) | ||
13149 | 13149 | 28547 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 5109 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000411.4099 | 2089335.4212 | 37.7169402093066 | -122.44053823097799 | (37.7169402093066, -122.440538230978) | ||
10445 | 10445 | 24508 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 5088 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1995 12:00:00 AM | 3 | 3X3 | 6000357.2418 | 2089366.5868 | 37.717022698354604 | -122.440727697577 | (37.7170226983546, -122.440727697577) | ||
10435 | 10435 | 28548 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 5095 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000516.105 | 2089501.9034 | 37.7174032930481 | -122.440188283496 | (37.7174032930481, -122.440188283496) | ||
13194 | 13194 | 28543 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 5050 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 14 | 3X3 | 6000463.3087 | 2089534.8309 | 37.717490698541106 | -122.44037313550601 | (37.7174906985411, -122.440373135506) | ||
13075 | 13075 | 15809 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4971 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 16 | 3x3 | 6000847.9253 | 2090031.6718 | 37.7188768038041 | -122.43907928418501 | (37.7188768038041, -122.439079284185) | ||
83056 | 83056 | 108808 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 542 Moscow St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774650 | 6003656.47159 | 2090041.31767 | 37.7190626969286 | -122.42937193832199 | (37.7190626969286, -122.429371938322) | |
10432 | 10432 | 28549 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4963 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000879.9631 | 2090072.8632 | 37.71899172902071 | -122.438971492831 | (37.7189917290207, -122.438971492831) | ||
12407 | 12407 | 28550 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4919 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001014.7517 | 2090296.9851 | 37.7196147854688 | -122.438521631633 | (37.7196147854688, -122.438521631633) | ||
11469 | 11469 | 28551 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4885 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001150.501 | 2090506.6381 | 37.720198166433896 | -122.438067406183 | (37.7201981664339, -122.438067406183) | ||
12884 | 12884 | 15778 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4830 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 15 | 3x3 | 6001221.4914 | 2090732.7596 | 37.7208230821415 | -122.437838203744 | (37.7208230821415, -122.437838203744) | ||
10427 | 10427 | 28552 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4839 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6001308.3124 | 2090760.3284 | 37.7209037164668 | -122.437540063841 | (37.7209037164668, -122.437540063841) | ||
12148 | 12148 | 15777 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4826 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2013 12:00:00 AM | 14 | 3X3 | 6001241.8395 | 2090763.6886 | 37.7209091632567 | -122.43777008073401 | (37.7209091632567, -122.437770080734) | ||
118654 | 118654 | 28553 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4791 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001495.20995 | 2091053.11607 | 37.7217182698376 | -122.436914966203 | (37.7217182698376, -122.436914966203) | ||
140763 | 140763 | 28541 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4760 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001455.13645 | 2091107.7518200001 | 37.7218660095523 | -122.437057399169 | (37.7218660095523, -122.437057399169) | ||
10773 | 10773 | 28540 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4754 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001487.6438 | 2091153.5571 | 37.7219936282262 | -122.43694830738701 | (37.7219936282262, -122.436948307387) | ||
10503 | 10503 | 15772 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4769 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2007 12:00:00 AM | 3 | 3x3 | 6001557.6417 | 2091157.3044 | 37.722007895755794 | -122.436706610694 | (37.7220078957558, -122.436706610694) | ||
10447 | 10447 | 28554 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4753 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6001590.7646 | 2091209.3547 | 37.722152696500004 | -122.436595837081 | (37.7221526965, -122.436595837081) | ||
11802 | 11802 | 28539 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4734 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6001578.802999999 | 2091300.8769999999 | 37.7224033163499 | -122.436643733228 | (37.7224033163499, -122.436643733228) | ||
11123 | 11123 | 28555 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4743 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001652.2787 | 2091307.3716 | 37.722425324335 | -122.436390209739 | (37.722425324335, -122.436390209739) | ||
11110 | 11110 | 28537 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4716 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001661.0091 | 2091431.1044 | 37.7227655627881 | -122.436368881923 | (37.7227655627881, -122.436368881923) | ||
11198 | 11198 | 28556 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4717 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001738.1279 | 2091443.2433 | 37.7228032751332 | -122.436103167424 | (37.7228032751332, -122.436103167424) | ||
120258 | 120258 | 28637 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 955 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 24 | 5XX5 | 5996975.36021 | 2091606.08521 | 37.7229786625948 | -122.452578702244 | (37.7229786625948, -122.452578702244) | ||
129269 | 129269 | 28636 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 955 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 20 | 5X5 | 5996968.04232 | 2091607.5946900002 | 37.7229823879791 | -122.452604107446 | (37.7229823879791, -122.452604107446) | ||
127972 | 127972 | 28557 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4681 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001872.38004 | 2091652.00525 | 37.7233841148131 | -122.43565401519 | (37.7233841148131, -122.43565401519) | ||
82761 | 82761 | 28581 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1100 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 18 | 4X4 | 5996838.9416251 | 2091728.3014296002 | 37.7233064222609 | -122.453059088902 | (37.7233064222609, -122.453059088902) | ||
87014 | 87014 | 28580 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1100 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 18 | 4X4 | 5996838.9416251 | 2091728.3014296002 | 37.7233064222609 | -122.453059088902 | (37.7233064222609, -122.453059088902) | ||
139974 | 139974 | 28632 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1051 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 18 | 5X5 | 5996612.56003 | 2091733.27597 | 37.723307104505295 | -122.453842001957 | (37.7233071045053, -122.453842001957) | ||
119225 | 119225 | 28631 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1051 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 18 | 5x5 | 5996604.51775 | 2091735.3595900002 | 37.7233123645372 | -122.45386995284099 | (37.7233123645372, -122.453869952841) | ||
11137 | 11137 | 28558 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4667 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001923.346 | 2091737.9699 | 37.723623049111296 | -122.435483982262 | (37.7236230491113, -122.435483982262) | ||
117717 | 117717 | 28609 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1117 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 18 | 5X5 | 5996444.46775 | 2091779.60617 | 37.723424677500205 | -122.454426406995 | (37.7234246775002, -122.454426406995) | ||
80955 | 80955 | 28559 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4647 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6002004.69492 | 2091867.26763 | 37.7239826914316 | -122.435212017462 | (37.7239826914316, -122.435212017462) | ||
13119 | 13119 | 28560 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4631 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6002010.8853 | 2091868.7717 | 37.7239871728 | -122.43519072585501 | (37.7239871728, -122.435190725855) | ||
83918 | 83918 | 28625 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1299 Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | 18 | 3X3 | 5996025.31382 | 2091881.53932 | 37.7236805140054 | -122.455882701682 | (37.7236805140054, -122.455882701682) | ||
87403 | 87403 | 28607 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1345 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | 18 | 3X3 | 5995745.87048 | 2091965.2251799998 | 37.723894253245895 | -122.456854733097 | (37.7238942532459, -122.456854733097) | ||
72211 | 72211 | 28774 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4626 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6001950.98602 | 2092007.07057 | 37.724363508667295 | -122.43540767631 | (37.7243635086673, -122.43540767631) | |||
106224 | 106224 | 28592 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1338 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 4X4 | 5995676.5171 | 2092067.1693 | 37.7241701848162 | -122.457101845697 | (37.7241701848162, -122.457101845697) | ||
116359 | 116359 | 28593 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1344 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 18 | 3x3 | 5995646.9889 | 2092076.7179900003 | 37.7241947074129 | -122.457204610061 | (37.7241947074129, -122.457204610061) | ||
117906 | 117906 | 28390 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1556 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 30 | 5X5 | 5995079.29349 | 2092240.59215 | 37.7246120461485 | -122.459178896827 | (37.7246120461485, -122.459178896827) | ||
12880 | 12880 | 28799 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4575 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002251.5336 | 2092256.7834 | 37.7250662282166 | -122.434386571875 | (37.7250662282166, -122.434386571875) | |||
97375 | 97375 | 25262 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1712 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994776.63019 | 2092332.44962 | 37.724846859825895 | -122.46023180975901 | (37.7248468598259, -122.460231809759) | ||
127723 | 127723 | 28596 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1712 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 18 | 5X5 | 5994768.91993 | 2092335.30302 | 37.724854251069395 | -122.46025866967501 | (37.7248542510694, -122.460258669675) | ||
142630 | 142630 | 28401 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1801 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994365.43766 | 2092389.56598 | 37.7249800267364 | -122.46165738286001 | (37.7249800267364, -122.46165738286) | ||
81528 | 81528 | 25268 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1770 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 3X3 | 5994565.40331 | 2092391.5082200002 | 37.724996868228104 | -122.460966269529 | (37.7249968682281, -122.460966269529) | ||
122736 | 122736 | 28400 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1801 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994353.33294 | 2092393.96345 | 37.7249914043353 | -122.461699545917 | (37.7249914043353, -122.461699545917) | ||
142832 | 142832 | 25269 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1770 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994556.12855 | 2092394.0919599999 | 37.725003428856 | -122.460998518302 | (37.725003428856, -122.460998518302) | ||
12396 | 12396 | 15742 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4534 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1999 12:00:00 AM | 12 | 3X3 | 6002267.3808 | 2092395.6017 | 37.725448291506204 | -122.43434171007601 | (37.7254482915062, -122.434341710076) | ||
13033 | 13033 | 15743 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4545 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2001 12:00:00 AM | 12 | 3x3 | 6002337.7208 | 2092395.6969 | 37.7254525452522 | -122.434098558087 | (37.7254525452522, -122.434098558087) | ||
71965 | 71965 | 50023 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1704 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 9 | Permit Number 46757 | 6005976.3873 | 2092403.4615900002 | 37.7256797039307 | -122.421520544445 | (37.7256797039307, -122.421520544445) | |
11995 | 11995 | 15738 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4516 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1997 12:00:00 AM | 12 | 3X3 | 6002290.9845 | 2092433.856 | 37.725554668943204 | -122.434262847922 | (37.7255546689432, -122.434262847922) | ||
12846 | 12846 | 15741 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4531 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2000 12:00:00 AM | 12 | 3x3 | 6002397.2069 | 2092488.3059999999 | 37.7257102048968 | -122.433899536724 | (37.7257102048968, -122.433899536724) | ||
111111 | 111111 | 25275 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994210.04485 | 2092528.0363900003 | 37.725351286848394 | -122.462204592351 | (37.7253512868484, -122.462204592351) | ||
88145 | 88145 | 28395 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994199.42088 | 2092532.99697 | 37.725364295675995 | -122.462241677747 | (37.725364295676, -122.462241677747) | ||
85226 | 85226 | 28451 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1931 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 3X3 | 5993990.72994 | 2092568.10284 | 37.725448669232605 | -122.462965643186 | (37.7254486692326, -122.462965643186) | ||
101404 | 101404 | 28450 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1933 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 18 | 3X3 | 5993979.747380001 | 2092573.4533099998 | 37.7254627277081 | -122.463003996644 | (37.7254627277081, -122.463003996644) | ||
49819 | 49819 | 49090 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 101 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Permit Number 46240 | 6005000.86531 | 2092599.96167 | 37.7261641966181 | -122.424906823795 | (37.7261641966181, -122.424906823795) | |||
12072 | 12072 | 28800 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4505 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002480.3523 | 2092620.1218 | 37.7260768594239 | -122.433621526187 | (37.7260768594239, -122.433621526187) | |||
11757 | 11757 | 15734 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4476 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1995 12:00:00 AM | 3 | 3X3 | 6002423.6538 | 2092643.0339 | 37.726136553633395 | -122.43381916618 | (37.7261365536334, -122.43381916618) | ||
19149 | 19149 | 25280 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1970 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 5993723.9477 | 2092778.9993 | 37.7260123689359 | -122.46390317969102 | (37.7260123689359, -122.463903179691) | |||
17764 | 17764 | 25281 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1970 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 5993695.8734 | 2092795.8439 | 37.726057002173796 | -122.464001452223 | (37.7260570021738, -122.464001452223) | |||
21397 | 21397 | 25282 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1970 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 5993611.6506 | 2092838.2672 | 37.726168631945704 | -122.464295681605 | (37.7261686319457, -122.464295681605) | |||
20427 | 20427 | 25283 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1970 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 5993582.3286 | 2092852.6163 | 37.7262063408999 | -122.46439808667 | (37.7262063408999, -122.46439808667) | |||
102155 | 102155 | 28482 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2073 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3x3 | 5993305.06135 | 2092906.64732 | 37.7263387103664 | -122.46536049980499 | (37.7263387103664, -122.465360499805) | ||
126065 | 126065 | 28481 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2073 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3x3 | 5993293.23217 | 2092912.5573200001 | 37.726354255565795 | -122.465401821504 | (37.7263542555658, -122.465401821504) | ||
96271 | 96271 | 28480 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2127 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 3X3 | 5993065.7807 | 2093038.61214 | 37.7266872508023 | -122.466197260481 | (37.7266872508023, -122.466197260481) | ||
120120 | 120120 | 28479 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2127 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 3x3 | 5993065.7807 | 2093038.61214 | 37.7266872508023 | -122.466197260481 | (37.7266872508023, -122.466197260481) | ||
105853 | 105853 | 28478 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2159X Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 3X3 | 5992874.48639 | 2093252.14618 | 37.7272625239656 | -122.46687406965 | (37.7272625239656, -122.46687406965) | ||
103297 | 103297 | 28477 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2159X Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 3X3 | 5992865.63839 | 2093261.95996 | 37.7272889595155 | -122.46690537001601 | (37.7272889595155, -122.466905370016) | ||
89525 | 89525 | 28458 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2160X Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3x3 | 5992795.29206 | 2093448.6567 | 37.7277975223389 | -122.467162123346 | (37.7277975223389, -122.467162123346) | ||
145780 | 145780 | 28459 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2160X Ocean Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 19 | 3x3 | 5992788.04983 | 2093457.91659 | 37.727822529658 | -122.467187832651 | (37.727822529658, -122.467187832651) | ||
11318 | 11318 | 27101 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 675 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3X3 | 6005857.71837 | 2093582.84449 | 37.7289113394736 | -122.42201451865101 | (37.7289113394736, -122.422014518651) | |||
11503 | 11503 | 27099 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 681 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 2X2 | 6005896.77811 | 2093584.4181099997 | 37.7289178631699 | -122.421879597869 | (37.7289178631699, -122.421879597869) | |||
184973 | 184973 | 62210 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 280 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 18 | Permit Number 22332 | 6000793.821959999 | 2093620.4443599998 | 37.7287276772231 | -122.439523423176 | (37.7287276772231, -122.439523423176) | |
87363 | 87363 | 28422 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2230 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2012 12:00:00 AM | 12 | 3x3 | 5992640.87111 | 2093746.9102599998 | 37.728607537869294 | -122.46771763720699 | (37.7286075378693, -122.467717637207) | ||
108531 | 108531 | 28471 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2295 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992502.64875 | 2093884.6455400002 | 37.728977742823794 | -122.46820549121 | (37.7289777428238, -122.46820549121) | ||
103267 | 103267 | 28470 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2295 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992499.15443 | 2093893.9061599998 | 37.729002968377294 | -122.46821824463301 | (37.7290029683773, -122.468218244633) | ||
84329 | 84329 | 28440 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2325 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992376.3743900005 | 2094089.82777 | 37.7295338285402 | -122.46865695076099 | (37.7295338285402, -122.468656950761) | ||
108922 | 108922 | 28439 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2325 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992364.67777 | 2094097.6153099998 | 37.729554535492 | -122.46869795321999 | (37.729554535492, -122.46869795322) | ||
155287 | 155287 | 46765 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 46 Admiral Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 14 | Permit Number 44862 | 6003326.43729 | 2094178.5740200002 | 37.7304039901516 | -122.430807830618 | (37.7304039901516, -122.430807830618) | |
96358 | 96358 | 28436 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2383 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992168.55554 | 2094228.20045 | 37.729901757986 | -122.46938546297702 | (37.729901757986, -122.469385462977) | ||
120677 | 120677 | 28435 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2383 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992163.8663800005 | 2094231.44033 | 37.7299103829045 | -122.469401909547 | (37.7299103829045, -122.469401909547) | ||
121147 | 121147 | 28431 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2439 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5991850.14781 | 2094403.3644599998 | 37.7303643088426 | -122.470498978 | (37.7303643088426, -122.470498978) | ||
126547 | 126547 | 28430 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2439 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5991842.51952 | 2094406.3714 | 37.730372124061 | -122.47052556873001 | (37.730372124061, -122.47052556873) | ||
43355 | 43355 | 41527 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1038 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | 19 | Permit Number 42067 | 6018424.261969999 | 2095097.67116 | 37.7337714988594 | -122.378675747684 | (37.7337714988594, -122.378675747684) | ||
100661 | 100661 | 45177 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 405 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/23/2001 12:00:00 AM | Permit Number 44025 | 6010386.35714914 | 2098720.11226765 | 37.743271553676294 | -122.406720510672 | (37.7432715536763, -122.406720510672) | ||
119689 | 119689 | 46396 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2363 46th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | Permit Number 44628 | 5982038.69993379 | 2099019.08157606 | 37.7424656032555 | -122.504759817001 | (37.7424656032555, -122.504759817001) | ||
20499 | 20499 | 31376 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 634 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2004 12:00:00 AM | 18 | 3x3 | Permit Number 34978 | 5991167.871719999 | 2099111.64976 | 37.7432525889424 | -122.47320092310301 | (37.7432525889424, -122.473200923103) | |
77716 | 77716 | 93966 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) | |
97023 | 97023 | 93963 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) | ||
114071 | 114071 | 93964 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) | ||
114278 | 114278 | 93962 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) | ||
122080 | 122080 | 93965 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) | ||
128018 | 128018 | 93967 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3050X Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 53400 | 6007118.1 | 2100723.5 | 37.7485890022613 | -122.418163321976 | (37.7485890022613, -122.418163321976) | ||
96749 | 96749 | 93115 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 397 San Jose Ave | 1 | Sidewalk: Curb side : 21 | Landscaping 2 | Private 1 | 02/02/2009 12:00:00 AM | 26x6 | Permit Number 53167 | 6006259.6 | 2100887.6 | 37.7489912240508 | -122.42114365927 | (37.7489912240508, -122.42114365927) | ||
119677 | 119677 | 85177 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 479 Bartlett St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2012 12:00:00 AM | 4x19 | Permit Number 768801 | 6006816.0 | 2100993.0 | 37.7493119792947 | -122.419227096542 | (37.7493119792947, -122.419227096542) | ||
108060 | 108060 | 47312 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1346 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2005 12:00:00 AM | Permit Number 45243 | 6010314.34342457 | 2101370.8021383 | 37.750545738734104 | -122.40715632352101 | (37.7505457387341, -122.407156323521) | ||
17751 | 17751 | 15573 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2899 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007123.7446 | 2101516.8013 | 37.7507675455055 | -122.41820003848999 | (37.7507675455055, -122.41820003849) |
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");