Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51372 | 51372 | 240081 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 310 Liberty St | 38 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6003924.401980001 | 2103934.2743599997 | 37.757224754829004 | -122.429436024577 | (37.757224754829, -122.429436024577) | |||
| 83383 | 83383 | 51179 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550& VICENTE 24th Ave | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | Permit Number 47565 | 5988957.29016327 | 2097975.36056036 | 37.740004392032496 | -122.48076127761298 | (37.7400043920325, -122.480761277613) | |||
| 124287 | 124287 | 51183 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550& VICENTE 24th Ave | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | Permit Number 47565 | 5988957.29016327 | 2097975.36056036 | 37.740004392032496 | -122.48076127761298 | (37.7400043920325, -122.480761277613) | |||
| 116844 | 116844 | 51182 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550& VICENTE 24th Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | Permit Number 47565 | 5988957.29016327 | 2097975.36056036 | 37.740004392032496 | -122.48076127761298 | (37.7400043920325, -122.480761277613) | |||
| 43478 | 43478 | 51181 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550& VICENTE 24th Ave | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | Permit Number 47565 | 5988957.29016327 | 2097975.36056036 | 37.740004392032496 | -122.48076127761298 | (37.7400043920325, -122.480761277613) | |||
| 84425 | 84425 | 51180 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550& VICENTE 24th Ave | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | Permit Number 47565 | 5988957.29016327 | 2097975.36056036 | 37.740004392032496 | -122.48076127761298 | (37.7400043920325, -122.480761277613) | |||
| 95461 | 95461 | 51178 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550& VICENTE 24th Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | Permit Number 47565 | 5988957.29016327 | 2097975.36056036 | 37.740004392032496 | -122.48076127761298 | (37.7400043920325, -122.480761277613) | |||
| 127545 | 127545 | 51177 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550& VICENTE 24th Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | Permit Number 47565 | 5988957.29016327 | 2097975.36056036 | 37.740004392032496 | -122.48076127761298 | (37.7400043920325, -122.480761277613) | |||
| 142484 | 142484 | 51168 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550& VICENTE 24th Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | Permit Number 47565 | 5988957.29016327 | 2097975.36056036 | 37.740004392032496 | -122.48076127761298 | (37.7400043920325, -122.480761277613) | |||
| 89704 | 89704 | 51176 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550& VICENTE 24th Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | Permit Number 47565 | 5988957.29016327 | 2097975.36056036 | 37.740004392032496 | -122.48076127761298 | (37.7400043920325, -122.480761277613) | |||
| 121816 | 121816 | 51185 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550& VICENTE 24th Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | Permit Number 47565 | 5988957.29016327 | 2097975.36056036 | 37.740004392032496 | -122.48076127761298 | (37.7400043920325, -122.480761277613) | |||
| 114889 | 114889 | 51175 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550& VICENTE 24th Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | Permit Number 47565 | 5988957.29016327 | 2097975.36056036 | 37.740004392032496 | -122.48076127761298 | (37.7400043920325, -122.480761277613) | |||
| 86138 | 86138 | 51174 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550& VICENTE 24th Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | Permit Number 47565 | 5988957.29016327 | 2097975.36056036 | 37.740004392032496 | -122.48076127761298 | (37.7400043920325, -122.480761277613) | |||
| 150112 | 150112 | 136078 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2501 Jackson St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002125.65368 | 2116692.08 | 37.792152502181004 | -122.43656992546002 | (37.792152502181, -122.43656992546) | |||
| 84563 | 84563 | 51173 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550& VICENTE 24th Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | Permit Number 47565 | 5988957.29016327 | 2097975.36056036 | 37.740004392032496 | -122.48076127761298 | (37.7400043920325, -122.480761277613) | |||
| 123545 | 123545 | 45722 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 235 02nd St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2001 12:00:00 AM | Permit Number 44392 | 6013350.5591251 | 2114341.46161867 | 37.7863297261158 | -122.397566379799 | (37.7863297261158, -122.397566379799) | |||
| 123141 | 123141 | 51166 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550& VICENTE 24th Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | Permit Number 47565 | 5988957.29016327 | 2097975.36056036 | 37.740004392032496 | -122.48076127761298 | (37.7400043920325, -122.480761277613) | |||
| 127205 | 127205 | 45721 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 235 02nd St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2001 12:00:00 AM | Permit Number 44392 | 6013350.5591251 | 2114341.46161867 | 37.7863297261158 | -122.397566379799 | (37.7863297261158, -122.397566379799) | |||
| 94261 | 94261 | 45725 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 235 02nd St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2001 12:00:00 AM | Permit Number 44392 | 6013350.5591251 | 2114341.46161867 | 37.7863297261158 | -122.397566379799 | (37.7863297261158, -122.397566379799) | |||
| 116565 | 116565 | 51160 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550& VICENTE 24th Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | Permit Number 47565 | 5988957.29016327 | 2097975.36056036 | 37.740004392032496 | -122.48076127761298 | (37.7400043920325, -122.480761277613) | |||
| 179083 | 179083 | 196694 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 502 Beale St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6015915.20756 | 2113918.4239 | 37.785310630932 | -122.38866373346501 | (37.785310630932, -122.388663733465) | |||
| 84048 | 84048 | 45726 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 235 02nd St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2001 12:00:00 AM | Permit Number 44392 | 6013350.5591251 | 2114341.46161867 | 37.7863297261158 | -122.397566379799 | (37.7863297261158, -122.397566379799) | |||
| 96867 | 96867 | 45727 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 235 02nd St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2001 12:00:00 AM | Permit Number 44392 | 6013350.5591251 | 2114341.46161867 | 37.7863297261158 | -122.397566379799 | (37.7863297261158, -122.397566379799) | |||
| 109211 | 109211 | 51194 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550& VICENTE 24th Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | Permit Number 47565 | 5988957.29016327 | 2097975.36056036 | 37.740004392032496 | -122.48076127761298 | (37.7400043920325, -122.480761277613) | |||
| 111938 | 111938 | 45728 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 235 02nd St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2001 12:00:00 AM | Permit Number 44392 | 6013350.5591251 | 2114341.46161867 | 37.7863297261158 | -122.397566379799 | (37.7863297261158, -122.397566379799) | |||
| 161749 | 161749 | 239910 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 601 Alabama St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009020.0831 | 2105369.72769 | 37.7614533689055 | -122.41191454753799 | (37.7614533689055, -122.411914547538) | |||
| 19693 | 19693 | 45729 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 235 02nd St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2001 12:00:00 AM | Permit Number 44392 | 6013350.5591251 | 2114341.46161867 | 37.7863297261158 | -122.397566379799 | (37.7863297261158, -122.397566379799) | |||
| 173106 | 173106 | 239911 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 601 Alabama St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009016.60579 | 2105348.13199 | 37.761393876959 | -122.411925048025 | (37.761393876959, -122.411925048025) | |||
| 87871 | 87871 | 49359 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1875@ EVANS Marin St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2003 12:00:00 AM | Permit Number 46338 | 6013645.17254623 | 2100501.4512395 | 37.7483445287597 | -122.39557707183201 | (37.7483445287597, -122.395577071832) | |||
| 121668 | 121668 | 45730 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 235 02nd St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2001 12:00:00 AM | Permit Number 44392 | 6013350.5591251 | 2114341.46161867 | 37.7863297261158 | -122.397566379799 | (37.7863297261158, -122.397566379799) | |||
| 136549 | 136549 | 238954 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 601 Alabama St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009016.011940001 | 2105344.62154 | 37.761384204748296 | -122.411926853834 | (37.7613842047483, -122.411926853834) | |||
| 2660 | 2660 | 37827 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 450X Moscow St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003888.33038 | 2090432.03853 | 37.7201486548235 | -122.428598328547 | (37.7201486548235, -122.428598328547) |
| 20548 | 20548 | 16117 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999494.77273 | 2094682.2963900003 | 37.7315692561142 | -122.444090570848 | (37.7315692561142, -122.444090570848) | |||
| 37922 | 37922 | 196851 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 385 Channel | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014284.65568 | 2109239.1617 | 37.7723719344444 | -122.3939773139 | (37.7723719344444, -122.3939773139) | |||
| 98104 | 98104 | 45742 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 235 02nd St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2001 12:00:00 AM | Permit Number 44392 | 6013350.5591251 | 2114341.46161867 | 37.7863297261158 | -122.397566379799 | (37.7863297261158, -122.397566379799) | |||
| 106231 | 106231 | 104584 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 201X Channel St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | 6011985.487369999 | 2113104.0493099997 | 37.7828559770513 | -122.402202175758 | (37.7828559770513, -122.402202175758) | ||||
| 124464 | 124464 | 49360 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1875@ EVANS Marin St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2003 12:00:00 AM | Permit Number 46338 | 6013645.17254623 | 2100501.4512395 | 37.7483445287597 | -122.39557707183201 | (37.7483445287597, -122.395577071832) | |||
| 2647 | 2647 | 37826 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 450X Moscow St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003896.37457 | 2090444.78719 | 37.7201841150858 | -122.42857143074801 | (37.7201841150858, -122.428571430748) |
| 20825 | 20825 | 16116 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 5999533.21631 | 2094681.49769 | 37.7315692561025 | -122.443957606973 | (37.7315692561025, -122.443957606973) | |||
| 62648 | 62648 | 196806 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 211 Channel | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014916.1836 | 2109854.46863 | 37.7740965085709 | -122.39183581408301 | (37.7740965085709, -122.391835814083) | |||
| 64538 | 64538 | 183484 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2561 24th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988917.6193 | 2097719.8818 | 37.739300608006 | -122.480879741595 | (37.739300608006, -122.480879741595) | |||
| 70115 | 70115 | 196850 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 385 Channel | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014268.35997 | 2109223.57854 | 37.7723282408876 | -122.394032591628 | (37.7723282408876, -122.394032591628) | |||
| 70194 | 70194 | 239055 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 10 12th St | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 6006788.78316 | 2110077.3604200003 | 37.7742539807578 | -122.41996578389299 | (37.7742539807578, -122.419965783893) | |||
| 78200 | 78200 | 33885 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100 Bush St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1997 12:00:00 AM | Permit Number 37864 | 6012794.22809133 | 2116196.61186458 | 37.79139254050121 | -122.399621455512 | (37.7913925405012, -122.399621455512) | |||
| 82434 | 82434 | 93704 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550 25th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52753 | 5988779.9 | 2097863.1 | 37.7396858417248 | -122.481366393427 | (37.7396858417248, -122.481366393427) | ||
| 88336 | 88336 | 104260 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 8 Octavia St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | |||
| 101350 | 101350 | 49361 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1875@ EVANS Marin St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2003 12:00:00 AM | Permit Number 46338 | 6013645.17254623 | 2100501.4512395 | 37.7483445287597 | -122.39557707183201 | (37.7483445287597, -122.395577071832) | |||
| 106441 | 106441 | 45731 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 235 02nd St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2001 12:00:00 AM | Permit Number 44392 | 6013350.5591251 | 2114341.46161867 | 37.7863297261158 | -122.397566379799 | (37.7863297261158, -122.397566379799) | |||
| 110520 | 110520 | 104583 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 201X Channel St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | 6011985.487369999 | 2113104.0493099997 | 37.7828559770513 | -122.402202175758 | (37.7828559770513, -122.402202175758) | ||||
| 132568 | 132568 | 213779 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401x Monterey Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 4ft | 5998879.57 | 2094689.9786099999 | 37.7315552347673 | -122.446217990889 | (37.7315552347673, -122.446217990889) | |||
| 149075 | 149075 | 238953 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 601 Alabama St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009017.69359 | 2105304.84373 | 37.7612750783146 | -122.411918226669 | (37.7612750783146, -122.411918226669) | |||
| 165891 | 165891 | 93690 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550 25th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52753 | 5988641.89 | 2098003.3381 | 37.7400628739271 | -122.481853837176 | (37.7400628739271, -122.481853837176) | |
| 17393 | 17393 | 16115 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/24/1998 12:00:00 AM | 3 | 5 | 5999569.73094 | 2094680.4197799999 | 37.7315683792686 | -122.44383129178101 | (37.7315683792686, -122.443831291781) | ||
| 20354 | 20354 | 27346 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4 | 6000818.28486 | 2094659.29899 | 37.731581524667504 | -122.43951329411301 | (37.7315815246675, -122.439513294113) | |||
| 27159 | 27159 | 213778 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401x Monterey Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 4ft | 5998914.18909 | 2094690.21596 | 37.7315578635039 | -122.446098323489 | (37.7315578635039, -122.446098323489) | |||
| 44483 | 44483 | 196693 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 502 Beale St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 6ft | 6015794.135319999 | 2114043.36166 | 37.7856469710674 | -122.38909133681801 | (37.7856469710674, -122.389091336818) | |||
| 47524 | 47524 | 196849 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 385 Channel | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014250.97804 | 2109206.9561799997 | 37.772281633521 | -122.394091553888 | (37.772281633521, -122.394091553888) | |||
| 71807 | 71807 | 238952 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 601 Alabama St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009019.51387 | 2105287.10846 | 37.761226483437 | -122.41191067775699 | (37.761226483437, -122.411910677757) | |||
| 75519 | 75519 | 93689 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550 25th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52753 | 5988641.89 | 2097990.3646 | 37.7400272520846 | -122.481852887106 | (37.7400272520846, -122.481852887106) | |
| 86450 | 86450 | 93703 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550 25th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52753 | 5988779.9 | 2097863.1 | 37.7396858417248 | -122.481366393427 | (37.7396858417248, -122.481366393427) | ||
| 89723 | 89723 | 102497 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2001 McAllister St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999572.3 | 2111193.9 | 37.7769105000816 | -122.445009103471 | (37.7769105000816, -122.445009103471) | ||||
| 96065 | 96065 | 33886 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100 Bush St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1997 12:00:00 AM | Permit Number 37864 | 6012794.22809133 | 2116196.61186458 | 37.79139254050121 | -122.399621455512 | (37.7913925405012, -122.399621455512) | |||
| 97145 | 97145 | 104582 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 201X Channel St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | Permit Number 769108 | 6011985.487369999 | 2113104.0493099997 | 37.7828559770513 | -122.402202175758 | (37.7828559770513, -122.402202175758) | |||
| 102893 | 102893 | 49364 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1875@ EVANS Marin St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2003 12:00:00 AM | Permit Number 46338 | 6013645.17254623 | 2100501.4512395 | 37.7483445287597 | -122.39557707183201 | (37.7483445287597, -122.395577071832) | |||
| 114478 | 114478 | 104259 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 8X Octavia St Frontage East | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | |||
| 141367 | 141367 | 45724 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 235 02nd St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2001 12:00:00 AM | Permit Number 44392 | 6013350.5591251 | 2114341.46161867 | 37.7863297261158 | -122.397566379799 | (37.7863297261158, -122.397566379799) | |||
| 148416 | 148416 | 239054 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 10 12th St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6006799.36915 | 2110063.88377 | 37.7742175735042 | -122.41992820843599 | (37.7742175735042, -122.419928208436) | |||
| 158830 | 158830 | 196792 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 209 Channel | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014652.626180001 | 2109602.84073 | 37.773390959846296 | -122.392729905686 | (37.7733909598463, -122.392729905686) | |||
| 168397 | 168397 | 74565 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2 Townsend St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 9 | 6015593.8419 | 2112504.14165 | 37.781409515787104 | -122.38967675677601 | (37.7814095157871, -122.389676756776) | ||
| 168637 | 168637 | 183483 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2559 24th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5988916.9938 | 2097744.589 | 37.7393684111887 | -122.480883712714 | (37.7393684111887, -122.480883712714) | |||
| 179287 | 179287 | 196805 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 211 Channel | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014888.39977 | 2109828.7360099996 | 37.7740243100987 | -122.391930124193 | (37.7740243100987, -122.391930124193) | |||
| 20950 | 20950 | 16018 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/17/1999 12:00:00 AM | 3 | 4 | 6000862.51501 | 2094659.33961 | 37.7315841533767 | -122.439360385099 | (37.7315841533767, -122.439360385099) | ||
| 22037 | 22037 | 16114 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/24/1998 12:00:00 AM | 3 | 5 | 5999608.79533 | 2094678.6509200002 | 37.731565750540206 | -122.44369611198299 | (37.7315657505402, -122.443696111983) | ||
| 23900 | 23900 | 136080 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2451 Steiner St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6002277.07488 | 2116237.64468 | 37.7909133434315 | -122.43601347444799 | (37.7909133434315, -122.436013474448) | |||
| 29105 | 29105 | 102496 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2001 McAllister St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 5999527.3247 | 2111175.3959 | 37.7768571255416 | -122.445163355541 | (37.7768571255416, -122.445163355541) | |||
| 41060 | 41060 | 213777 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401x Monterey Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 4ft | 5998950.72386 | 2094690.09449 | 37.7315596162741 | -122.445972007429 | (37.7315596162741, -122.445972007429) | |||
| 47850 | 47850 | 183482 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2557 24th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988916.0555 | 2097769.2962 | 37.7394361961884 | -122.480888765352 | (37.7394361961884, -122.480888765352) | |||
| 50788 | 50788 | 196804 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 211 Channel | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014868.70221 | 2109810.10844 | 37.7739720693771 | -122.391996959086 | (37.7739720693771, -122.391996959086) | |||
| 55085 | 55085 | 196658 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 91 Tehama St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6013523.83849 | 2114536.06155 | 37.7868736994142 | -122.39698052252899 | (37.7868736994142, -122.396980522529) | |||
| 75126 | 75126 | 196848 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 385 Channel | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014231.50905 | 2109192.4978099996 | 37.7722408519556 | -122.394157886978 | (37.7722408519556, -122.394157886978) | |||
| 77102 | 77102 | 74718 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2 Townsend St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 4 | 6015601.81755 | 2112509.3684400003 | 37.781424309627106 | -122.38964952982501 | (37.7814243096271, -122.389649529825) | ||
| 82374 | 82374 | 45733 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 235 02nd St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2001 12:00:00 AM | Permit Number 44392 | 6013350.5591251 | 2114341.46161867 | 37.7863297261158 | -122.397566379799 | (37.7863297261158, -122.397566379799) | |||
| 101432 | 101432 | 104258 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 8X Octavia St Frontage East | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | |||
| 102539 | 102539 | 33883 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100 Bush St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1997 12:00:00 AM | Permit Number 37864 | 6012794.22809133 | 2116196.61186458 | 37.79139254050121 | -122.399621455512 | (37.7913925405012, -122.399621455512) | |||
| 111295 | 111295 | 104581 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 201X Channel St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | 6011985.487369999 | 2113104.0493099997 | 37.7828559770513 | -122.402202175758 | (37.7828559770513, -122.402202175758) | ||||
| 116065 | 116065 | 93688 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550 25th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52753 | 5988779.9 | 2097863.1 | 37.7396858417248 | -122.481366393427 | (37.7396858417248, -122.481366393427) | ||
| 121969 | 121969 | 49355 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1875@ EVANS Marin St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2003 12:00:00 AM | Permit Number 46338 | 6013645.17254623 | 2100501.4512395 | 37.7483445287597 | -122.39557707183201 | (37.7483445287597, -122.395577071832) | |||
| 131231 | 131231 | 196719 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 85 Townsend St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6015884.14477 | 2112614.91182 | 37.7817297589616 | -122.38868017576799 | (37.7817297589616, -122.388680175768) | |||
| 132225 | 132225 | 196692 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 502 Beale St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6015791.08519 | 2114056.4297700003 | 37.7856826840566 | -122.389102802258 | (37.7856826840566, -122.389102802258) | |||
| 147346 | 147346 | 238951 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 601 Alabama St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6009021.32147 | 2105268.75213 | 37.7611761825582 | -122.411903128821 | (37.7611761825582, -122.411903128821) | |||
| 148158 | 148158 | 93702 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550 25th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52753 | 5988642.9279 | 2097975.5749 | 37.7399867037902 | -122.481848215448 | (37.7399867037902, -122.481848215448) | |
| 162423 | 162423 | 239053 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 10 12th St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6006813.80827 | 2110050.32774 | 37.7741811653527 | -122.41987729869301 | (37.7741811653527, -122.419877298693) | |||
| 186862 | 186862 | 196791 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 209 Channel | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014640.47639 | 2109590.9368 | 37.7733575994987 | -122.39277110091999 | (37.7733575994987, -122.39277110092) | |||
| 17126 | 17126 | 16113 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/24/1998 12:00:00 AM | 3 | 5 | 5999657.47743 | 2094677.0013700002 | 37.7315639977654 | -122.443527690574 | (37.7315639977654, -122.443527690574) | ||
| 20419 | 20419 | 16017 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4 | 6000892.30856 | 2094658.72213 | 37.7315841533843 | -122.43925733896002 | (37.7315841533843, -122.43925733896) | |||
| 27112 | 27112 | 196886 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 433 Clementina St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011428.028580001 | 2112266.0356400004 | 37.780523855317 | -122.404071765908 | (37.780523855317, -122.404071765908) | |||
| 36552 | 36552 | 196869 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 434 Clementina St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011234.93061 | 2112121.10143 | 37.780115108976496 | -122.40472958041799 | (37.7801151089765, -122.404729580418) | |||
| 37261 | 37261 | 74866 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 2 Townsend St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 7 | 6015612.0948 | 2112518.9573 | 37.7814512083448 | -122.389614645118 | (37.7814512083448, -122.389614645118) | ||
| 40831 | 40831 | 239052 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 10 12th St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 6006844.34478 | 2110018.64538 | 37.7740958934492 | -122.419769418744 | (37.7740958934492, -122.419769418744) | |||
| 44818 | 44818 | 241264 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 32 Harry St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6003140.40772 | 2097623.29696 | 37.739851871854704 | -122.43169680777399 | (37.7398518718547, -122.431696807774) |
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");