Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187909 | 187909 | 223830 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 100 Santa Marina St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6006171.8374 | 2097486.11107 | 37.73964655665021 | -122.42120563965099 | (37.7396465566502, -122.421205639651) | ||||
| 186070 | 186070 | 223822 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1315 Utah St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6010905.48348 | 2102095.73052 | 37.7525692973405 | -122.405163145389 | (37.7525692973405, -122.405163145389) | |||
| 185864 | 185864 | 207418 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 746 Foerster St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5998157.99819 | 2096050.22322 | 37.7352489078083 | -122.448810534898 | (37.7352489078083, -122.448810534898) | |||
| 184832 | 184832 | 223851 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 310 Liberty St | 32 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003941.73153 | 2103931.6590400003 | 37.7572185549154 | -122.429375905766 | (37.7572185549154, -122.429375905766) | |||
| 184809 | 184809 | 191016 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 801 Bay Shore Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6010877.374890001 | 2095138.84126 | 37.7334656088485 | -122.404770616467 | (37.7334656088485, -122.404770616467) | |||
| 184264 | 184264 | 223826 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 3101 17th St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 1ft | 6008033.82154 | 2106170.9284599996 | 37.7635978994403 | -122.415382349527 | (37.7635978994403, -122.415382349527) | |||
| 183259 | 183259 | 247134 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 500 27th St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6003187.16367 | 2100094.09523 | 37.7466387612688 | -122.43171150809299 | (37.7466387612688, -122.431711508093) | ||||
| 182828 | 182828 | 47607 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 1301 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2004 12:00:00 AM | 3 | Permit Number 47714 | 6009584.683680001 | 2109294.10241 | 37.772260458974294 | -122.410238904622 | (37.7722604589743, -122.410238904622) | |
| 182434 | 182434 | 223829 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 100 Santa Marina St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6006166.57618 | 2097475.4122599997 | 37.739616883505995 | -122.421223071201 | (37.739616883506, -122.421223071201) | ||||
| 181578 | 181578 | 126430 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2750 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 1ft | 5998566.60506 | 2113239.86578 | 37.782470740982106 | -122.44863548544599 | (37.7824707409821, -122.448635485446) | |||
| 181448 | 181448 | 223818 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1760 Dolores St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6005274.68264 | 2098157.0502400002 | 37.741438185137795 | -122.42435532714899 | (37.7414381851378, -122.424355327149) | |||
| 180967 | 180967 | 142994 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 39 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6008184.8344 | 2120832.3766 | 37.803863182849604 | -122.415898325017 | (37.8038631828496, -122.415898325017) | |||
| 180048 | 180048 | 223838 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1201 Douglass St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6001376.54401 | 2100236.11585 | 37.7469259166077 | -122.43798260121099 | (37.7469259166077, -122.437982601211) | |||
| 179270 | 179270 | 223834 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2100 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 6008066.72851 | 2106165.04225 | 37.7635835867453 | -122.415268117623 | (37.7635835867453, -122.415268117623) | |||
| 179063 | 179063 | 201355 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1 Bitting Ave | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6012932.38695 | 2092554.1850700001 | 37.726483321929706 | -122.397484603332 | (37.7264833219297, -122.397484603332) | ||||
| 178664 | 178664 | 223860 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 20 Deming St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 5999452.08936 | 2105235.56335 | 37.7605435481615 | -122.4449965101 | (37.7605435481615, -122.4449965101) | |||
| 177378 | 177378 | 124238 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 285 Stanyan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5996678.45691 | 2110896.56425 | 37.775928506027604 | -122.454998242108 | (37.7759285060276, -122.454998242108) | |||
| 174820 | 174820 | 223836 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2100 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 6008066.44955 | 2106150.296 | 37.7635430812786 | -122.415268038516 | (37.7635430812786, -122.415268038516) | |||
| 173644 | 173644 | 190996 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1301 Harrison St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6009624.082669999 | 2109327.0907400004 | 37.7723532456398 | -122.41010494881 | (37.7723532456398, -122.41010494881) | |||
| 171717 | 171717 | 176170 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 42 Kelloch Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6008360.10661 | 2086217.92738 | 37.7088296382394 | -122.41284306515499 | (37.7088296382394, -122.412843065155) | |||
| 171706 | 171706 | 185276 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2601 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 75 | Width 0ft | 5984954.4921 | 2097458.3645 | 37.7383513915158 | -122.494562994936 | (37.7383513915158, -122.494562994936) | |||
| 171610 | 171610 | 191010 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1540 Newhall St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6014248.56136 | 2095533.49076 | 37.7347370874406 | -122.393142984083 | (37.7347370874406, -122.393142984083) | |||
| 171316 | 171316 | 176172 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 89 Ottawa Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 5998934.49429 | 2088660.58419 | 37.715003049713204 | -122.44559469233499 | (37.7150030497132, -122.445594692335) | |||
| 170926 | 170926 | 207416 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 70 Marcela Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994652.302180001 | 2100663.02331 | 37.7477134088455 | -122.461265194639 | (37.7477134088455, -122.461265194639) | |||
| 169264 | 169264 | 223845 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 163 Corwin St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000588.980819999 | 2104313.3574 | 37.7580762176596 | -122.440998371578 | (37.7580762176596, -122.440998371578) | |||
| 168904 | 168904 | 223855 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 4132 17th St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6001465.571409999 | 2105861.06048 | 37.7623757216707 | -122.438077616409 | (37.7623757216707, -122.438077616409) | |||
| 168521 | 168521 | 176178 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 445 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003345.09348 | 2090989.4763 | 37.7216484973556 | -122.43051586931999 | (37.7216484973556, -122.43051586932) | |||
| 167880 | 167880 | 223844 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 198 Hancock St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003058.1903099995 | 2105071.09534 | 37.76029711232879 | -122.432512916434 | (37.7602971123288, -122.432512916434) | |||
| 167022 | 167022 | 176174 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 89 Ottawa Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 5998957.51819 | 2088637.0202 | 37.7149396628061 | -122.445513418834 | (37.7149396628061, -122.445513418834) | |||
| 167007 | 167007 | 126435 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 33 Normandie Ter | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6000895.13879 | 2117418.20364 | 37.7940762455819 | -122.440879626906 | (37.7940762455819, -122.440879626906) | |||
| 166702 | 166702 | 223846 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 163 Corwin St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000593.0444 | 2104306.7365599996 | 37.7580582698975 | -122.440983843043 | (37.7580582698975, -122.440983843043) | |||
| 166528 | 166528 | 191012 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1540 Newhall St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6014220.67359 | 2095494.23787 | 37.734627757770795 | -122.39323665656299 | (37.7346277577708, -122.393236656563) | |||
| 166024 | 166024 | 223832 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 100 Santa Marina St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6006182.73872 | 2097507.8972099996 | 37.7397069910787 | -122.421169494081 | (37.7397069910787, -122.421169494081) | ||||
| 165455 | 165455 | 191006 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1429 Rhode Island St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6012039.744969999 | 2101699.30663 | 37.751544149343204 | -122.40121279593001 | (37.7515441493432, -122.40121279593) | ||||
| 164344 | 164344 | 223843 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1336 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009254.1321 | 2101336.70744 | 37.750392732037504 | -122.41082022369301 | (37.7503927320375, -122.410820223693) | |||
| 164115 | 164115 | 176173 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 89 Ottawa Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 5998945.18552 | 2088649.14892 | 37.71497226143929 | -122.44555691723 | (37.7149722614393, -122.44555691723) | |||
| 163555 | 163555 | 223858 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 4136 17th St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6001426.52353 | 2105858.79179 | 37.762367271646 | -122.43821250571101 | (37.762367271646, -122.438212505711) | |||
| 163222 | 163222 | 200257 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1084 Jamestown Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 6013566.4561 | 2089983.1601 | 37.7194590883037 | -122.39511262860701 | (37.7194590883037, -122.395112628607) | |||
| 163053 | 163053 | 66561 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 2750 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1991 12:00:00 AM | 2 | Permit Number 29749 | 5998574.90625 | 2113241.231 | 37.7824749641808 | -122.448606865428 | (37.7824749641808, -122.448606865428) | |
| 162641 | 162641 | 247135 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 500 27th St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6003187.168869999 | 2100075.22315 | 37.7465869432374 | -122.431710142923 | (37.7465869432374, -122.431710142923) | ||||
| 161757 | 161757 | 223861 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 20 Deming St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 5999453.3613 | 2105232.0542599997 | 37.760533985665 | -122.44499185878999 | (37.760533985665, -122.44499185879) | |||
| 160996 | 160996 | 223847 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 163 Corwin St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000596.08551 | 2104301.4441 | 37.758043911304895 | -122.44097294593901 | (37.7580439113049, -122.440972945939) | |||
| 159151 | 159151 | 142996 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 19 Houston St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6008239.0804 | 2120841.4658 | 37.803891189040606 | -122.41571124684499 | (37.8038911890406, -122.415711246845) | |||
| 158800 | 158800 | 207419 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 746 Foerster St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5998157.8565 | 2096043.41975 | 37.7352302190006 | -122.448810534879 | (37.7352302190006, -122.448810534879) | |||
| 156062 | 156062 | 126431 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2750 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 1ft | 5998558.234759999 | 2113238.7522299998 | 37.782467204845 | -122.448664362682 | (37.782467204845, -122.448664362682) | |||
| 155491 | 155491 | 47609 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 1301 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2004 12:00:00 AM | 3 | Permit Number 47714 | 6009613.5529 | 2109319.75218 | 37.7723325054634 | -122.41014085421699 | (37.7723325054634, -122.410140854217) | |
| 154869 | 154869 | 117819 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 3936 Balboa St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 1ft | 5983305.904569999 | 2111075.09338 | 37.775642477392395 | -122.501269829965 | (37.7756424773924, -122.501269829965) | |||
| 154697 | 154697 | 247140 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 500 27th St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6003166.93075 | 2100089.40149 | 37.746624726449795 | -122.431781136306 | (37.7466247264498, -122.431781136306) | ||||
| 153896 | 153896 | 191014 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2701 Phelps St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6011783.11668 | 2093247.60163 | 37.728323242206 | -122.401506319354 | (37.728323242206, -122.401506319354) | |||
| 153825 | 153825 | 51794 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 308 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2005 12:00:00 AM | 5 | Permit Number 48043 | 6012078.06039 | 2087170.76392 | 37.7116539294676 | -122.400060094404 | (37.7116539294676, -122.400060094404) | ||
| 153729 | 153729 | 176181 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 324 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6012548.632569999 | 2086934.28388 | 37.7110308278852 | -122.398417077096 | (37.7110308278852, -122.398417077096) | |||
| 153434 | 153434 | 200491 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1090 Jamestown Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6013533.8773 | 2090002.5687 | 37.719510568674 | -122.395226601179 | (37.719510568674, -122.395226601179) | |||
| 153073 | 153073 | 223817 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 742 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 6004960.84188 | 2104040.8102700002 | 37.7575759032313 | -122.42585919327298 | (37.7575759032313, -122.425859193273) | |||
| 151491 | 151491 | 176168 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 30 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 8ft | 6008416.5566300005 | 2086198.9199700002 | 37.7087806162127 | -122.412646622645 | (37.7087806162127, -122.412646622645) | |||
| 150264 | 150264 | 223853 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 90 Divisadero St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6001961.63263 | 2108146.90448 | 37.7686802875817 | -122.436525544828 | (37.7686802875817, -122.436525544828) | |||
| 149362 | 149362 | 201356 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1 Bitting Ave | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6012930.00772 | 2092558.19115 | 37.7264941893332 | -122.39749310912201 | (37.7264941893332, -122.397493109122) | ||||
| 148766 | 148766 | 32714 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 1105 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 14 | Permit Number 37110 | 6007282.5299 | 2115198.67905 | 37.7883436871578 | -122.418621065405 | (37.7883436871578, -122.418621065405) | |
| 147558 | 147558 | 223854 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 4132 17th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6001479.36221 | 2105861.23339 | 37.762376980721896 | -122.438029931638 | (37.7623769807219, -122.438029931638) | |||
| 147532 | 147532 | 176167 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1501 Hahn St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6007417.45559 | 2087310.83088 | 37.7117775673588 | -122.416178356572 | (37.7117775673588, -122.416178356572) | |||
| 147257 | 147257 | 247139 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 500 27th St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6003171.196269999 | 2100066.5101099997 | 37.746562113859504 | -122.43176475243999 | (37.7465621138595, -122.43176475244) | ||||
| 147160 | 147160 | 223857 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 4136 17th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6001443.19254 | 2105860.10776 | 37.7623718330075 | -122.438154948197 | (37.7623718330075, -122.438154948197) | |||
| 143701 | 143701 | 191005 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1429 Rhode Island St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6012034.37519 | 2101693.56903 | 37.7515280955639 | -122.40123096226401 | (37.7515280955639, -122.401230962264) | ||||
| 142279 | 142279 | 92231 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 565 Marina Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2009 12:00:00 AM | 3x3 | Permit Number 52673 | 6000270.5 | 2121584.5 | 37.8054801915973 | -122.443340329465 | (37.8054801915973, -122.443340329465) | ||
| 141043 | 141043 | 92230 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 565 Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2009 12:00:00 AM | 3x3 | Permit Number 52673 | 6000270.5 | 2121584.5 | 37.8054801915973 | -122.443340329465 | (37.8054801915973, -122.443340329465) | ||
| 140367 | 140367 | 26380 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 2621 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5997625.2697268 | 2089162.8567299 | 37.716307341478895 | -122.45015608882 | (37.7163073414789, -122.45015608882) | |||
| 138521 | 138521 | 52843 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 11X Guy Pl | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014349.88850075 | 2114221.0453464002 | 37.7860546845502 | -122.394100496655 | (37.7860546845502, -122.394100496655) | |
| 137558 | 137558 | 223859 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 20 Deming St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 5999452.72733 | 2105240.37235 | 37.7605567888939 | -122.44499464937799 | (37.7605567888939, -122.444994649378) | |||
| 134790 | 134790 | 191017 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 801 Bay Shore Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6010875.9229 | 2095145.90873 | 37.733484933471 | -122.404776133825 | (37.733484933471, -122.404776133825) | |||
| 134593 | 134593 | 142995 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 29 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6008216.7367 | 2120837.5372 | 37.8038791460389 | -122.415788290484 | (37.8038791460389, -122.415788290484) | |||
| 132694 | 132694 | 191008 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1350 Rankin St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 2ft | 6012780.96774 | 2096905.12701 | 37.7384216764219 | -122.398313198195 | (37.7384216764219, -122.398313198195) | |||
| 132023 | 132023 | 223850 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 163 Corwin St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000602.6654 | 2104289.54137 | 37.758011604077296 | -122.440949336057 | (37.7580116040773, -122.440949336057) | |||
| 130253 | 130253 | 223823 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 3101 17th St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 1ft | 6008008.73592 | 2106169.28223 | 37.7635919693097 | -122.415468996495 | (37.7635919693097, -122.415468996495) | |||
| 130215 | 130215 | 126429 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2965 Broderick St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5999956.74721 | 2118771.72266 | 37.7977391617965 | -122.444223858445 | (37.7977391617965, -122.444223858445) | |||
| 129687 | 129687 | 191021 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1951 Revere Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6013036.60828 | 2095880.65863 | 37.7356229367385 | -122.397357487761 | (37.7356229367385, -122.397357487761) | ||||
| 126549 | 126549 | 94468 | Property Tree 7 | Cupressus sempervirens :: Italian Cypress 136 | 4128 17th St | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 125819 | 125819 | 110920 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 77 FEDERAL ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x1 | 6014792.0 | 2113102.0 | 37.783006604033204 | -122.392492594241 | (37.7830066040332, -122.392492594241) | ||||
| 124810 | 124810 | 70611 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 1355 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2013 12:00:00 AM | Permit Number 770302 | 6007018.06454335 | 2115342.51032554 | 37.7887237195829 | -122.419546283037 | (37.7887237195829, -122.419546283037) | |||
| 124170 | 124170 | 121579 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 742X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 1x1 | 6004940.0 | 2104032.0 | 37.757550534457295 | -122.425930645849 | (37.7575505344573, -122.425930645849) | |||
| 122993 | 122993 | 102812 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 50 Lansing St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 48860 | 6014354.6 | 2114220.8 | 37.7860542727502 | -122.394084178828 | (37.7860542727502, -122.394084178828) | ||
| 122128 | 122128 | 52846 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 11X Guy Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014349.88850075 | 2114221.0453464002 | 37.7860546845502 | -122.394100496655 | (37.7860546845502, -122.394100496655) | |
| 120056 | 120056 | 223842 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 3922 22nd St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6002306.42247 | 2102988.7945 | 37.7545369555235 | -122.434964002506 | (37.7545369555235, -122.434964002506) | |||
| 119324 | 119324 | 102814 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 50 Lansing St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 48860 | 6014354.6 | 2114220.8 | 37.7860542727502 | -122.394084178828 | (37.7860542727502, -122.394084178828) | ||
| 118464 | 118464 | 98529 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 428 11th St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/22/2012 12:00:00 AM | 3x3 | Permit Number 768342 | 6009030.0 | 2108561.0 | 37.7702164230423 | -122.41210579217699 | (37.7702164230423, -122.412105792177) | ||
| 117618 | 117618 | 52848 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 50 Lansing St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014349.88850075 | 2114221.0453464002 | 37.7860546845502 | -122.394100496655 | (37.7860546845502, -122.394100496655) | |
| 109279 | 109279 | 102813 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 50 Lansing St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 48860 | 6014354.6 | 2114220.8 | 37.7860542727502 | -122.394084178828 | (37.7860542727502, -122.394084178828) | ||
| 107335 | 107335 | 52847 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 11X Guy Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014349.88850075 | 2114221.0453464002 | 37.7860546845502 | -122.394100496655 | (37.7860546845502, -122.394100496655) | |
| 106973 | 106973 | 102811 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 50 Lansing St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 48860 | 6014354.6 | 2114220.8 | 37.7860542727502 | -122.394084178828 | (37.7860542727502, -122.394084178828) | ||
| 105424 | 105424 | 26414 | DPW Maintained 3 | Cupressus sempervirens :: Italian Cypress 136 | 34 Maple St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996568.2197254 | 2116061.2858977 | 37.790103136313206 | -122.455752999345 | (37.7901031363132, -122.455752999345) | |||
| 104384 | 104384 | 98316 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1800X Clay St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 2x2 | 6006008.9 | 2116666.9 | 37.7923032687502 | -122.42313202643899 | (37.7923032687502, -122.423132026439) | ||||
| 103566 | 103566 | 94487 | Property Tree 7 | Cupressus sempervirens :: Italian Cypress 136 | 4128 17th St | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 103402 | 103402 | 101698 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2700 18th St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 2x3 | 6009810.4 | 2105505.4 | 37.7618702017999 | -122.409190731152 | (37.7618702017999, -122.409190731152) | ||||
| 101916 | 101916 | 26413 | DPW Maintained 3 | Cupressus sempervirens :: Italian Cypress 136 | 34 Maple St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996568.2197254 | 2116061.2858977 | 37.790103136313206 | -122.455752999345 | (37.7901031363132, -122.455752999345) | |||
| 101423 | 101423 | 52849 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 50 Lansing St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014349.88850075 | 2114221.0453464002 | 37.7860546845502 | -122.394100496655 | (37.7860546845502, -122.394100496655) | |
| 93747 | 93747 | 26415 | DPW Maintained 3 | Cupressus sempervirens :: Italian Cypress 136 | 34 Maple St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996568.2197254 | 2116061.2858977 | 37.790103136313206 | -122.455752999345 | (37.7901031363132, -122.455752999345) | |||
| 93173 | 93173 | 52845 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 11X Guy Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014349.88850075 | 2114221.0453464002 | 37.7860546845502 | -122.394100496655 | (37.7860546845502, -122.394100496655) | |
| 89776 | 89776 | 98528 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 428 11th St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/22/2012 12:00:00 AM | 3x3 | Permit Number 768342 | 6009030.0 | 2108561.0 | 37.7702164230423 | -122.41210579217699 | (37.7702164230423, -122.412105792177) | ||
| 86057 | 86057 | 94469 | Property Tree 7 | Cupressus sempervirens :: Italian Cypress 136 | 4128 17th St | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 82709 | 82709 | 46248 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 1675 Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2002 12:00:00 AM | Permit Number 44536 | 6016787.6752368 | 2092188.79463336 | 37.7256939401069 | -122.384131467798 | (37.7256939401069, -122.384131467798) | |||
| 80042 | 80042 | 112741 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2514 CLAY ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6002696.0 | 2116178.0 | 37.7907733646004 | -122.43455974658 | (37.7907733646004, -122.43455974658) | ||||
| 73931 | 73931 | 223821 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1315 Utah St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6010905.03625 | 2102087.35489 | 37.752546274702794 | -122.405164102267 | (37.7525462747028, -122.405164102267) |
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");