Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4954 | 4954 | 253735 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4958 | 4958 | 253746 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4997 | 4997 | 253742 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4999 | 4999 | 253739 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5010 | 5010 | 253737 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5024 | 5024 | 253736 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5026 | 5026 | 253744 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5027 | 5027 | 253738 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5032 | 5032 | 253740 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5036 | 5036 | 253745 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5192 | 5192 | 243370 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Hill St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006249.2279900005 | 2103449.78821 | 37.756025819148796 | -122.421361454386 | (37.7560258191488, -122.421361454386) | |
| 5205 | 5205 | 243371 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Hill St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006273.4727300005 | 2103450.37091 | 37.7560287860041 | -122.42127764924 | (37.7560287860041, -122.42127764924) | |
| 89046 | 89046 | 120132 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006324.60427 | 2103454.53368 | 37.7560430985606 | -122.42110111460899 | (37.7560430985606, -122.421101114609) | |
| 959 | 959 | 83601 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2008 12:00:00 AM | 5 | 6009088.96788 | 2112689.1650900003 | 37.7815547005346 | -122.41219362785499 | (37.7815547005346, -122.412193627855) | ||
| 134226 | 134226 | 130099 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6009103.32764 | 2112603.74896 | 37.781320973926896 | -122.412137911252 | (37.7813209739269, -122.412137911252) | |||
| 65479 | 65479 | 129881 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Locust St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997460.65276 | 2116233.66378 | 37.7906276153152 | -122.45267771501999 | (37.7906276153152, -122.45267771502) | |||
| 89282 | 89282 | 91179 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.41829917319299 | (37.7785341058364, -122.418299173193) | ||
| 114568 | 114568 | 91178 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.41829917319299 | (37.7785341058364, -122.418299173193) | ||
| 125403 | 125403 | 91180 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.41829917319299 | (37.7785341058364, -122.418299173193) | ||
| 126214 | 126214 | 91181 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.41829917319299 | (37.7785341058364, -122.418299173193) | ||
| 36481 | 36481 | 208402 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Santa Monica Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993357.048219999 | 2097424.8281 | 37.7387475142763 | -122.465508869638 | (37.7387475142763, -122.465508869638) | |||
| 45777 | 45777 | 208399 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Santa Monica Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993307.585030001 | 2097392.18535 | 37.7386550325134 | -122.465677517719 | (37.7386550325134, -122.465677517719) | |||
| 56803 | 56803 | 208398 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Santa Monica Way | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993287.0539 | 2097380.91654 | 37.7386229069136 | -122.46574768551201 | (37.7386229069136, -122.465747685512) | |||
| 69095 | 69095 | 208401 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Santa Monica Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993334.34485 | 2097411.8322900003 | 37.738710521577794 | -122.46558642267901 | (37.7387105215778, -122.465586422679) | |||
| 172090 | 172090 | 208400 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Santa Monica Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993318.88533 | 2097404.7115700003 | 37.738690078178 | -122.46563935676599 | (37.738690078178, -122.465639356766) | |||
| 26385 | 26385 | 202527 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 South Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014625.31795 | 2112810.41928 | 37.7821967319358 | -122.39304884213001 | (37.7821967319358, -122.39304884213) | |||
| 33497 | 33497 | 202528 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 South Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014646.44 | 2112828.61301 | 37.7822478610776 | -122.392977042074 | (37.7822478610776, -122.392977042074) | |||
| 50043 | 50043 | 202526 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014615.13271 | 2112797.96435 | 37.7821619677401 | -122.39308320702699 | (37.7821619677401, -122.393083207027) | |||
| 109196 | 109196 | 86719 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 South Park | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2007 12:00:00 AM | Permit Number 49703 | 6014686.1 | 2112756.9 | 37.782053156364604 | -122.392834816441 | (37.7820531563646, -122.392834816441) | ||||
| 111883 | 111883 | 86720 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 South Park | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2007 12:00:00 AM | Permit Number 49703 | 6014686.1 | 2112756.9 | 37.782053156364604 | -122.392834816441 | (37.7820531563646, -122.392834816441) | ||||
| 129372 | 129372 | 86721 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 South Park | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2007 12:00:00 AM | Permit Number 49703 | 6014686.1 | 2112756.9 | 37.782053156364604 | -122.392834816441 | (37.7820531563646, -122.392834816441) | ||||
| 31674 | 31674 | 192688 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6017448.40538 | 2095582.8446799999 | 37.7350498437698 | -122.382083347276 | (37.7350498437698, -122.382083347276) | |||
| 33315 | 33315 | 192690 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017412.04247 | 2095572.4981799999 | 37.735019426014 | -122.382208348559 | (37.735019426014, -122.382208348559) | |||
| 34037 | 34037 | 192697 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6017301.9357 | 2095598.4077599999 | 37.7350844865661 | -122.38259083289499 | (37.7350844865661, -122.382590832895) | |||
| 36792 | 36792 | 192685 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017480.77105 | 2095578.80905 | 37.735040550171206 | -122.381971165837 | (37.7350405501712, -122.381971165837) | |||
| 45893 | 45893 | 192679 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6017312.639880001 | 2095546.8032 | 37.7349433820246 | -122.382550234822 | (37.7349433820246, -122.382550234822) | |||
| 52618 | 52618 | 192694 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017352.2410699995 | 2095579.85569 | 37.7350363251575 | -122.382415617084 | (37.7350363251575, -122.382415617084) | |||
| 52887 | 52887 | 192677 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6017225.168319999 | 2095561.1797900002 | 37.734978024808505 | -122.38285365798599 | (37.7349780248085, -122.382853657986) | |||
| 57492 | 57492 | 192687 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6017464.18939 | 2095568.68006 | 37.735011822241894 | -122.382027790774 | (37.7350118222419, -122.382027790774) | |||
| 60416 | 60416 | 192699 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6017246.69348 | 2095601.98092 | 37.7350912458535 | -122.382782075543 | (37.7350912458535, -122.382782075543) | |||
| 60994 | 60994 | 192702 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017169.66256 | 2095613.0705099998 | 37.7351174395099 | -122.383049173305 | (37.7351174395099, -122.383049173305) | |||
| 62880 | 62880 | 192678 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6017292.9452599995 | 2095550.89197 | 37.734953520988796 | -122.382618611157 | (37.7349535209888, -122.382618611157) | |||
| 63196 | 63196 | 192693 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6017354.91641 | 2095589.9565 | 37.735064207754704 | -122.38240706992599 | (37.7350642077547, -122.382407069926) | |||
| 76201 | 76201 | 192700 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017246.54494 | 2095594.59885 | 37.735070967951 | -122.382782075559 | (37.735070967951, -122.382782075559) | |||
| 131197 | 131197 | 192703 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017168.52543 | 2095602.6308900001 | 37.7350887115578 | -122.383052378458 | (37.7350887115578, -122.383052378458) | |||
| 146747 | 146747 | 192696 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6017316.48432 | 2095599.65377 | 37.7350887115602 | -122.382540619262 | (37.7350887115602, -122.382540619262) | |||
| 147789 | 147789 | 192692 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017373.82691 | 2095592.96106 | 37.7350735022318 | -122.38234189787201 | (37.7350735022318, -122.382341897872) | |||
| 148802 | 148802 | 192698 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017262.87966 | 2095607.80979 | 37.7351081450216 | -122.382726519031 | (37.7351081450216, -122.382726519031) | |||
| 148904 | 148904 | 192684 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017502.05989 | 2095577.15005 | 37.7350371705351 | -122.38189744661999 | (37.7350371705351, -122.38189744662) | |||
| 154586 | 154586 | 192701 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017190.43176 | 2095600.95922 | 37.7350853319278 | -122.38297652335699 | (37.7350853319278, -122.382976523357) | |||
| 156164 | 156164 | 192691 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017392.94112 | 2095590.73029 | 37.735068432748 | -122.38227565738899 | (37.735068432748, -122.382275657389) | |||
| 161287 | 161287 | 192686 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6017466.19742 | 2095576.33261 | 37.735032945522 | -122.38202138037701 | (37.735032945522, -122.382021380377) | |||
| 173719 | 173719 | 192682 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6017460.0182300005 | 2095530.2989400001 | 37.7349062049421 | -122.38203954311399 | (37.7349062049421, -122.382039543114) | |||
| 175321 | 175321 | 192680 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017355.80445 | 2095541.93442 | 37.734932397715 | -122.382400659567 | (37.734932397715, -122.382400659567) | |||
| 181033 | 181033 | 192676 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017206.05411 | 2095563.41068 | 37.7349830942969 | -122.382919898435 | (37.7349830942969, -122.382919898435) | |||
| 181955 | 181955 | 192689 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6017412.8891900005 | 2095583.86694 | 37.7350506891377 | -122.382206211761 | (37.7350506891377, -122.382206211761) | |||
| 185049 | 185049 | 192683 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6017532.94915 | 2095576.52883 | 37.7350371705259 | -122.381790607154 | (37.7350371705259, -122.381790607154) | |||
| 187230 | 187230 | 192695 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017336.50043 | 2095596.17365 | 37.735080261541796 | -122.382471173631 | (37.7350802615418, -122.382471173631) | |||
| 187899 | 187899 | 192681 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6017422.38921 | 2095533.8250400003 | 37.7349138087107 | -122.382169886355 | (37.7349138087107, -122.382169886355) | |||
| 38058 | 38058 | 228966 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Woodward St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006486.21321 | 2108435.74524 | 37.769729446586105 | -122.420895855576 | (37.7697294465861, -122.420895855576) | |||
| 147487 | 147487 | 228965 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Woodward St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006487.45762 | 2108420.9808 | 37.7696889770883 | -122.420890502803 | (37.7696889770883, -122.420890502803) | |||
| 174856 | 174856 | 228964 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Woodward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6006487.40312 | 2108404.39444 | 37.7696434318162 | -122.42088951356101 | (37.7696434318162, -122.420889513561) | |||
| 186806 | 186806 | 228967 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Woodward St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006485.81484 | 2108449.38296 | 37.7697668700666 | -122.420898201914 | (37.7697668700666, -122.420898201914) | |||
| 51262 | 51262 | 48521 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1(REVISED) Church St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45844 | 6004110.55275805 | 2108703.1215343 | 37.7703294028669 | -122.42913226260099 | (37.7703294028669, -122.429132262601) | |||
| 78235 | 78235 | 48512 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1(REVISED) Church St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45844 | 6004110.55275805 | 2108703.1215343 | 37.7703294028669 | -122.42913226260099 | (37.7703294028669, -122.429132262601) | |||
| 79271 | 79271 | 48520 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1(REVISED) Church St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45844 | 6004110.55275805 | 2108703.1215343 | 37.7703294028669 | -122.42913226260099 | (37.7703294028669, -122.429132262601) | |||
| 89693 | 89693 | 48523 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1(REVISED) Church St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45844 | 6004110.55275805 | 2108703.1215343 | 37.7703294028669 | -122.42913226260099 | (37.7703294028669, -122.429132262601) | |||
| 92959 | 92959 | 48525 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1(REVISED) Church St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45844 | 6004110.55275805 | 2108703.1215343 | 37.7703294028669 | -122.42913226260099 | (37.7703294028669, -122.429132262601) | |||
| 115826 | 115826 | 48527 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1(REVISED) Church St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45844 | 6004110.55275805 | 2108703.1215343 | 37.7703294028669 | -122.42913226260099 | (37.7703294028669, -122.429132262601) | |||
| 128582 | 128582 | 48522 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1(REVISED) Church St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45844 | 6004110.55275805 | 2108703.1215343 | 37.7703294028669 | -122.42913226260099 | (37.7703294028669, -122.429132262601) | |||
| 173004 | 173004 | 192705 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 10 Cashmere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6017144.13726 | 2095899.9692900002 | 37.735903795909294 | -122.383157386898 | (37.7359037959093, -122.383157386898) | |||
| 35352 | 35352 | 130165 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 10 Fell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6007229.263780001 | 2110912.71454 | 37.7765724698659 | -122.418501324302 | (37.7765724698659, -122.418501324302) | |||
| 41411 | 41411 | 130163 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 10 Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6007326.908530001 | 2110927.06471 | 37.7766173685386 | -122.41816455966601 | (37.7766173685386, -122.418164559666) | |||
| 48738 | 48738 | 130164 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 10 Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6007244.52922 | 2110913.56954 | 37.7765756768652 | -122.41844857724399 | (37.7765756768652, -122.418448577244) | |||
| 50145 | 50145 | 130166 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 10 Fell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6007216.97748 | 2110914.13443 | 37.7765756768639 | -122.418543926976 | (37.7765756768639, -122.418543926976) | |||
| 58766 | 58766 | 130162 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 10 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6007346.86344 | 2110927.82363 | 37.7766205755192 | -122.418095583465 | (37.7766205755192, -122.418095583465) | |||
| 24325 | 24325 | 202719 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 10 Long Bridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014938.94081 | 2109579.23063 | 37.7733420295379 | -122.39173784374701 | (37.7733420295379, -122.391737843747) | |||
| 24916 | 24916 | 202720 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 10 Long Bridge St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014895.440769999 | 2109535.93167 | 37.7732207253898 | -122.39188528936701 | (37.7732207253898, -122.391885289367) | |||
| 147581 | 147581 | 202724 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 10 Long Bridge St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014815.59536 | 2109459.00695 | 37.7730050742431 | -122.392156106714 | (37.7730050742431, -122.392156106714) | |||
| 151714 | 151714 | 202723 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 10 Long Bridge St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014833.31291 | 2109474.8184700003 | 37.7730494728835 | -122.392095924989 | (37.7730494728835, -122.392095924989) | |||
| 161931 | 161931 | 202718 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 10 Long Bridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014961.9394 | 2109598.1115099997 | 37.7733951488879 | -122.39165960813101 | (37.7733951488879, -122.391659608131) | |||
| 170607 | 170607 | 202722 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 10 Long Bridge St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014857.54711 | 2109497.4284200002 | 37.77311290027129 | -122.392013676594 | (37.7731129002713, -122.392013676594) | |||
| 179578 | 179578 | 202721 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 10 Long Bridge St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014883.6020599995 | 2109524.0439400002 | 37.773187427088104 | -122.391925409944 | (37.7731874270881, -122.391925409944) | |||
| 121361 | 121361 | 33878 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 100 Bush St | 7 | 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) | |||
| 14267 | 14267 | 3797 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 100 Cashmere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016837.41936 | 2095915.09048 | 37.7359283617946 | -122.384218895383 | (37.7359283617946, -122.384218895383) | |||
| 23210 | 23210 | 3796 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 100 Cashmere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3X3 | 6016917.42909 | 2095896.09045 | 37.735880614983294 | -122.38394094461901 | (37.7358806149833, -122.383940944619) | |||
| 129604 | 129604 | 192672 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 100 Cashmere St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6016712.4779199995 | 2095993.39595 | 37.736136464024796 | -122.384656324728 | (37.7361364640248, -122.384656324728) | |||
| 22996 | 22996 | 4591 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 100 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x2 | 6011425.16703 | 2118064.77563 | 37.796445660597 | -122.40448996415199 | (37.796445660597, -122.404489964152) | |||
| 37048 | 37048 | 130173 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 100 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006808.655669999 | 2110849.51064 | 37.7763752395492 | -122.419951846203 | (37.7763752395492, -122.419951846203) | |||
| 37195 | 37195 | 130176 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 100 Fell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006738.15532 | 2110843.36545 | 37.776354394182604 | -122.420195290907 | (37.7763543941826, -122.420195290907) | |||
| 63442 | 63442 | 130172 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 100 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006826.87585 | 2110851.47275 | 37.7763816535167 | -122.419888956633 | (37.7763816535167, -122.419888956633) | |||
| 63985 | 63985 | 130179 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 100 Fell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006655.8710199995 | 2110834.54234 | 37.776325531321504 | -122.420479309383 | (37.7763255313215, -122.420479309383) | |||
| 134159 | 134159 | 130180 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 100 Fell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006635.19822 | 2110827.3747900003 | 37.7763046859341 | -122.420550313571 | (37.7763046859341, -122.420550313571) | |||
| 146544 | 146544 | 130175 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 100 Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006762.84774 | 2110846.36267 | 37.7763640151131 | -122.42011008552099 | (37.7763640151131, -122.420110085521) | |||
| 166196 | 166196 | 130174 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 100 Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6006789.90912 | 2110850.47929 | 37.7763768430541 | -122.42001676465799 | (37.7763768430541, -122.420016764658) | |||
| 166619 | 166619 | 130177 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 100 Fell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006716.38193 | 2110839.72435 | 37.776343169733295 | -122.42027035280199 | (37.7763431697333, -122.420270352802) | |||
| 178570 | 178570 | 130181 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 100 Fell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6006538.77288 | 2110815.3380400003 | 37.776266201271795 | -122.42088302134898 | (37.7762662012718, -122.420883021349) | |||
| 183615 | 183615 | 130178 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 100 Fell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006688.806419999 | 2110839.1222900003 | 37.7763399627555 | -122.420365701616 | (37.7763399627555, -122.420365701616) | |||
| 33449 | 33449 | 201427 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 100 Harbor Rd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6018449.06235 | 2094720.56628 | 37.7327374097836 | -122.378563829777 | (37.7327374097836, -122.378563829777) | |||
| 46268 | 46268 | 201425 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 100 Harbor Rd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6018498.49142 | 2094639.3373599998 | 37.7325170956705 | -122.378387301828 | (37.7325170956705, -122.378387301828) |
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");