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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 257 | 257 | 251260 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1163 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6007684.87734 | 2102881.8281400003 | 37.754547168222295 | -122.41635626045701 | (37.7545471682223, -122.416356260457) | ||||
| 1522 | 1522 | 251579 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 7 Richards Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Width 3ft | 6016313.63012 | 2095884.37873 | 37.735815058901 | -122.386027719813 | (37.735815058901, -122.386027719813) | ||||
| 2490 | 2490 | 119764 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X Octavia St Frontage West | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2496 | 2496 | 119765 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X Octavia St Frontage West | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2509 | 2509 | 119763 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 101X Octavia St Frontage West | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 3007 | 3007 | 253279 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 201X Laguna Honda Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 10x10 | ROW IS 10' tree is street tree | ||||||||
| 3897 | 3897 | 253589 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 365x 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6011360.0 | 2111196.0 | 37.7775819849571 | -122.404231777509 | (37.7775819849571, -122.404231777509) | ||||
| 9745 | 9745 | 47282 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2810 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2002 12:00:00 AM | 3x3 | Permit Number 45227 | 6010345.86300325 | 2101091.40389861 | 37.7497803366023 | -122.407027634693 | (37.7497803366023, -122.407027634693) | |
| 10268 | 10268 | 49966 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4620 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2003 12:00:00 AM | Permit Number 46718 | 6000426.47543442 | 2105220.01428839 | 37.7605564179186 | -122.44162544737301 | (37.7605564179186, -122.441625447373) | |||
| 17980 | 17980 | 51193 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550& VICENTE 24th Ave | 6 | 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) | |||
| 18570 | 18570 | 119857 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401 Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 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) | |||
| 20619 | 20619 | 42911 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2900 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42822 | 6008853.88469765 | 2103932.85927525 | 37.7574987299949 | -122.412387795343 | (37.7574987299949, -122.412387795343) | ||
| 20869 | 20869 | 41252 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 155 Minna St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1999 12:00:00 AM | Permit Number 41945 | 6012533.02981985 | 2114448.22388081 | 37.7865773148555 | -122.40040234125 | (37.7865773148555, -122.40040234125) | |||
| 21235 | 21235 | 63156 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1483 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1986 12:00:00 AM | Permit Number 23692 | 5992405.6320278 | 2105370.20909848 | 37.7605085633711 | -122.46937656879999 | (37.7605085633711, -122.4693765688) | ||
| 28914 | 28914 | 102881 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 5075 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2013 12:00:00 AM | 3x3 | 6014754.3 | 2094747.4 | 37.7326067241724 | -122.39133952421801 | (37.7326067241724, -122.391339524218) | |||
| 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) | |||
| 47987 | 47987 | 68761 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 50 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/1997 12:00:00 AM | Permit Number 32684 | 6003960.97119147 | 2105124.66245865 | 37.7604953479062 | -122.42939444048099 | (37.7604953479062, -122.429394440481) | ||
| 48374 | 48374 | 46228 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 55 02nd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2002 12:00:00 AM | Permit Number 44531 | 6012528.68122922 | 2115201.03212894 | 37.788644107377294 | -122.40047028530898 | (37.7886441073773, -122.400470285309) | |||
| 49223 | 49223 | 67218 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 67 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1992 12:00:00 AM | Permit Number 30674 | 6004275.36148655 | 2108843.45765699 | 37.770724059917605 | -122.428572194222 | (37.7707240599176, -122.428572194222) | ||
| 49225 | 49225 | 104579 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 201X Channel St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | 6011985.487369999 | 2113104.0493099997 | 37.7828559770513 | -122.402202175758 | (37.7828559770513, -122.402202175758) | ||||
| 50085 | 50085 | 111739 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 498x 11TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992500.0 | 2112397.0 | 37.7798077038492 | -122.46956172871201 | (37.7798077038492, -122.469561728712) | ||||
| 53599 | 53599 | 39870 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 3626 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41421 | 6006079.92775485 | 2101440.50496023 | 37.750499244033705 | -122.421804236007 | (37.7504992440337, -122.421804236007) | ||
| 53605 | 53605 | 93686 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550 25th Ave | 10 | 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) | ||
| 55715 | 55715 | 102680 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 333 Eucalyptus Dr | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133154995 | -122.476573573496 | (37.731002133155, -122.476573573496) | |||
| 58704 | 58704 | 34495 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 185 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38218 | 6008672.47995951 | 2097726.39703626 | 37.7404469880804 | -122.4125764416 | (37.7404469880804, -122.4125764416) | ||
| 65545 | 65545 | 44234 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 599 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2001 12:00:00 AM | Permit Number 43674 | 6014264.27015126 | 2112071.58281381 | 37.7801479924912 | -122.39424617094299 | (37.7801479924912, -122.394246170943) | |||
| 70840 | 70840 | 41321 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2501 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2000 12:00:00 AM | Permit Number 41987 | 6008891.76752422 | 2103891.36263257 | 37.757386915423005 | -122.41225384799499 | (37.757386915423, -122.412253847995) | |||
| 73846 | 73846 | 104571 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 201X Channel St | 2 | 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) | |||
| 76339 | 76339 | 101357 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2201X Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 5x5 | Permit Number 32655 | 6008936.1 | 2120783.7 | 37.803771736238 | -122.41329507143601 | (37.803771736238, -122.413295071436) | ||
| 76814 | 76814 | 67177 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 39 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | Permit Number 30623 | 6006917.58798394 | 2097076.37412002 | 37.7385635241286 | -122.418598100484 | (37.7385635241286, -122.418598100484) | ||
| 77388 | 77388 | 115447 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300 Octavia St Frontage East | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 77421 | 77421 | 39744 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 568 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41111 | 6004231.58576423 | 2105585.83448235 | 37.761776933767706 | -122.428491380996 | (37.7617769337677, -122.428491380996) | ||
| 77647 | 77647 | 47952 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 284 Los Palmos Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45682 | 5997872.43575123 | 2096301.72488979 | 37.7359231369177 | -122.44981594322701 | (37.7359231369177, -122.449815943227) | ||
| 77736 | 77736 | 92791 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 316 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2009 12:00:00 AM | 3x3 | Permit Number 53009 | 6001119.0 | 2104484.0 | 37.7585749344406 | -122.439177572722 | (37.7585749344406, -122.439177572722) | ||
| 77756 | 77756 | 38014 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 33 Ardenwood Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | Permit Number 40225 | 5991299.44143565 | 2096251.1163118 | 37.735405911148604 | -122.472537488142 | (37.7354059111486, -122.472537488142) | |||
| 77775 | 77775 | 102678 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 333 Eucalyptus Dr | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133154995 | -122.476573573496 | (37.731002133155, -122.476573573496) | |||
| 77839 | 77839 | 50269 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 287 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | Permit Number 46974 | 6006321.20125143 | 2096107.66060659 | 37.7358700580341 | -122.42059137705601 | (37.7358700580341, -122.420591377056) | ||
| 77852 | 77852 | 119848 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 355 Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 78036 | 78036 | 41518 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 208 Peninsula Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | Permit Number 42062 | 6012484.96446964 | 2087604.06197755 | 37.712866358901294 | -122.398684103253 | (37.7128663589013, -122.398684103253) | |||
| 78148 | 78148 | 40833 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 150 Spear St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/1999 12:00:00 AM | Permit Number 41765 | 6014612.03281771 | 2116330.74454319 | 37.7918619982363 | -122.393341229651 | (37.7918619982363, -122.393341229651) | |||
| 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) | |||
| 78311 | 78311 | 36997 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2879 23rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/1998 12:00:00 AM | Permit Number 39616 | 6009576.40115772 | 2102750.87061758 | 37.754293773618606 | -122.409805600758 | (37.7542937736186, -122.409805600758) | |||
| 78389 | 78389 | 84467 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 400x CAPP ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50583 | 6007151.0 | 2104940.0 | 37.760168397803895 | -122.418348476166 | (37.7601683978039, -122.418348476166) | ||
| 78454 | 78454 | 46709 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1741 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44839 | 5997384.395715901 | 2108098.43118726 | 37.7682860273406 | -122.452354269766 | (37.7682860273406, -122.452354269766) | ||
| 78496 | 78496 | 67777 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1992 12:00:00 AM | Permit Number 31410 | 6002409.66817054 | 2108299.95353081 | 37.7691259721047 | -122.43498677415 | (37.7691259721047, -122.43498677415) | ||
| 78700 | 78700 | 101360 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2201X Mason St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 5x5 | Permit Number 32655 | 6008936.1 | 2120783.7 | 37.803771736238 | -122.41329507143601 | (37.803771736238, -122.413295071436) | ||
| 78702 | 78702 | 51189 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550& VICENTE 24th Ave | 2 | 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) | |||
| 78713 | 78713 | 104578 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 201X Channel St | 9 | 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) | |||
| 79236 | 79236 | 98871 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1X Tehama St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x3 | Permit No. 53568 | 6013910.7 | 2114841.3 | 37.7877333404996 | -122.395663455814 | (37.7877333404996, -122.395663455814) | |||
| 79779 | 79779 | 47776 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1444 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2002 12:00:00 AM | Permit Number 45552 | 5990868.7531859 | 2105564.91366324 | 37.7609542357008 | -122.474706084902 | (37.7609542357008, -122.474706084902) | ||
| 79838 | 79838 | 43713 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 319 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43354 | 5994720.21130865 | 2090709.86528617 | 37.7203883873178 | -122.460309333031 | (37.7203883873178, -122.460309333031) | ||
| 79859 | 79859 | 93117 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2033 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2009 12:00:00 AM | 3x3 | Permit Number 777147 | 6000411.0 | 2115602.0 | 37.7890618407655 | -122.442424340369 | (37.7890618407655, -122.442424340369) | ||
| 79883 | 79883 | 104573 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 201X Channel St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | 6011985.487369999 | 2113104.0493099997 | 37.7828559770513 | -122.402202175758 | (37.7828559770513, -122.402202175758) | ||||
| 79915 | 79915 | 104592 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 600 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009795.0 | 2105479.0 | 37.7617968506256 | -122.409242130861 | (37.7617968506256, -122.409242130861) | ||||
| 79929 | 79929 | 38131 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 110 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1998 12:00:00 AM | Permit Number 40293 | 6010183.36335526 | 2094089.0979682 | 37.7305444209455 | -122.40709605392999 | (37.7305444209455, -122.40709605393) | ||
| 80112 | 80112 | 111892 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 380 14TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006217.0 | 2107886.0 | 37.7682047987229 | -122.421788003363 | (37.7682047987229, -122.421788003363) | ||||
| 80165 | 80165 | 41724 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 69 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2004 12:00:00 AM | Permit Number 42171 | 6006258.9056789 | 2108480.50590198 | 37.7698395335412 | -122.421685286607 | (37.7698395335412, -122.421685286607) | ||
| 80314 | 80314 | 32530 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 40 Porter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37032 | 6006995.40841562 | 2095619.71276472 | 37.7345682345039 | -122.418225786917 | (37.7345682345039, -122.418225786917) | ||
| 80322 | 80322 | 65255 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1040 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28054 | 6009412.00767636 | 2103111.21545962 | 37.755273985498 | -122.410399559399 | (37.755273985498, -122.410399559399) | ||
| 80500 | 80500 | 119861 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 451X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 80529 | 80529 | 66914 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 90 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1991 12:00:00 AM | Permit Number 30234 | 6007937.13560289 | 2098197.14787292 | 37.741698268956206 | -122.41515229567499 | (37.7416982689562, -122.415152295675) | ||
| 80591 | 80591 | 104589 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2711 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009734.8 | 2105398.2 | 37.7615716193074 | -122.40944463693998 | (37.7615716193074, -122.40944463694) | ||||
| 80898 | 80898 | 37679 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 190 Capp St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | Permit Number 40073 | 6007090.19177002 | 2106208.83641672 | 37.7636489041282 | -122.418648763754 | (37.7636489041282, -122.418648763754) | ||
| 80973 | 80973 | 44236 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 599 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2001 12:00:00 AM | Permit Number 43674 | 6014264.27015126 | 2112071.58281381 | 37.7801479924912 | -122.39424617094299 | (37.7801479924912, -122.394246170943) | |||
| 81229 | 81229 | 43714 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 322 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43355 | 5994772.66402913 | 2090734.25116914 | 37.72045836224321 | -122.460129788058 | (37.7204583622432, -122.460129788058) | ||
| 81267 | 81267 | 40725 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 224 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/1999 12:00:00 AM | Permit Number 41704 | 6008980.81051683 | 2097343.97945273 | 37.7394142523581 | -122.411483340406 | (37.7394142523581, -122.411483340406) | ||
| 81276 | 81276 | 93699 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550 25th Ave | 9 | 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) | ||
| 81458 | 81458 | 41517 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 208 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | Permit Number 42062 | 6012484.96446964 | 2087604.06197755 | 37.712866358901294 | -122.398684103253 | (37.7128663589013, -122.398684103253) | |||
| 81704 | 81704 | 67900 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 27 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31602 | 5997414.12131199 | 2093627.0661451 | 37.728552929424296 | -122.451207680238 | (37.7285529294243, -122.451207680238) | ||
| 81896 | 81896 | 33834 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1676 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | Permit Number 41872 | 5998550.82095945 | 2109008.11152707 | 37.7708505329816 | -122.448385252011 | (37.7708505329816, -122.448385252011) | ||
| 82150 | 82150 | 41158 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 101 02nd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1999 12:00:00 AM | Permit Number 41886 | 6012741.49712788 | 2114978.50959787 | 37.788044978457705 | -122.39971833851801 | (37.7880449784577, -122.399718338518) | |||
| 82294 | 82294 | 46321 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1081 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2003 12:00:00 AM | Permit Number 44575 | 6008661.50268126 | 2102262.13718449 | 37.7529005072206 | -122.412935008702 | (37.7529005072206, -122.412935008702) | ||
| 82366 | 82366 | 93677 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2550 25th Ave | 1 | 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) | ||
| 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) | |||
| 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) | ||
| 82588 | 82588 | 37570 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 4000 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40003 | 6002110.61777636 | 2103565.66487621 | 37.7561097835615 | -122.435682414853 | (37.7561097835615, -122.435682414853) | ||
| 82838 | 82838 | 47981 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2583 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45715 | 5992041.84966987 | 2097872.86364306 | 37.7399017634935 | -122.470088779952 | (37.7399017634935, -122.470088779952) | ||
| 82922 | 82922 | 37002 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2879 23rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/1998 12:00:00 AM | Permit Number 39616 | 6009576.40115772 | 2102750.87061758 | 37.754293773618606 | -122.409805600758 | (37.7542937736186, -122.409805600758) | |||
| 83005 | 83005 | 67333 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1235 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/1992 12:00:00 AM | Permit Number 30817 | 5995136.26209098 | 2107131.84884658 | 37.7655029929244 | -122.46006026088301 | (37.7655029929244, -122.460060260883) | ||
| 83206 | 83206 | 36998 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2879 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/1998 12:00:00 AM | Permit Number 39616 | 6009576.40115772 | 2102750.87061758 | 37.754293773618606 | -122.409805600758 | (37.7542937736186, -122.409805600758) | |||
| 83363 | 83363 | 37058 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1578 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39662 | 6003306.67223844 | 2099046.33084545 | 37.7437686174034 | -122.43122348397301 | (37.7437686174034, -122.431223483973) | ||
| 83379 | 83379 | 47276 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 691 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2003 12:00:00 AM | Permit Number 45237 | 6009310.77249327 | 2105041.72338407 | 37.7605690480409 | -122.410886002511 | (37.7605690480409, -122.410886002511) | ||
| 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) | |||
| 83504 | 83504 | 33073 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1400 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37333 | 6010634.39060918 | 2119281.77515247 | 37.7997430205195 | -122.407312069993 | (37.7997430205195, -122.407312069993) | ||
| 83606 | 83606 | 53980 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 314 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2016 12:00:00 AM | Permit Number 777049 | 5992334.38859686 | 2094817.59997169 | 37.731529684404 | -122.468855037458 | (37.731529684404, -122.468855037458) | |||
| 83667 | 83667 | 33135 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 3103 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37364 | 6001398.64749893 | 2119042.88886918 | 37.7985658687067 | -122.439253943829 | (37.7985658687067, -122.439253943829) | ||
| 83710 | 83710 | 104577 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 201X Channel St | 8 | 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) | |||
| 83875 | 83875 | 54283 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1265 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1992 12:00:00 AM | Permit Number 30566 | 5992973.96848047 | 2106869.50046493 | 37.7646580506375 | -122.46752000191799 | (37.7646580506375, -122.467520001918) | ||
| 83880 | 83880 | 67114 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1537 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1992 12:00:00 AM | Permit Number 30532 | 5998296.84481976 | 2105270.56777275 | 37.7605736597375 | -122.448994477093 | (37.7605736597375, -122.448994477093) | ||
| 83982 | 83982 | 94337 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 3600 21st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2010 12:00:00 AM | 3x3 | Permit Number 53630 | 6004357.0 | 2103675.0 | 37.7565373316099 | -122.42792145743401 | (37.7565373316099, -122.427921457434) | ||
| 83988 | 83988 | 47122 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 15 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45104 | 6007443.35381521 | 2098122.06722616 | 37.74146435213179 | -122.416854314688 | (37.7414643521318, -122.416854314688) | ||
| 84035 | 84035 | 43007 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 205X Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42873 | 6005609.30796774 | 2109736.9244771 | 37.7732527046739 | -122.424021592666 | (37.7732527046739, -122.424021592666) | |||
| 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) | |||
| 84107 | 84107 | 36995 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2865 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39615 | 6009653.11507751 | 2102755.07693951 | 37.7543096220851 | -122.409540600397 | (37.7543096220851, -122.409540600397) | ||
| 84227 | 84227 | 40274 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 132 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41428 | 6006663.73839558 | 2103003.05359685 | 37.7548225503529 | -122.41989623729602 | (37.7548225503529, -122.419896237296) | ||
| 84251 | 84251 | 47274 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2815 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2002 12:00:00 AM | Permit Number 45220 | 6009522.58691837 | 2104977.4893178 | 37.7604045506497 | -122.410148894867 | (37.7604045506497, -122.410148894867) | |||
| 84326 | 84326 | 40172 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1116 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1999 12:00:00 AM | Permit Number 41363 | 6009436.98979788 | 2102661.78090656 | 37.754041339457295 | -122.41028143257601 | (37.7540413394573, -122.410281432576) | |||
| 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) | |||
| 84427 | 84427 | 92640 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 7 Vandewater St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/2009 12:00:00 AM | 3x3 | Permit Number 52933 | 6009355.0 | 2121160.0 | 37.8048284715711 | -122.41187204576201 | (37.8048284715711, -122.411872045762) |
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");