Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 602 | 602 | 15498 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2704 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007015.1629 | 2102569.9783 | 37.7536532168709 | -122.41865020170799 | (37.7536532168709, -122.418650201708) | |||
| 988 | 988 | 199496 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 87 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | Width 4ft | 6010015.0817 | 2112492.094 | 37.781065511609604 | -122.40897579419399 | (37.7810655116096, -122.408975794194) | |||
| 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) | |
| 1514 | 1514 | 243952 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 15 | Width 5ft | Permit Number 47529 | 6007022.68787 | 2110044.22077 | 37.7741761624211 | -122.41915431212601 | (37.7741761624211, -122.419154312126) | |
| 1515 | 1515 | 243950 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 13 | Width 5ft | Permit Number 47529 | 6007004.81099 | 2110130.42285 | 37.774411845966895 | -122.419222267617 | (37.7744118459669, -122.419222267617) | |
| 1516 | 1516 | 243951 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 14 | Width 5ft | Permit Number 47529 | 6007014.66541 | 2110083.11128 | 37.774282494675795 | -122.419184822535 | (37.7742824946758, -122.419184822535) | |
| 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) | |
| 1519 | 1519 | 243949 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 12 | Width 5ft | Permit Number 47529 | 6006997.017419999 | 2110160.92453 | 37.7744951573695 | -122.41925139124399 | (37.7744951573695, -122.419251391244) | |
| 1521 | 1521 | 243954 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 15 | Width 5ft | Permit Number 47529 | 6007048.80869 | 2109949.46518 | 37.773917457170796 | -122.41905723302 | (37.7739174571708, -122.41905723302) | |
| 1533 | 1533 | 243953 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 14 | Width 5ft | Permit Number 47529 | 6007037.92355 | 2109985.61989 | 37.7740161163944 | -122.41909745161301 | (37.7740161163944, -122.419097451613) | |
| 1601 | 1601 | 102430 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 200 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010566.09371 | 2111909.33227 | 37.779496235110706 | -122.407028471514 | (37.7794962351107, -122.407028471514) | |
| 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) | |
| 1634 | 1634 | 199504 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 1009 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770993 | 6010510.13491 | 2111932.18806 | 37.7795558601644 | -122.407223669342 | (37.7795558601644, -122.407223669342) | |
| 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) | |
| 1932 | 1932 | 252826 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 3852 17th St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1933 | 1933 | 252830 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 3852 17th St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1936 | 1936 | 252824 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 3852 17th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1938 | 1938 | 252827 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 3852 17th St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 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) | ||||
| 2853 | 2853 | 253248 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 570 Jessie St | 2 | 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) | |
| 2856 | 2856 | 253264 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2425 Ocean Ave | 3 | 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) | |
| 2897 | 2897 | 253249 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 570 Jessie St | 3 | 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) | |
| 3732 | 3732 | 15513 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2763 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6007075.5942 | 2102308.8178 | 37.7529395319689 | -122.41842269980101 | (37.7529395319689, -122.418422699801) | |||
| 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) | ||
| 4970 | 4970 | 253749 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 2x Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5020 | 5020 | 253748 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 2x Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 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) | ||||
| 9752 | 9752 | 173678 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 299x Beale St | 8 | 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) | |||||
| 10190 | 10190 | 173887 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 2931 20th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6009454.0 | 2104482.0 | 37.759040204703496 | -122.41035112011801 | (37.7590402047035, -122.410351120118) | |||||
| 10322 | 10322 | 15786 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 4840 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/04/2013 12:00:00 AM | 12 | 3x3 | 6001077.7653 | 2090502.844 | 37.7201836118857 | -122.43831855702 | (37.7201836118857, -122.43831855702) | ||
| 10337 | 10337 | 1859 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2500 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6010721.136519999 | 2086497.1887700001 | 37.7097286779125 | -122.404702624138 | (37.7097286779125, -122.404702624138) | |||
| 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) | ||
| 10446 | 10446 | 1841 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6011283.06964 | 2087344.7309400002 | 37.712087250691 | -122.40282003911301 | (37.712087250691, -122.402820039113) | |||
| 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) | ||
| 10560 | 10560 | 95252 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 4539 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002365.436000001 | 2092436.2557 | 37.7255654834992 | -122.434005647145 | (37.7255654834992, -122.434005647145) | |||
| 10709 | 10709 | 28542 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 5036 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6000555.9648 | 2089678.6918 | 37.7178909833984 | -122.44006317666401 | (37.7178909833984, -122.440063176664) | ||
| 10723 | 10723 | 1798 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/27/1991 12:00:00 AM | 12 | 6 | 6012206.26499 | 2088043.30695 | 37.714056906280604 | -122.39967820720899 | (37.7140569062806, -122.399678207209) | ||
| 10771 | 10771 | 28544 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 5060 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6000449.8979 | 2089508.0094 | 37.7174162891529 | -122.440417567822 | (37.7174162891529, -122.440417567822) | ||
| 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) | ||
| 10981 | 10981 | 1860 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2500 Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6 | 6010703.231369999 | 2086455.7019 | 37.709613762523205 | -122.404761589082 | (37.7096137625232, -122.404761589082) | |||
| 11001 | 11001 | 15823 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 5051 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000607.6416 | 2089644.9294 | 37.717801221251 | -122.439882133799 | (37.717801221251, -122.439882133799) | ||
| 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) | ||
| 11132 | 11132 | 1820 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/30/1991 12:00:00 AM | 3 | 6 | 6011846.03792 | 2087600.59079 | 37.7128212089973 | -122.400892211026 | (37.7128212089973, -122.400892211026) | ||
| 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) | ||
| 11170 | 11170 | 1796 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012245.53967 | 2088092.97358 | 37.714195470207 | -122.39954594300899 | (37.714195470207, -122.399545943009) | |||
| 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) | |||
| 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) | |||
| 11400 | 11400 | 1858 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2500 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010736.7682300005 | 2086529.19155 | 37.709817424799 | -122.404650849269 | (37.709817424799, -122.404650849269) | |||
| 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) | ||
| 11493 | 11493 | 15784 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 4840 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2015 02:53:00 PM | 3 | 3X3 | 6001135.2157 | 2090596.8347 | 37.7204449566644 | -122.438126700052 | (37.7204449566644, -122.438126700052) | ||
| 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) | |||
| 11567 | 11567 | 1857 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2500 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010751.52595 | 2086559.13987 | 37.7099004816803 | -122.404601950438 | (37.7099004816803, -122.404601950438) | |||
| 11580 | 11580 | 1821 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/30/1991 12:00:00 AM | 6 | 6 | 6011817.461569999 | 2087571.87835 | 37.712740776339295 | -122.400988964593 | (37.7127407763393, -122.400988964593) | ||
| 11630 | 11630 | 1793 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012296.32723 | 2088174.84774 | 37.7144231111167 | -122.399376144697 | (37.7144231111167, -122.399376144697) | |||
| 11710 | 11710 | 1795 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012264.68095 | 2088118.8470599998 | 37.714267580549105 | -122.399481598293 | (37.7142675805491, -122.399481598293) | |||
| 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) | ||
| 11934 | 11934 | 1822 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6011791.38112 | 2087549.257 | 37.7126772077525 | -122.401077519005 | (37.7126772077525, -122.401077519005) | |||
| 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) | ||
| 12160 | 12160 | 1842 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6 | 6011254.373459999 | 2087325.01114 | 37.7120315017345 | -122.402917835889 | (37.7120315017345, -122.402917835889) | |||
| 12292 | 12292 | 1840 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6011305.78262 | 2087356.70002 | 37.7121213835762 | -122.40274237725401 | (37.7121213835762, -122.402742377254) | |||
| 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) | |||
| 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) | ||
| 13232 | 13232 | 1794 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012280.2141 | 2088145.3083400002 | 37.7143411037303 | -122.399429765893 | (37.7143411037303, -122.399429765893) | |||
| 13652 | 13652 | 21866 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015620.2045 | 2106919.86703 | 37.766077793471396 | -122.38919550889099 | (37.7660777934714, -122.389195508891) | ||
| 13825 | 13825 | 21872 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015641.71858 | 2106711.03714 | 37.7655055845439 | -122.38910651286601 | (37.7655055845439, -122.389106512866) | ||
| 13833 | 13833 | 95855 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 185 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6010497.41028 | 2112077.91159 | 37.7799552706525 | -122.407277965014 | (37.7799552706525, -122.407277965014) | |||
| 13848 | 13848 | 21865 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015619.46662 | 2106949.47478 | 37.7661590490173 | -122.38920012868601 | (37.7661590490173, -122.389200128686) | ||
| 13867 | 13867 | 102421 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 101 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x4 | 6010161.06831 | 2112431.87946 | 37.780908353287394 | -122.40846650275199 | (37.7809083532874, -122.408466502752) | |||
| 14065 | 14065 | 95854 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 185 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6010514.67057 | 2112059.04775 | 37.779904440962504 | -122.407216923546 | (37.7799044409625, -122.407216923546) | |||
| 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) | |||
| 14545 | 14545 | 21876 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/1997 12:00:00 AM | 3 | 3X3 | 6015645.96934 | 2106615.37755 | 37.7652431596794 | -122.389085130597 | (37.7652431596794, -122.389085130597) | ||
| 14750 | 14750 | 21878 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015649.24797 | 2106571.51851 | 37.765122914002205 | -122.389070727941 | (37.7651229140022, -122.389070727941) | ||
| 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) | |||
| 15167 | 15167 | 21867 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/2008 12:00:00 AM | 3 | 3X3 | 6015621.91024 | 2106888.57721 | 37.765991972979606 | -122.389187423983 | (37.7659919729796, -122.389187423983) | ||
| 15554 | 15554 | 21874 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015644.57338 | 2106657.85439 | 37.7653597144938 | -122.38909292500901 | (37.7653597144938, -122.389092925009) | ||
| 15971 | 15971 | 21858 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1830 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2000 12:00:00 AM | 6 | 3X3 | 6015621.795940001 | 2107069.76565 | 37.7664894707397 | -122.389200472218 | (37.7664894707397, -122.389200472218) | ||
| 16399 | 16399 | 21870 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015638.72465 | 2106753.7729 | 37.765622761707604 | -122.38911985249399 | (37.7656227617076, -122.389119852494) |
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");