Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 661 | 661 | 237024 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 5 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:48:00 PM | 3 | Width 6ft | 6005763.84021 | 2109451.72322 | 37.772478334130994 | -122.423466764586 | (37.772478334131, -122.423466764586) | ||
| 3825 | 3825 | 253557 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1398 Tennessee St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 5ft | 6015583.67362 | 2102658.4010900003 | 37.7543746962452 | -122.38902430045499 | (37.7543746962452, -122.389024300455) | ||||
| 13371 | 13371 | 24145 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 100X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016696.89665 | 2095171.76192 | 37.7338795595807 | -122.384652980151 | (37.7338795595807, -122.384652980151) | |||
| 14845 | 14845 | 30632 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1690 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008058.1142 | 2108604.0472 | 37.770280041456104 | -122.415470596847 | (37.7702800414561, -122.415470596847) | |
| 15393 | 15393 | 11470 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6016849.3995 | 2095607.3792400002 | 37.7350841106266 | -122.38415605258001 | (37.7350841106266, -122.38415605258) | |||
| 16831 | 16831 | 16544 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016074.6462900005 | 2097992.47705 | 37.7415902397879 | -122.38700097152399 | (37.7415902397879, -122.387000971524) | |||
| 16955 | 16955 | 15610 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3350 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/1995 12:00:00 AM | 3 | 3x3 | 6006029.1794 | 2098644.8095 | 37.742820038399 | -122.421781171739 | (37.742820038399, -122.421781171739) | ||
| 23398 | 23398 | 138455 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002947.3238 | 2114874.0081 | 37.787207199109204 | -122.433596947338 | (37.7872071991092, -122.433596947338) | |||
| 26458 | 26458 | 139278 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 725 FULTON ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004349.2802 | 2111499.4808 | 37.7780210326226 | -122.42850585599199 | (37.7780210326226, -122.428505855992) | |||
| 28532 | 28532 | 120778 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 57 21st Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5989252.84217 | 2114809.1452099998 | 37.7862425746859 | -122.480971607416 | (37.7862425746859, -122.480971607416) | |||
| 28760 | 28760 | 136243 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1679 Washington St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006695.60451 | 2117001.64443 | 37.7932611216587 | -122.42077978456999 | (37.7932611216587, -122.42077978457) | |||
| 33428 | 33428 | 197157 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 106 Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6016598.7871900005 | 2095669.6865 | 37.7352413346217 | -122.385026857123 | (37.7352413346217, -122.385026857123) | |||
| 35711 | 35711 | 137620 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2280 Turk Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999093.1296 | 2111881.6822 | 37.7787716131699 | -122.446716192654 | (37.7787716131699, -122.446716192654) | |||
| 37326 | 37326 | 138443 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1820 POST ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003387.7672 | 2114195.0447 | 37.785367917648 | -122.432024606628 | (37.785367917648, -122.432024606628) | |||
| 38003 | 38003 | 136244 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1747 Clay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006363.52762 | 2116626.5882200003 | 37.7922125885856 | -122.42190214028099 | (37.7922125885856, -122.421902140281) | |||
| 39609 | 39609 | 42172 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 525 05th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 11 | Permit Number 42460 | 6012593.26461 | 2111204.07737 | 37.7776729981365 | -122.399966040597 | (37.7776729981365, -122.399966040597) | ||
| 40842 | 40842 | 197113 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2030 23rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6012295.98887 | 2102846.65042 | 37.7547087979762 | -122.40040724889299 | (37.7547087979762, -122.400407248893) | |||
| 41586 | 41586 | 197159 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 122 Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6016446.71962 | 2095806.9526900002 | 37.7356098273254 | -122.385562178561 | (37.7356098273254, -122.385562178561) | |||
| 44482 | 44482 | 213956 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994772.08022 | 2091060.8394799998 | 37.7213550620588 | -122.46015545460699 | (37.7213550620588, -122.460155454607) | |||
| 50135 | 50135 | 239285 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2750 18th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009605.3699900005 | 2105497.87366 | 37.761838047619904 | -122.40989932059901 | (37.7618380476199, -122.409899320599) | |||
| 52646 | 52646 | 136218 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2901 Steiner St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002000.868319999 | 2118219.4196099997 | 37.7963390882297 | -122.437111085304 | (37.7963390882297, -122.437111085304) | |||
| 62359 | 62359 | 197142 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 67 Jennings Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012879.123819999 | 2089210.84364 | 37.717300215014205 | -122.39743436542601 | (37.7173002150142, -122.397434365426) | |||
| 76655 | 76655 | 136268 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 220 Joice St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010216.49831 | 2116997.79235 | 37.7934483632051 | -122.40859693051901 | (37.7934483632051, -122.408596930519) | |||
| 79651 | 79651 | 96102 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2780X 18th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2011 12:00:00 AM | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865921999 | (37.7618258328219, -122.40992865922) | ||
| 85628 | 85628 | 49615 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1626 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | |||
| 95499 | 95499 | 111870 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3399x 16TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004303.0 | 2106535.0 | 37.7643871563547 | -122.428312038708 | (37.7643871563547, -122.428312038708) | ||||
| 97346 | 97346 | 16494 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 305X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2003 12:00:00 AM | 3 | 3x3 | 6016769.452380001 | 2098282.55627 | 37.7424251869258 | -122.384618745617 | (37.7424251869258, -122.384618745617) | ||
| 99727 | 99727 | 112868 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
| 104395 | 104395 | 111863 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 201x LOBOS ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x3 | 5994528.0 | 2088713.0 | 37.714894412350205 | -122.460829096166 | (37.7148944123502, -122.460829096166) | ||||
| 106341 | 106341 | 93816 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 178 Bluxome St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426001 | (37.7744697656056, -122.40000821426) | ||
| 106361 | 106361 | 8086 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 755X Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2001 12:00:00 AM | 6 | 3X3 | 6004351.32927 | 2111504.25977 | 37.7780342704524 | -122.428499108252 | (37.7780342704524, -122.428499108252) | ||
| 107726 | 107726 | 100414 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 201x Linden St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 767727 | 6006435.0 | 2110776.0 | 37.7761523386864 | -122.421239206856 | (37.7761523386864, -122.421239206856) | ||||
| 108008 | 108008 | 14770 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1000X McAllister St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 02/06/2016 08:42:00 AM | 3 | 4x4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | ||
| 111716 | 111716 | 111910 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1699x WASHINGTON ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006657.0 | 2116952.0 | 37.7931226344993 | -122.42090983270799 | (37.7931226344993, -122.420909832708) | ||||
| 113103 | 113103 | 16159 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999414.3973652 | 2094721.8518035999 | 37.731673280479 | -122.44437128480699 | (37.731673280479, -122.444371284807) | |||
| 113337 | 113337 | 121097 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1691 McAllister St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6001097.0 | 2111345.0 | 37.7774122850927 | -122.439745549 | (37.7774122850927, -122.439745549) | |||
| 114125 | 114125 | 41237 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 270 Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1999 12:00:00 AM | Permit Number 41940 | 5999013.40299918 | 2112000.64122659 | 37.7790936893244 | -122.447000559943 | (37.7790936893244, -122.447000559943) | |||
| 122919 | 122919 | 49987 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 300@ GOUGH Linden St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2003 12:00:00 AM | Permit Number 46733 | 6005944.16269933 | 2110905.42089734 | 37.7764800131905 | -122.42294634828801 | (37.7764800131905, -122.422946348288) | |||
| 123067 | 123067 | 34975 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 220 Jackson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1997 12:00:00 AM | Permit Number 38557 | 6012788.97638306 | 2118225.73375032 | 37.79696373512979 | -122.399782167941 | (37.7969637351298, -122.399782167941) | |||
| 129013 | 129013 | 96719 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1340 Clay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008320.0 | 2116937.0 | 37.7931750456071 | -122.41515467261601 | (37.7931750456071, -122.415154672616) | |||||
| 132038 | 132038 | 239321 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 78 Norwich St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6008940.36814 | 2099480.93118 | 37.74527958439511 | -122.411774130991 | (37.7452795843951, -122.411774130991) | ||||
| 132548 | 132548 | 136193 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2914 Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002531.20881 | 2118254.41346 | 37.79646530358411 | -122.43527850261002 | (37.7964653035841, -122.43527850261) | |||
| 139566 | 139566 | 24098 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 105X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016397.2233978 | 2096041.0813580002 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | ||
| 141172 | 141172 | 47636 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 301 Anza St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2002 12:00:00 AM | Permit Number 45452 | 5998206.68830303 | 2112594.29479697 | 37.7806775849758 | -122.44983409577299 | (37.7806775849758, -122.449834095773) | |||
| 142134 | 142134 | 8915 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 4455X Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5993265.0042 | 2112726.545 | 37.7807567282341 | -122.466939229172 | (37.7807567282341, -122.466939229172) | |||
| 145425 | 145425 | 88491 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Quesada Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51434 | 6015245.7 | 2094684.2 | 37.732460450023495 | -122.38963620788401 | (37.7324604500235, -122.389636207884) | ||
| 152806 | 152806 | 213966 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 621 Holloway Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994898.75092 | 2091213.04066 | 37.72178025523171 | -122.459728611213 | (37.7217802552317, -122.459728611213) | |||
| 154817 | 154817 | 240133 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 0 Chattanooga St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004672.52486 | 2103529.70008 | 37.756156217245604 | -122.426819912015 | (37.7561562172456, -122.426819912015) | |||
| 157156 | 157156 | 239261 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1400 Utah St | 5 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6010855.2107 | 2101671.833 | 37.751402557405896 | -122.405307149322 | (37.7514025574059, -122.405307149322) | |||
| 157489 | 157489 | 179290 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 97 Still St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6002318.3672 | 2094465.3447 | 37.7311342306478 | -122.43431336098601 | (37.7311342306478, -122.434313360986) | |||
| 157622 | 157622 | 200042 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1598 Lane St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015283.1003 | 2094689.2019 | 37.7324762579969 | -122.389507254289 | (37.7324762579969, -122.389507254289) | |||
| 160169 | 160169 | 197087 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014472.10243 | 2102198.29911 | 37.753049675611 | -122.39283624152 | (37.753049675611, -122.39283624152) | |||
| 161197 | 161197 | 48810 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014469.89088 | 2102291.4479400003 | 37.753305319601495 | -122.392850405821 | (37.7533053196015, -122.392850405821) | ||
| 167390 | 167390 | 140612 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 880 Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003492.8085 | 2111354.3072 | 37.777573917234996 | -122.431458329369 | (37.777573917235, -122.431458329369) | |||
| 170342 | 170342 | 240170 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1210 Shrader St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997763.42944 | 2106350.69035 | 37.763508882764796 | -122.45091719498699 | (37.7635088827648, -122.450917194987) | |||
| 177551 | 177551 | 213972 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995029.65711 | 2091072.52436 | 37.721401958108295 | -122.459265935174 | (37.7214019581083, -122.459265935174) | |||
| 178725 | 178725 | 197106 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014394.04215 | 2102037.78794 | 37.752604610114005 | -122.393094961165 | (37.752604610114, -122.393094961165) | |||
| 180496 | 180496 | 197133 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Newhall St | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6016812.9341400005 | 2098272.11729 | 37.742398928158295 | -122.384467670355 | (37.7423989281583, -122.384467670355) | |||
| 181096 | 181096 | 182748 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1789 30th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986861.6929 | 2103148.806 | 37.754087259353206 | -122.488386999785 | (37.7540872593532, -122.488386999785) | |||
| 188713 | 188713 | 138427 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 SUTTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003418.1055 | 2114492.1548 | 37.786185426920795 | -122.431940868192 | (37.7861854269208, -122.431940868192) |
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");