Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1054 | 1054 | 125462 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 125 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 52121 | 6009895.29665 | 2113891.24599 | 37.7849005400769 | -122.40948896803499 | (37.7849005400769, -122.409488968035) | |
24123 | 24123 | 175160 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000093.42571 | 2092311.2225 | 37.7250929691415 | -122.44185080298 | (37.7250929691415, -122.44185080298) | |||
33529 | 33529 | 175163 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000100.60606 | 2092317.35748 | 37.7251102235329 | -122.44182642145701 | (37.7251102235329, -122.441826421457) | |||
34506 | 34506 | 125457 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2807 Steiner St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6002053.50035 | 2117793.13608 | 37.795171616221104 | -122.43689843522101 | (37.7951716162211, -122.436898435221) | |||
41654 | 41654 | 125506 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 7 Fallon Pl | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6008920.97468 | 2118571.47788 | 37.7976966751291 | -122.413190886946 | (37.7976966751291, -122.413190886946) | |||
42654 | 42654 | 125464 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 887 Eddy St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6006280.54306 | 2113153.33425 | 37.782671211560704 | -122.4219424317 | (37.7826712115607, -122.4219424317) | |||
47152 | 47152 | 125475 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 150 Sproule Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009249.92549 | 2116801.2629400003 | 37.7928545606515 | -122.41192746357599 | (37.7928545606515, -122.411927463576) | |||
47327 | 47327 | 201923 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 125 Elmira St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6011215.48386 | 2096005.8192 | 37.735865039640395 | -122.403662651736 | (37.7358650396404, -122.403662651736) | |||
48661 | 48661 | 125469 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1177 California St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6008779.73096 | 2116281.55689 | 37.791401184258795 | -122.413517591782 | (37.7914011842588, -122.413517591782) | |||
48805 | 48805 | 220628 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 907 Elizabeth St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6000553.10276 | 2101957.71166 | 37.751606143208 | -122.44095346395201 | (37.751606143208, -122.440953463952) | |||
49008 | 49008 | 125522 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1087 Greenwich St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6007750.4574 | 2119887.81691 | 37.8012452299295 | -122.417334539369 | (37.8012452299295, -122.417334539369) | |||
50442 | 50442 | 220612 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 9 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009640.52107 | 2098655.41337 | 37.743052146240295 | -122.409294863773 | (37.7430521462403, -122.409294863773) | |||
51580 | 51580 | 189194 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 30 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6012053.23647 | 2107512.8913 | 37.7675077191257 | -122.40157469843001 | (37.7675077191257, -122.40157469843) | |||
53779 | 53779 | 120025 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 743 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5987224.82866 | 2110876.6376900002 | 37.775326931785294 | -122.487698901899 | (37.7753269317853, -122.487698901899) | |||
54337 | 54337 | 175154 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000079.77144 | 2092298.5573 | 37.7250574153596 | -122.44189709559299 | (37.7250574153596, -122.441897095593) | |||
54839 | 54839 | 125453 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2401 Broadway | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6002078.25785 | 2117342.70193 | 37.793936248105 | -122.43678051073299 | (37.793936248105, -122.436780510733) | |||
55076 | 55076 | 125501 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1115 Filbert St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6007553.747280001 | 2119514.62481 | 37.8002094690578 | -122.417988773678 | (37.8002094690578, -122.417988773678) | |||
57123 | 57123 | 175162 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000098.0141199995 | 2092315.01212 | 37.7251036360216 | -122.441835213242 | (37.7251036360216, -122.441835213242) | |||
58417 | 58417 | 125477 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 150 Sproule Ln | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009239.02025 | 2116870.71678 | 37.793044652131 | -122.41197010674802 | (37.793044652131, -122.411970106748) | |||
61016 | 61016 | 125467 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1177 California St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6008702.23207 | 2116269.4831 | 37.791363680726796 | -122.413784882888 | (37.7913636807268, -122.413784882888) | |||
64478 | 64478 | 125452 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2401 Broadway | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6002068.61749 | 2117342.59163 | 37.7939353973611 | -122.436813859368 | (37.7939353973611, -122.436813859368) | |||
65811 | 65811 | 175157 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000084.80379 | 2092303.48045 | 37.7250712199557 | -122.44188005254 | (37.7250712199557, -122.44188005254) | |||
69728 | 69728 | 125437 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1921 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6000052.89269 | 2121248.37983 | 37.8045448847905 | -122.44406922002199 | (37.8045448847905, -122.444069220022) | |||
70001 | 70001 | 175158 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000088.06493 | 2092305.57905 | 37.7250771680567 | -122.44186892971399 | (37.7250771680567, -122.441868929714) | |||
72887 | 72887 | 189192 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 30 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6012099.2034599995 | 2107516.8442700002 | 37.767521137926394 | -122.401415981588 | (37.7675211379264, -122.401415981588) | |||
73300 | 73300 | 125461 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1845 Green St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6004195.45414 | 2118342.0241799997 | 37.7968002290978 | -122.42952610606399 | (37.7968002290978, -122.429526106064) | |||
73496 | 73496 | 220620 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 747 Duncan St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6001698.74806 | 2099680.01267 | 37.745417306567 | -122.43682864783001 | (37.745417306567, -122.43682864783) | |||
76457 | 76457 | 125449 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3101 Clay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5999876.27718 | 2115725.0378099997 | 37.789369177790206 | -122.444283251471 | (37.7893691777902, -122.444283251471) | |||
76565 | 76565 | 220629 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 907 Elizabeth St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6000561.393680001 | 2101957.84527 | 37.7516069822761 | -122.440924802556 | (37.7516069822761, -122.440924802556) | |||
76902 | 76902 | 175164 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000102.2336800005 | 2092318.3901400003 | 37.7251131517233 | -122.44182086904301 | (37.7251131517233, -122.441820869043) | |||
79896 | 79896 | 220604 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 446 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6003586.44761 | 2100127.58593 | 37.7467533438884 | -122.430333215209 | (37.7467533438884, -122.430333215209) | |||
118179 | 118179 | 125465 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1177 California St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6008661.04402 | 2116264.72933 | 37.7913483149251 | -122.41392705669399 | (37.7913483149251, -122.413927056694) | |||
131618 | 131618 | 125455 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2401 Broadway | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6002099.50591 | 2117347.8348 | 37.7939515491883 | -122.436707358076 | (37.7939515491883, -122.436707358076) | |||
136527 | 136527 | 125466 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1177 California St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6008683.65979 | 2116266.52541 | 37.7913545166392 | -122.413848933479 | (37.7913545166392, -122.413848933479) | |||
137603 | 137603 | 117918 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 731 41st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5983185.43658 | 2110793.02592 | 37.774860926834606 | -122.501665678898 | (37.7748609268346, -122.501665678898) | |||
137746 | 137746 | 118929 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 875 La Playa | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5980750.23602 | 2109645.2788 | 37.7715662158284 | -122.510004109936 | (37.7715662158284, -122.510004109936) | |||
146408 | 146408 | 220630 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 901 Elizabeth St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6000579.189809999 | 2101957.47614 | 37.7516069822848 | -122.44086323496 | (37.7516069822848, -122.44086323496) | |||
148949 | 148949 | 189196 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 30 15th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6012020.7847 | 2107509.88543 | 37.767497654832894 | -122.401686734167 | (37.7674976548329, -122.401686734167) | |||
150229 | 150229 | 125458 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2371 Broadway | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6002284.26434 | 2117368.32549 | 37.794018309436396 | -122.436069543591 | (37.7940183094364, -122.436069543591) | |||
150463 | 150463 | 125478 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 150 Sproule Ln | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009235.21214 | 2116893.1375 | 37.79310600030529 | -122.411984868232 | (37.7931060003053, -122.411984868232) | |||
150893 | 150893 | 189163 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2324 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6010839.472159999 | 2105097.2568200002 | 37.7608071304715 | -122.405602811334 | (37.7608071304715, -122.405602811334) | |||
151194 | 151194 | 220621 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 714 Duncan St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6001868.87894 | 2099747.43156 | 37.745612090735506 | -122.43624518748999 | (37.7456120907355, -122.43624518749) | |||
151252 | 151252 | 125507 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 7 Fallon Pl | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6008925.22265 | 2118571.08085 | 37.7976958234636 | -122.41317615966801 | (37.7976958234636, -122.413176159668) | |||
152269 | 152269 | 220631 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 901 Elizabeth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6000591.194080001 | 2101959.06133 | 37.751612018500204 | -122.440821836477 | (37.7516120185002, -122.440821836477) | |||
153719 | 153719 | 125456 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2401 Broadway | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6002104.20596 | 2117349.59529 | 37.79395665014079 | -122.436691221543 | (37.7939566501408, -122.436691221543) | |||
154701 | 154701 | 220611 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6009641.7814 | 2098664.7156700003 | 37.743077758937105 | -122.40929116218399 | (37.7430777589371, -122.409291162184) | |||
155489 | 155489 | 125460 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2416 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6003175.77984 | 2117097.00502 | 37.7933239410913 | -122.432965418428 | (37.7933239410913, -122.432965418428) | |||
155868 | 155868 | 125451 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2601 Vallejo St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6001095.19419 | 2117566.7818299998 | 37.7944955940578 | -122.44019807567499 | (37.7944955940578, -122.440198075675) | |||
156172 | 156172 | 249529 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1035 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6006430.75514 | 2114125.51985 | 37.7853490652506 | -122.4214918273 | (37.7853490652506, -122.4214918273) | |||
157035 | 157035 | 125454 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2401 Broadway | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6002093.86703 | 2117345.7842200003 | 37.7939455983674 | -122.43672672227 | (37.7939455983674, -122.43672672227) | |||
160711 | 160711 | 175159 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000090.185269999 | 2092307.21266 | 37.7250817743959 | -122.441861717141 | (37.7250817743959, -122.441861717141) | |||
164426 | 164426 | 125476 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 150 Sproule Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009246.74599 | 2116823.51326 | 37.792915476223705 | -122.41194003791 | (37.7929154762237, -122.41194003791) | |||
168173 | 168173 | 125468 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1177 California St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6008726.14199 | 2116272.16952 | 37.7913723996763 | -122.413702344902 | (37.7913723996763, -122.413702344902) | |||
171065 | 171065 | 125463 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 935 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006804.241090001 | 2113922.09635 | 37.7848115656375 | -122.42018523378599 | (37.7848115656375, -122.420185233786) | |||
172151 | 172151 | 220652 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 324 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6006873.24491 | 2096273.48816 | 37.7363564804515 | -122.418694495969 | (37.7363564804515, -122.418694495969) | |||
172584 | 172584 | 125474 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 150 Sproule Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009252.35721 | 2116781.07333 | 37.792799261332 | -122.411917622313 | (37.792799261332, -122.411917622313) | |||
173529 | 173529 | 125459 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2371 Broadway | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6002302.24315 | 2117372.6414900003 | 37.7940311814406 | -122.436007644151 | (37.7940311814406, -122.436007644151) | |||
173963 | 173963 | 203499 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 379 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5997569.0689199995 | 2093791.20398 | 37.7290124835419 | -122.45068384968799 | (37.7290124835419, -122.450683849688) | |||
178536 | 178536 | 189195 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 30 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6012037.52857 | 2107512.72185 | 37.767506377346294 | -122.401629018386 | (37.7675063773463, -122.401629018386) | |||
179679 | 179679 | 175156 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000083.66792 | 2092301.69867 | 37.7250662628724 | -122.441883851284 | (37.7250662628724, -122.441883851284) | |||
182457 | 182457 | 246824 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 402 Franconia St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6009972.67277 | 2098701.6792900003 | 37.7431977860534 | -122.408149630203 | (37.7431977860534, -122.408149630203) | |||
183613 | 183613 | 175155 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000081.06235 | 2092299.82458 | 37.7250609685792 | -122.441892723985 | (37.7250609685792, -122.441892723985) | |||
184886 | 184886 | 175161 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000095.42068 | 2092313.2586299998 | 37.7250986735632 | -122.44184405267 | (37.7250986735632, -122.44184405267) | |||
188590 | 188590 | 189193 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 30 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6012073.860090001 | 2107513.44954 | 37.767510402696296 | -122.401503402873 | (37.7675104026963, -122.401503402873) |
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");