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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35697 | 35697 | 179258 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 0 Juan Bautista Cir | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5989486.24295 | 2090206.2141599997 | 37.7187030225094 | -122.478364452564 | (37.7187030225094, -122.478364452564) | ||||
| 136688 | 136688 | 240009 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003475.021480001 | 2105636.19313 | 37.7618723639267 | -122.431111627899 | (37.7618723639267, -122.431111627899) | |||
| 166473 | 166473 | 240010 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1 Ford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003488.3573199995 | 2105638.4215599997 | 37.7618792383441 | -122.431065663574 | (37.7618792383441, -122.431065663574) | |||
| 171815 | 171815 | 240012 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1 Ford St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003511.75324 | 2105640.80006 | 37.7618870948351 | -122.43098491611799 | (37.7618870948351, -122.430984916118) | |||
| 182406 | 182406 | 240011 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1 Ford St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003501.30446 | 2105639.22737 | 37.7618821845455 | -122.43102094206101 | (37.7618821845455, -122.431020942061) | |||
| 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) | ||
| 62 | 62 | 239043 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 10 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006946.59098 | 2109912.5632700003 | 37.773810376676295 | -122.41940820332898 | (37.7738103766763, -122.419408203329) | |||
| 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) | |||
| 48452 | 48452 | 239048 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 10 12th St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 6006902.036859999 | 2109961.28236 | 37.7739416381364 | -122.41956578074199 | (37.7739416381364, -122.419565780742) | |||
| 56445 | 56445 | 239046 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 10 12th St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 6006914.36734 | 2109947.42082 | 37.7739042721979 | -122.419522143836 | (37.7739042721979, -122.419522143836) | |||
| 60362 | 60362 | 239045 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 10 12th St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 6006923.25939 | 2109936.76986 | 37.7738755280586 | -122.41949062891199 | (37.7738755280586, -122.419490628912) | |||
| 63580 | 63580 | 239049 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 10 12th St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 6006901.0574900005 | 2109964.79196 | 37.7739512194934 | -122.419569417605 | (37.7739512194934, -122.419569417605) | |||
| 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) | |||
| 70446 | 70446 | 239051 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 10 12th St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 6006860.56385 | 2110006.4487900003 | 37.7740633181933 | -122.41971244847299 | (37.7740633181933, -122.419712448473) | |||
| 136819 | 136819 | 239044 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 10 12th St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 6006934.96083 | 2109926.41075 | 37.7738477434976 | -122.419449416565 | (37.7738477434976, -122.419449416565) | |||
| 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) | |||
| 149107 | 149107 | 239047 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 10 12th St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 6006908.20567 | 2109954.52592 | 37.7739234340388 | -122.419543962305 | (37.7739234340388, -122.419543962305) | |||
| 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) | |||
| 179855 | 179855 | 239050 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 10 12th St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 6006884.23105 | 2109981.5372900004 | 37.7739962503586 | -122.419628811528 | (37.7739962503586, -122.419628811528) | |||
| 38075 | 38075 | 213761 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 10 Burnside Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001233.088330001 | 2096012.00839 | 37.735319350804 | -122.43817610744499 | (37.735319350804, -122.438176107445) | |||
| 174172 | 174172 | 213762 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 10 Burnside Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001221.74362 | 2095979.85162 | 37.7352304105563 | -122.438213027321 | (37.7352304105563, -122.438213027321) | |||
| 154423 | 154423 | 141465 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 10 Chabot Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997726.925 | 2111549.4602 | 37.7777812803429 | -122.45141843816799 | (37.7777812803429, -122.451418438168) | |||
| 133505 | 133505 | 240028 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 10 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004196.30123 | 2105133.07652 | 37.760531771538794 | -122.428581141628 | (37.7605317715388, -122.428581141628) | |||
| 163703 | 163703 | 213829 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 10 Valdez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5996401.58785 | 2093821.0265900001 | 37.7290274725256 | -122.454722051175 | (37.7290274725256, -122.454722051175) | |||
| 13668 | 13668 | 24300 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 10 Young Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1992 12:00:00 AM | 3 | 3X3 | 6016267.21973 | 2096044.36505 | 37.736251780486604 | -122.386199330252 | (37.7362517804866, -122.386199330252) | ||
| 45804 | 45804 | 179269 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 100 Brussels St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010196.1208 | 2094056.79073 | 37.730456426018 | -122.407049673023 | (37.730456426018, -122.407049673023) | |||
| 61845 | 61845 | 179270 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 100 Brussels St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010199.04081 | 2094044.63988 | 37.7304232257555 | -122.40703872195299 | (37.7304232257555, -122.407038721953) | |||
| 62378 | 62378 | 179271 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 100 Brussels St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010203.64491 | 2094028.7746 | 37.730379920693004 | -122.40702168701999 | (37.730379920693, -122.40702168702) | |||
| 175392 | 175392 | 179268 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 100 Brussels St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010185.768180001 | 2094084.1636 | 37.730531006791395 | -122.407087392381 | (37.7305310067914, -122.407087392381) | |||
| 183417 | 183417 | 179267 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 100 Brussels St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010181.968780001 | 2094096.33238 | 37.7305642070683 | -122.407101384948 | (37.7305642070683, -122.407101384948) | |||
| 185193 | 185193 | 179266 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 100 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010179.8891900005 | 2094106.5386 | 37.730592114813106 | -122.40710929357401 | (37.7305921148131, -122.407109293574) | |||
| 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) | |||
| 85127 | 85127 | 33887 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100 Bush St | 1 | 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) | |||
| 94959 | 94959 | 33880 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100 Bush St | 9 | 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) | |||
| 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) | |||
| 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) | |||
| 140271 | 140271 | 33882 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100 Bush St | 11 | 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) | |||
| 142024 | 142024 | 33881 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100 Bush St | 10 | 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) | |||
| 165002 | 165002 | 241262 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 100 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001763.755480001 | 2096665.3361400003 | 37.7371434043511 | -122.43638814190099 | (37.7371434043511, -122.436388141901) | |||
| 24996 | 24996 | 196826 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 100 Merrimac St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014562.70735 | 2108760.4377599997 | 37.7710729141165 | -122.392981999126 | (37.7710729141165, -122.392981999126) | |||
| 63483 | 63483 | 196827 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 100 Merrimac St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014561.24201 | 2108734.73312 | 37.77100225348 | -122.39298526908001 | (37.77100225348, -122.39298526908) | |||
| 155543 | 155543 | 196823 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 100 Merrimac St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014559.03371 | 2108843.67825 | 37.771301269971296 | -122.393000531472 | (37.7713012699713, -122.393000531472) | |||
| 165869 | 165869 | 196824 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 100 Merrimac St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014561.41845 | 2108821.34788 | 37.7712400881979 | -122.392990719855 | (37.7712400881979, -122.392990719855) | |||
| 180587 | 180587 | 196822 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 100 Merrimac St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014552.14235 | 2108939.22295 | 37.771563231702 | -122.39303105533199 | (37.771563231702, -122.393031055332) | |||
| 182643 | 182643 | 196825 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 100 Merrimac St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014560.01631 | 2108798.78001 | 37.771178043948396 | -122.392993990701 | (37.7711780439484, -122.392993990701) | |||
| 104052 | 104052 | 40699 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100 Oxford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1999 12:00:00 AM | Permit Number 41678 | 6006308.40202986 | 2093422.77537775 | 37.7284972327963 | -122.420445112942 | (37.7284972327963, -122.420445112942) | |||
| 123387 | 123387 | 40698 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1999 12:00:00 AM | Permit Number 41678 | 6006308.40202986 | 2093422.77537775 | 37.7284972327963 | -122.420445112942 | (37.7284972327963, -122.420445112942) | |||
| 54452 | 54452 | 213838 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 100 Stanford Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997839.253880001 | 2096312.46068 | 37.7359507162569 | -122.449931439105 | (37.7359507162569, -122.449931439105) | |||
| 59381 | 59381 | 213839 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 100 Stanford Heights Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997838.354830001 | 2096331.0550099998 | 37.736001720388295 | -122.44993588715599 | (37.7360017203883, -122.449935887156) | |||
| 64298 | 64298 | 213841 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 100 Stanford Heights Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997835.61768 | 2096384.9175599997 | 37.7361494574224 | -122.44994923127399 | (37.7361494574224, -122.449949231274) | |||
| 170639 | 170639 | 213840 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 100 Stanford Heights Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997836.45 | 2096363.1216900002 | 37.7360896588131 | -122.44994478325 | (37.7360896588131, -122.44994478325) | |||
| 32258 | 32258 | 84831 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1000 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/2007 12:00:00 AM | 3 | Permit No. 49236 | 5992481.519090001 | 2110715.0101099997 | 37.775188347838395 | -122.469503188975 | (37.7751883478384, -122.469503188975) | ||
| 46365 | 46365 | 84832 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1000 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/2007 12:00:00 AM | 3 | Permit No. 49236 | 5992462.33951 | 2110714.34502 | 37.775185413225 | -122.46956948643101 | (37.775185413225, -122.469569486431) | ||
| 136591 | 136591 | 84833 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1000 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/2007 12:00:00 AM | 4 | Permit No. 49236 | 5992442.2597900005 | 2110714.61485 | 37.775184993587 | -122.469638965716 | (37.775184993587, -122.469638965716) | ||
| 155524 | 155524 | 67372 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1000 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/2007 12:00:00 AM | 3 | Permit No. 49236 | 5992503.76399 | 2110715.6107 | 37.77519128246121 | -122.469426283281 | (37.7751912824612, -122.469426283281) | |
| 67835 | 67835 | 44753 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1000 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2001 12:00:00 AM | 4 | Permit Number 43868 | 6014465.3778099995 | 2102497.20521 | 37.75387003448029 | -122.392880407198 | (37.7538700344803, -122.392880407198) | ||
| 131300 | 131300 | 35461 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1000 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/06/2001 12:00:00 AM | 7 | Permit Number 43868 | 6014463.09869 | 2102535.79514 | 37.7539758675929 | -122.392890988652 | (37.7539758675929, -122.392890988652) | |
| 165809 | 165809 | 44754 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1000 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2001 12:00:00 AM | 4 | Permit Number 43868 | 6014465.64114 | 2102486.6204 | 37.753840985478895 | -122.392878756049 | (37.7538409854789, -122.392878756049) | ||
| 24231 | 24231 | 41521 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1001 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | 7 | Permit Number 42063 | 6014203.50387 | 2106173.31085 | 37.763949275370706 | -122.394043363717 | (37.7639492753707, -122.394043363717) | ||
| 62529 | 62529 | 41523 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1001 Mariposa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | 8 | Permit Number 42063 | 6014223.18274 | 2106173.5616900004 | 37.7639510578292 | -122.39397531741699 | (37.7639510578292, -122.393975317417) | ||
| 176546 | 176546 | 239071 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1001 San Jose Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 10ft | 6005136.69602 | 2096732.7086099999 | 37.737519472045896 | -122.424731134927 | (37.7375194720459, -122.424731134927) | |||
| 149857 | 149857 | 239965 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1004 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001899.83266 | 2101133.44144 | 37.7494195046174 | -122.436237325589 | (37.7494195046174, -122.436237325589) | |||
| 95159 | 95159 | 96547 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 110127 | 110127 | 96546 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 110892 | 110892 | 96548 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 86050 | 86050 | 38163 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100X BRUSSELS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1998 12:00:00 AM | Permit Number 40304 | 6010169.0 | 2094067.2 | 37.7304834899395 | -122.40714416741999 | (37.7304834899395, -122.40714416742) | |||
| 110593 | 110593 | 38161 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100X BRUSSELS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1998 12:00:00 AM | Permit Number 40304 | 6010169.0 | 2094067.2 | 37.7304834899395 | -122.40714416741999 | (37.7304834899395, -122.40714416742) | |||
| 110915 | 110915 | 38162 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100X BRUSSELS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1998 12:00:00 AM | Permit Number 40304 | 6010169.0 | 2094067.2 | 37.7304834899395 | -122.40714416741999 | (37.7304834899395, -122.40714416742) | |||
| 17206 | 17206 | 16009 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/06/1998 12:00:00 AM | 3 | 4 | 6001288.3370900005 | 2094653.38984 | 37.731592040430705 | -122.43788781177099 | (37.7315920404307, -122.437887811771) | ||
| 17507 | 17507 | 16015 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4 | 6000956.04768 | 2094656.76286 | 37.731582400588294 | -122.43903684047899 | (37.7315824005883, -122.439036840479) | |||
| 17516 | 17516 | 16016 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 4 | 6000925.306059999 | 2094658.03828 | 37.7315841533775 | -122.43914321141001 | (37.7315841533775, -122.43914321141) | |||
| 18176 | 18176 | 16013 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 4 | 6001154.39221 | 2094654.56847 | 37.731587658935396 | -122.43835096892201 | (37.7315876589354, -122.438350968922) | |||
| 19708 | 19708 | 16012 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/06/1998 12:00:00 AM | 3 | 4 | 6001201.17189 | 2094653.91848 | 37.7315885348835 | -122.43818919619301 | (37.7315885348835, -122.438189196193) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 21150 | 21150 | 16014 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 4 | 6000994.83808 | 2094657.2357700001 | 37.731585906153605 | -122.438902768653 | (37.7315859061536, -122.438902768653) | |||
| 22999 | 22999 | 16007 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | 8 | 6001364.53052 | 2094649.25854 | 37.7315850293086 | -122.43762410089799 | (37.7315850293086, -122.437624100898) | |||
| 30261 | 30261 | 239066 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100x McCoppin St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6005897.29527 | 2109110.01262 | 37.7715476104631 | -122.42298083840001 | (37.7715476104631, -122.4229808384) | ||||
| 71410 | 71410 | 239065 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100x McCoppin St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6005891.38819 | 2109122.4059599997 | 37.7715813062758 | -122.42300215235399 | (37.7715813062758, -122.423002152354) | ||||
| 75407 | 75407 | 239068 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100x McCoppin St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6005906.41313 | 2109090.3017599997 | 37.771494003666504 | -122.422947898021 | (37.7714940036665, -122.422947898021) | ||||
| 123750 | 123750 | 239067 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100x McCoppin St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6005903.21381 | 2109098.1768400003 | 37.7715154462189 | -122.422959524459 | (37.7715154462189, -122.422959524459) | ||||
| 99524 | 99524 | 115683 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100x Octavia St Frontage East | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005589.0 | 2109665.0 | 37.773054070852496 | -122.424086724818 | (37.7730540708525, -122.424086724818) | ||||
| 122480 | 122480 | 115682 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100x Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005589.0 | 2109665.0 | 37.773054070852496 | -122.424086724818 | (37.7730540708525, -122.424086724818) | ||||
| 138345 | 138345 | 115681 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100x Octavia St Frontage East | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005589.0 | 2109665.0 | 37.773054070852496 | -122.424086724818 | (37.7730540708525, -122.424086724818) | ||||
| 25605 | 25605 | 41164 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 101 02nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1999 12:00:00 AM | 6 | Permit Number 41886 | 6012808.90052 | 2114914.6323 | 37.787873343513 | -122.399480646824 | (37.787873343513, -122.399480646824) | ||
| 42544 | 42544 | 41165 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 101 02nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1999 12:00:00 AM | 6 | Permit Number 41886 | 6012835.78991 | 2114885.77965 | 37.787795619607394 | -122.39938558756701 | (37.7877956196074, -122.399385587567) | ||
| 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) | |||
| 85356 | 85356 | 41159 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 101 02nd St | 8 | 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) | |||
| 97875 | 97875 | 41160 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 101 02nd St | 6 | 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) | |||
| 141284 | 141284 | 41161 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 101 02nd St | 5 | 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) | |||
| 164428 | 164428 | 41162 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 101 02nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1999 12:00:00 AM | 5 | Permit Number 41886 | 6012787.91946 | 2114935.35528 | 37.7879290745025 | -122.399554693396 | (37.7879290745025, -122.399554693396) | ||
| 179511 | 179511 | 41163 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 101 02nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1999 12:00:00 AM | 5 | Permit Number 41886 | 6012798.31637 | 2114925.4015 | 37.7879023232716 | -122.399518022642 | (37.7879023232716, -122.399518022642) | ||
| 30030 | 30030 | 136118 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 101 Alice B Toklas Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006893.798359999 | 2114122.82203 | 37.785367754970004 | -122.419889642794 | (37.78536775497, -122.419889642794) | |||
| 70299 | 70299 | 136119 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 101 Alice B Toklas Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006903.7449199995 | 2114123.71649 | 37.7853707712908 | -122.419855294113 | (37.7853707712908, -122.419855294113) | |||
| 135022 | 135022 | 136120 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 101 Alice B Toklas Pl | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006915.925369999 | 2114125.93814 | 37.785377557585896 | -122.41981331103399 | (37.7853775575859, -122.419813311034) | |||
| 164553 | 164553 | 136117 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 101 Alice B Toklas Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6006878.56877 | 2114119.8388799997 | 37.7853587059721 | -122.419942120931 | (37.7853587059721, -122.419942120931) | |||
| 20041 | 20041 | 16019 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 101 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2003 12:00:00 AM | 3 | 3x3 | 6001362.879269999 | 2094609.69043 | 37.7314762904984 | -122.43762697692301 | (37.7314762904984, -122.437626976923) | ||
| 99389 | 99389 | 107901 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 101 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | Permit Number 770994 | 5993727.26625 | 2089799.61042 | 37.717831878877796 | -122.46367556428301 | (37.7178318788778, -122.463675564283) | ||
| 165806 | 165806 | 213821 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 101 Shields St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5993717.69664 | 2089819.3714299998 | 37.7178855864422 | -122.463710075375 | (37.7178855864422, -122.463710075375) |
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");