Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 87949 | 87949 | 96848 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 1486 Innes Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 6016133.4 | 2096820.6 | 37.7383757570157 | -122.386716118251 | (37.7383757570157, -122.386716118251) | ||||||
| 108424 | 108424 | 106038 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 230 Lakeview Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 772456 | 5997013.1 | 2089546.6 | 37.7173259605404 | -122.452299707743 | (37.7173259605404, -122.452299707743) | |||||
| 109889 | 109889 | 93903 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 546 Page St | Front Yard : 25 | Tree 1 | Private 1 | 6003947.0 | 2109752.0 | 37.773200107256606 | -122.42977281454901 | (37.7732001072566, -122.429772814549) | ||||||
| 334 | 334 | 246360 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1932 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6006755.8259 | 2107130.7038 | 37.76616130474321 | -122.419870652653 | (37.7661613047432, -122.419870652653) | |||
| 1512 | 1512 | 243955 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 15 | Width 5ft | Permit Number 47529 | 6007056.3814199995 | 2109908.18867 | 37.773804548164705 | -122.419028109365 | (37.7738045481647, -122.419028109365) | |
| 1518 | 1518 | 243948 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 11 | Width 5ft | Permit Number 47529 | 6006987.09759 | 2110205.04369 | 37.774615739356705 | -122.41928883630399 | (37.7746157393567, -122.419288836304) | |
| 1602 | 1602 | 102429 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 200 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010552.49087 | 2111923.99595 | 37.7795357369219 | -122.40707656363399 | (37.7795357369219, -122.407076563634) | |
| 1642 | 1642 | 199503 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 1009 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770993 | 6010500.983080001 | 2111924.50305 | 37.7795342467397 | -122.40725478770099 | (37.7795342467397, -122.407254787701) | |
| 2846 | 2846 | 253262 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2425 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991946.0 | 2094328.0 | 37.730162918760904 | -122.470162120918 | (37.7301629187609, -122.470162120918) | ||||
| 2868 | 2868 | 253247 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 570 Jessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.1376799997 | 37.7809123781536 | -122.40995800293301 | (37.7809123781536, -122.409958002933) | |
| 4287 | 4287 | 181059 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 5810 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:37:00 PM | 3 | Width 3ft | 5997243.54219 | 2086644.28205 | 37.7093700633606 | -122.451293980329 | (37.7093700633606, -122.451293980329) | ||
| 6773 | 6773 | 45307 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 561 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | 20 | 5x5 | Permit Number 44145 | 6000554.5197 | 2110946.4965 | 37.7762872030081 | -122.44159355669599 | (37.7762872030081, -122.441593556696) |
| 9740 | 9740 | 173671 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 299x Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 10174 | 10174 | 173886 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 2931 20th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6009454.0 | 2104482.0 | 37.759040204703496 | -122.41035112011801 | (37.7590402047035, -122.410351120118) | |||||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 13185 | 13185 | 98922 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2507 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 6x6 | 5989831.2863 | 2098268.2421 | 37.7408593296697 | -122.47776079641599 | (37.7408593296697, -122.477760796416) | |||
| 14256 | 14256 | 102418 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 201 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x4 | 6010625.41098 | 2111944.3761400003 | 37.7795957765601 | -122.406825737323 | (37.7795957765601, -122.406825737323) | |||
| 15166 | 15166 | 102426 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x4 | 6010110.9527900005 | 2112392.33205 | 37.780796958746 | -122.408637087058 | (37.780796958746, -122.408637087058) | |||
| 17051 | 17051 | 15346 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6006752.3955 | 2107277.3553 | 37.766563781951106 | -122.419892925221 | (37.7665637819511, -122.419892925221) | |||
| 17359 | 17359 | 15544 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2831 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007105.1669 | 2101841.7215 | 37.7516586567519 | -122.418287316619 | (37.7516586567519, -122.418287316619) | |||
| 17504 | 17504 | 15470 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2467 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/1992 12:00:00 AM | 12 | 4X4 | 6006982.3266 | 2104010.3832 | 37.757606388854605 | -122.418865906959 | (37.7576063888546, -122.418865906959) | ||
| 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) | |||
| 17840 | 17840 | 105162 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1600X OAKDALE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5x5 | 6015006.0 | 2095503.0 | 37.734695414582795 | -122.390522107646 | (37.7346954145828, -122.390522107646) | |||
| 17971 | 17971 | 15480 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2601 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/1994 12:00:00 AM | 12 | 4X4 | 6007030.0978 | 2103104.2466 | 37.755121036020604 | -122.418636437773 | (37.7551210360206, -122.418636437773) | ||
| 18122 | 18122 | 15443 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2230 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006851.2872 | 2105349.6458 | 37.7612763139256 | -122.419414104618 | (37.7612763139256, -122.419414104618) | |||
| 18126 | 18126 | 15514 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2756 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007024.332 | 2102304.0728 | 37.752923617389705 | -122.418599638138 | (37.7529236173897, -122.418599638138) | |||
| 18216 | 18216 | 24604 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1850 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2004 12:00:00 AM | 6 | 3X3 | 6006726.6671 | 2107610.9661 | 37.7674783489788 | -122.420005592363 | (37.7674783489788, -122.420005592363) | ||
| 18762 | 18762 | 15566 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2875 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007116.1618 | 2101613.8603 | 37.7510336206374 | -122.41823314117799 | (37.7510336206374, -122.418233141178) | |||
| 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) | |||
| 19316 | 19316 | 15543 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2830 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1994 12:00:00 AM | 18 | 3X3 | 6007038.8586 | 2101864.2983 | 37.7517169147733 | -122.418518220595 | (37.7517169147733, -122.418518220595) | ||
| 19489 | 19489 | 15400 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2035 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6006850.0111 | 2106406.7679 | 37.7641788523727 | -122.419493518679 | (37.7641788523727, -122.419493518679) | |||
| 19811 | 19811 | 15562 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2869 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007115.4036 | 2101660.115 | 37.7511605828473 | -122.418239042192 | (37.7511605828473, -122.418239042192) | |||
| 19832 | 19832 | 15404 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2040 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6006793.6148 | 2106462.6587 | 37.764329138697 | -122.41969254355601 | (37.764329138697, -122.419692543556) | |||
| 20000 | 20000 | 15524 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2779 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6007088.4849 | 2102183.7027 | 37.752596720125396 | -122.41836925076099 | (37.7525967201254, -122.418369250761) | |||
| 20013 | 20013 | 15512 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2749 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007073.3194 | 2102357.3473 | 37.753072654833296 | -122.418434007286 | (37.7530726548333, -122.418434007286) | |||
| 20065 | 20065 | 15349 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1906 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1993 12:00:00 AM | 12 | 4X4 | 6006754.9683 | 2107231.9019 | 37.7664391225711 | -122.419880800641 | (37.7664391225711, -122.419880800641) | ||
| 20108 | 20108 | 15398 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2029 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006849.6288 | 2106465.6722 | 37.7643405682415 | -122.41949902025699 | (37.7643405682415, -122.419499020257) | |||
| 20366 | 20366 | 15504 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2729 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007071.0446 | 2102456.6811 | 37.7533452746903 | -122.418448916916 | (37.7533452746903, -122.418448916916) | |||
| 20420 | 20420 | 15557 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2859 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007111.2331 | 2101709.0236 | 37.7512946399846 | -122.41825693151199 | (37.7512946399846, -122.418256931512) | |||
| 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) | |
| 20577 | 20577 | 15523 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2777 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007081.6604 | 2102211.0006 | 37.7526712897583 | -122.418394786513 | (37.7526712897583, -122.418394786513) | |||
| 20675 | 20675 | 15518 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2765 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007077.869 | 2102263.3214 | 37.752814737300604 | -122.418411607402 | (37.7528147373006, -122.418411607402) | |||
| 20677 | 20677 | 15503 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2721 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007064.9784 | 2102504.4523 | 37.7534761019861 | -122.418473282249 | (37.7534761019861, -122.418473282249) | |||
| 20793 | 20793 | 15419 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2090 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6006808.7621 | 2106205.8751 | 37.7636249243563 | -122.41962193297199 | (37.7636249243563, -122.419621932972) | |||
| 20857 | 20857 | 15519 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2768 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007027.5439 | 2102261.5951 | 37.7528071641561 | -122.41858551881901 | (37.7528071641561, -122.418585518819) | |||
| 20884 | 20884 | 15410 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2065 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6006857.2115 | 2106321.6003 | 37.7639454076577 | -122.41946257191601 | (37.7639454076577, -122.419462571916) | |||
| 21082 | 21082 | 28787 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2518 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6006949.0139999995 | 2103676.1713 | 37.7566868442816 | -122.418957411892 | (37.7566868442816, -122.418957411892) | |||
| 21136 | 21136 | 15424 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2101 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006867.8273 | 2106045.5888 | 37.763188142588604 | -122.419406272714 | (37.7631881425886, -122.419406272714) | |||
| 21146 | 21146 | 15506 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2738 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2006 12:00:00 AM | 3 | 3x3 | 6007021.0573 | 2102399.0391 | 37.753184188782 | -122.41861769652 | (37.753184188782, -122.41861769652) | ||
| 21205 | 21205 | 15439 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2162 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006823.9061 | 2105762.5248 | 37.7624084411332 | -122.41953809802901 | (37.7624084411332, -122.419538098029) | ||
| 21244 | 21244 | 15551 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2839 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007105.1669 | 2101800.0164 | 37.751544144042 | -122.418284359977 | (37.751544144042, -122.418284359977) | |||
| 21541 | 21541 | 15552 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2846 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6007045.846 | 2101751.2294 | 37.751406846694 | -122.418486040429 | (37.751406846694, -122.418486040429) | |||
| 21610 | 21610 | 15437 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2148 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006821.0239 | 2105826.6543 | 37.762584363416295 | -122.419552616574 | (37.7625843634163, -122.419552616574) | ||
| 21745 | 21745 | 15549 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2840 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007044.5756 | 2101802.0469 | 37.7515463084579 | -122.41849403667 | (37.7515463084579, -122.41849403667) | |||
| 22032 | 22032 | 24579 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2862 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007054.1039 | 2101659.758 | 37.751156151932996 | -122.41845099825599 | (37.751156151933, -122.418450998256) | |||
| 22135 | 22135 | 15500 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2710 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007019.0925 | 2102497.935 | 37.7534556236904 | -122.41863150374701 | (37.7534556236904, -122.418631503747) | |||
| 23492 | 23492 | 202174 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Kalmanovitz St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 2ft | 6013138.83373 | 2093054.0318599998 | 37.7278672922301 | -122.39680594795401 | (37.7278672922301, -122.396805947954) | |||
| 24537 | 24537 | 217484 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 554 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5997767.10933 | 2095284.1068799999 | 37.7331229743458 | -122.450106772723 | (37.7331229743458, -122.450106772723) | ||||
| 24710 | 24710 | 38696 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 442 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | 8 | Permit Number 40608 | 6000200.5427 | 2110464.1107 | 37.7749425203696 | -122.442783410713 | (37.7749425203696, -122.442783410713) | |
| 25234 | 25234 | 244842 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 41 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6006681.50629 | 2103383.71332 | 37.755868755243704 | -122.419861800707 | (37.7558687552437, -122.419861800707) | |||
| 26802 | 26802 | 243938 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 315 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6003592.012490001 | 2106424.54324 | 37.764043612453996 | -122.43076326292 | (37.764043612454, -122.43076326292) | |||
| 27009 | 27009 | 199444 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1515 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6015656.62698 | 2107992.23345 | 37.769024297155205 | -122.389144413879 | (37.7690242971552, -122.389144413879) | |||
| 27240 | 27240 | 73535 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2207 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 18 | 5987582.0279 | 2100272.2966 | 37.7462311393003 | -122.485684839892 | (37.7462311393003, -122.485684839892) | ||
| 27436 | 27436 | 244863 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 117 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6006906.41702 | 2098789.62543 | 37.7432671013094 | -122.418758192246 | (37.7432671013094, -122.418758192246) | |||
| 27544 | 27544 | 217486 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 134 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 10ft | 5999850.54516 | 2094099.6824900003 | 37.729989823555705 | -122.442818779256 | (37.7299898235557, -122.442818779256) | |||
| 28377 | 28377 | 48685 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2002 12:00:00 AM | 22 | Permit Number 45967 | 5995923.78548 | 2113769.63655 | 37.7837738786202 | -122.45781677815 | (37.7837738786202, -122.45781677815) | ||
| 29817 | 29817 | 245984 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2755 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6007074.8359 | 2102333.0826 | 37.7530061148801 | -122.418427042538 | (37.7530061148801, -122.418427042538) | |||
| 30691 | 30691 | 244835 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1880 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6006729.90929 | 2107524.20157 | 37.7672402967355 | -122.41998822018101 | (37.7672402967355, -122.419988220181) | |||
| 31746 | 31746 | 243915 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 527 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6009846.89705 | 2099022.9743 | 37.744072948723996 | -122.408607191783 | (37.744072948724, -122.408607191783) | |||
| 32638 | 32638 | 199456 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015610.82208 | 2108808.9255 | 37.77126421521471 | -122.38935989056299 | (37.7712642152147, -122.389359890563) | |||
| 32803 | 32803 | 243929 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1409 Douglass St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6001410.85086 | 2099557.6127299997 | 37.745064858666 | -122.437815383076 | (37.745064858666, -122.437815383076) | |||
| 33282 | 33282 | 217464 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 127 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5991405.11003 | 2090040.73714 | 37.7183598726973 | -122.471719713607 | (37.7183598726973, -122.471719713607) |
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");