Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26278 | 26278 | 249950 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 303 Filbert St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 0ft | 6011359.33086 | 2120056.95578 | 37.801912024192795 | -122.404858102512 | (37.8019120241928, -122.404858102512) | |||
| 35258 | 35258 | 120266 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 100 24th Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5988365.77159 | 2115120.59325 | 37.78704611790379 | -122.48406345051399 | (37.7870461179038, -122.484063450514) | ||||
| 53096 | 53096 | 125439 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 99 Collins St | 0 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5998117.25486 | 2114050.06951 | 37.7846696436241 | -122.450248453727 | (37.7846696436241, -122.450248453727) | ||||
| 60021 | 60021 | 249949 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 303 Filbert St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 0ft | 6011354.62644 | 2120055.4997 | 37.801907763195 | -122.404874279527 | (37.801907763195, -122.404874279527) | |||
| 157854 | 157854 | 203451 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1515 16th Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 8ft | 5991183.11857 | 2105012.94014 | 37.7594568739424 | -122.473578579008 | (37.7594568739424, -122.473578579008) | |||
| 173419 | 173419 | 203452 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1515 16th Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 8ft | 5991186.2272 | 2105007.12865 | 37.7594410971589 | -122.473567404026 | (37.7594410971589, -122.473567404026) | |||
| 175990 | 175990 | 203450 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1515 16th Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 8ft | 5991181.21192 | 2105021.0246 | 37.7594789613077 | -122.47358576280001 | (37.7594789613077, -122.4735857628) | |||
| 38814 | 38814 | 221775 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 21 Addison St | 14 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 3ft | 6003667.46569 | 2096848.61536 | 37.737754634878 | -122.429819221204 | (37.737754634878, -122.429819221204) | |||
| 129485 | 129485 | 97033 | Property Tree 7 | Afrocarpus gracilior :: Fern Pine 70 | 61 Vicksburg St | Back Yard : Yard 13 | Tree 1 | Private 1 | Possible significant tree; Nellie RoW; rear yard | 6004120.0 | 2102703.0 | 37.753855038047 | -122.428671801406 | (37.753855038047, -122.428671801406) | |||||
| 174700 | 174700 | 118571 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 7940 Geary Blvd | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 5982344.86422 | 2112440.78156 | 37.779335773230294 | -122.50469546097601 | (37.7793357732303, -122.504695460976) | ||||
| 29119 | 29119 | 220589 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 653 Duncan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6002332.20411 | 2099716.00641 | 37.7455521185496 | -122.43464083471301 | (37.7455521185496, -122.434640834713) | |||
| 33859 | 33859 | 220622 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 58 Fountain St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6000334.98133 | 2101342.05017 | 37.7499032598351 | -122.441663574927 | (37.7499032598351, -122.441663574927) | |||
| 34843 | 34843 | 250128 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1798 Pine St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6005370.71997 | 2115516.69917 | 37.78910907136579 | -122.42525826176399 | (37.7891090713658, -122.425258261764) | |||
| 35750 | 35750 | 250093 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1700 Gough St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6005332.30774 | 2115621.39854 | 37.789394379498894 | -122.425398617158 | (37.7893943794989, -122.425398617158) | |||
| 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) | |||
| 55795 | 55795 | 189170 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 360 Texas St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 6013732.7365 | 2105419.1930299997 | 37.761852457439495 | -122.395618779897 | (37.7618524574395, -122.395618779897) | |||
| 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) | |||
| 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) | |||
| 134317 | 134317 | 125539 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 31 Spofford St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010570.5264 | 2117382.56278 | 37.794524670939204 | -122.407399099212 | (37.7945246709392, -122.407399099212) | |||
| 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) | |||
| 143941 | 143941 | 32129 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 35 Spofford Ln | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35491 | 6010554.96159279 | 2117351.45133924 | 37.7944383752725 | -122.407450761229 | (37.7944383752725, -122.407450761229) | ||
| 159347 | 159347 | 220623 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 58 Fountain St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6000335.70641 | 2101336.8621 | 37.7498890559574 | -122.44166069529699 | (37.7498890559574, -122.441660695297) | |||
| 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) | |||
| 176107 | 176107 | 220590 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 653 Duncan St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6002350.00188 | 2099716.4641400003 | 37.7455543857324 | -122.43457932557399 | (37.7455543857324, -122.434579325574) | |||
| 178896 | 178896 | 220609 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 385 Nevada St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 2ft | 6008945.60793 | 2096515.87148 | 37.737138473362 | -122.411546563846 | (37.737138473362, -122.411546563846) | |||
| 183859 | 183859 | 220608 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 385 Nevada St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 2ft | 6008946.36134 | 2096525.7454799998 | 37.7371656274845 | -122.41154465636801 | (37.7371656274845, -122.411544656368) | |||
| 22809 | 22809 | 125505 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 45 Havens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6007613.99229 | 2119386.63886 | 37.799861442220895 | -122.41777122496 | (37.7998614422209, -122.41777122496) | ||||
| 23721 | 23721 | 220632 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 18 Kronquist Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 6002213.33941 | 2100174.25358 | 37.746803608795396 | -122.43508461868299 | (37.7468036087954, -122.435084618683) | |||
| 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) | |||
| 25297 | 25297 | 203469 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 300 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5998711.4385400005 | 2094111.50955 | 37.7299572914866 | -122.446757644361 | (37.7299572914866, -122.446757644361) | ||||
| 26400 | 26400 | 203471 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 410 Faxon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5994790.95036 | 2091337.27547 | 37.7221151744519 | -122.460110243003 | (37.7221151744519, -122.460110243003) | |||
| 30635 | 30635 | 125520 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008570.50339 | 2119026.46396 | 37.798926272277704 | -122.414435828363 | (37.7989262722777, -122.414435828363) | |||
| 30833 | 30833 | 220633 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 18 Kronquist Ct | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 6002213.10405 | 2100169.21088 | 37.7467897493647 | -122.435085071929 | (37.7467897493647, -122.435085071929) | |||
| 31793 | 31793 | 221773 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 5587 Diamond Heights Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6001626.70915 | 2097120.97663 | 37.7383866990834 | -122.436894581628 | (37.7383866990834, -122.436894581628) | |||
| 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) | |||
| 35121 | 35121 | 125494 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6006034.74479 | 2120336.40198 | 37.8023802517163 | -122.423303571803 | (37.8023802517163, -122.423303571803) | |||
| 35158 | 35158 | 125513 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008593.294869999 | 2119027.33171 | 37.798929935227 | -122.414357023482 | (37.798929935227, -122.414357023482) | |||
| 35686 | 35686 | 125515 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008587.48018 | 2119026.85751 | 37.7989283065533 | -122.414377110727 | (37.7989283065533, -122.414377110727) | |||
| 35891 | 35891 | 125523 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 220 Lombard St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 9ft | 6011207.16585 | 2120734.5295700002 | 37.8037639692824 | -122.40543241409401 | (37.8037639692824, -122.405432414094) | |||
| 39883 | 39883 | 203492 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 23 Melrose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5999946.35958 | 2095464.23555 | 37.7337420298607 | -122.442585473564 | (37.7337420298607, -122.442585473564) | |||
| 40273 | 40273 | 125508 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 7 Fallon Pl | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6008930.4214699995 | 2118571.4914 | 37.797697242591504 | -122.41315819931299 | (37.7976972425915, -122.413158199313) | |||
| 40963 | 40963 | 125473 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 655 Powell St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6010077.67437 | 2116003.04391 | 37.7907092485717 | -122.409007053757 | (37.7907092485717, -122.409007053757) | |||
| 41144 | 41144 | 175153 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 783 Cayuga Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6001323.552619999 | 2092431.0494099997 | 37.7254920046417 | -122.43760697060101 | (37.7254920046417, -122.437606970601) | |||
| 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) | |||
| 45984 | 45984 | 125495 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6006051.2199 | 2120336.9264 | 37.802382621428706 | -122.423246597049 | (37.8023826214287, -122.423246597049) | |||
| 46074 | 46074 | 221767 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 287 Hermann St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6003902.82897 | 2108654.79623 | 37.770184952298 | -122.429847331292 | (37.770184952298, -122.429847331292) | |||
| 47885 | 47885 | 125511 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 6008625.76186 | 2119029.2242099997 | 37.7989369553212 | -122.41424481055799 | (37.7989369553212, -122.414244810558) | |||
| 48362 | 48362 | 125504 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1001 Lombard St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 6007489.69173 | 2120199.0729400003 | 37.8020851859507 | -122.418258985774 | (37.8020851859507, -122.418258985774) | |||
| 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) | |||
| 48836 | 48836 | 203495 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 363 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5999677.596390001 | 2094931.24105 | 37.732263227850204 | -122.443476391437 | (37.7322632278502, -122.443476391437) | |||
| 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) | |||
| 49140 | 49140 | 175171 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Vienna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6003766.2619199995 | 2091125.7997700002 | 37.7220466613948 | -122.429069717203 | (37.7220466613948, -122.429069717203) | |||
| 49806 | 49806 | 221764 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3809 16th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6001727.44948 | 2106346.3994299998 | 37.7637232334694 | -122.437206631108 | (37.7637232334694, -122.437206631108) | |||
| 49868 | 49868 | 125509 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6008633.29576 | 2119030.27082 | 37.7989402522368 | -122.41421881477301 | (37.7989402522368, -122.414218814773) | |||
| 51714 | 51714 | 125450 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 44 Normandie Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6000949.24806 | 2117425.20451 | 37.79409854965171 | -122.44069290604999 | (37.7940985496517, -122.44069290605) | |||
| 51784 | 51784 | 125483 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1471 Washington St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6007681.40554 | 2117137.6606799997 | 37.793690101870205 | -122.417378482047 | (37.7936901018702, -122.417378482047) | |||
| 52304 | 52304 | 220625 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 665 Elizabeth St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6002079.843669999 | 2102040.673 | 37.751920772823794 | -122.43567974235 | (37.7519207728238, -122.43567974235) | |||
| 52909 | 52909 | 175174 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Vienna St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6003793.29108 | 2091173.5648599998 | 37.722179343787396 | -122.428979687879 | (37.7221793437874, -122.428979687879) | |||
| 53366 | 53366 | 203468 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 480 Hearst Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 2ft | 5998155.09728 | 2094421.38368 | 37.7307763355428 | -122.448703284436 | (37.7307763355428, -122.448703284436) | |||
| 53916 | 53916 | 220624 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 665 Elizabeth St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6002066.32428 | 2102040.31203 | 37.7519190137697 | -122.435726468425 | (37.7519190137697, -122.435726468425) | |||
| 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) | |||
| 54933 | 54933 | 203443 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Marne Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5995223.6819 | 2097798.00617 | 37.7398796519151 | -122.459081986971 | (37.7398796519151, -122.459081986971) | |||
| 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) | |||
| 56741 | 56741 | 220619 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 618 28th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6001863.58646 | 2099454.0588599998 | 37.744806257700205 | -122.43624249671801 | (37.7448062577002, -122.436242496718) | ||||
| 56962 | 56962 | 220618 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 237 Murray St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 6005720.296519999 | 2095375.55283 | 37.7338259689755 | -122.422616936749 | (37.7338259689755, -122.422616936749) | |||
| 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) | |||
| 60506 | 60506 | 203484 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 101 Los Palmos Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5998423.23469 | 2096036.13552 | 37.7352253905456 | -122.447892505138 | (37.7352253905456, -122.447892505138) | |||
| 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) | |||
| 64600 | 64600 | 203500 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 77 Staples Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5999471.94159 | 2093749.5809 | 37.729006934723 | -122.444102506626 | (37.729006934723, -122.444102506626) | |||
| 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) | |||
| 66904 | 66904 | 203470 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 100 Staples Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 5999333.68862 | 2093807.8865599998 | 37.72915914047 | -122.444584644873 | (37.72915914047, -122.444584644873) | ||||
| 67240 | 67240 | 125498 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1154 Chestnut St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6006270.07079 | 2120429.11585 | 37.8026480985929 | -122.422495818752 | (37.8026480985929, -122.422495818752) | |||
| 67817 | 67817 | 125519 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008571.89831 | 2119026.74658 | 37.798927126643896 | -122.414431021472 | (37.7989271266439, -122.414431021472) | |||
| 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) | |||
| 70954 | 70954 | 125443 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2298 Beach St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5999265.80635 | 2120844.85189 | 37.8033919746241 | -122.446763941418 | (37.8033919746241, -122.446763941418) | |||
| 71361 | 71361 | 203465 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 480 Hearst Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 5998202.03163 | 2094421.3515299999 | 37.7307789309899 | -122.448541023359 | (37.7307789309899, -122.448541023359) | |||
| 71919 | 71919 | 125496 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6006063.84143 | 2120339.6871599997 | 37.802390914060204 | -122.42320311664899 | (37.8023909140602, -122.423203116649) | |||
| 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) | |||
| 74953 | 74953 | 125514 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 6008590.31929 | 2119027.3925900003 | 37.7989299352366 | -122.414367324317 | (37.7989299352366, -122.414367324317) | |||
| 75383 | 75383 | 125524 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 220 Lombard St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 9ft | 6011207.6846199995 | 2120726.9389400003 | 37.8037431562814 | -122.40543008395201 | (37.8037431562814, -122.405430083952) | |||
| 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) | |||
| 76694 | 76694 | 125491 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6005994.09185 | 2120329.4714599997 | 37.8023589278732 | -122.42344375814599 | (37.8023589278732, -122.423443758146) | |||
| 76753 | 76753 | 125472 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 655 Powell St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6010077.8197800005 | 2116010.1713 | 37.790728826812206 | -122.40900705375401 | (37.7907288268122, -122.409007053754) | |||
| 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) | |||
| 102425 | 102425 | 125510 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008630.57528 | 2119029.65242 | 37.79893840145329 | -122.41422818478901 | (37.7989384014533, -122.414228184789) | |||
| 126745 | 126745 | 220651 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 45 Stoneman St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6008064.96703 | 2099392.46104 | 37.74498751697679 | -122.41479487098101 | (37.7449875169768, -122.414794870981) | |||
| 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) | |||
| 132173 | 132173 | 203487 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 828 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5998282.181969999 | 2096469.8668799999 | 37.736408249925 | -122.44841139867201 | (37.736408249925, -122.448411398672) | |||
| 133444 | 133444 | 221774 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 5587 Diamond Heights Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6001628.85719 | 2097123.02869 | 37.7383924556487 | -122.43688730163 | (37.7383924556487, -122.43688730163) | |||
| 133637 | 133637 | 189200 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 625 Mendell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6016323.4017 | 2097117.36023 | 37.7392011179238 | -122.38607986071699 | (37.7392011179238, -122.386079860717) | |||
| 134166 | 134166 | 203466 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 480 Hearst Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 5998189.167859999 | 2094420.9335599998 | 37.7307770478103 | -122.448585465162 | (37.7307770478103, -122.448585465162) | |||
| 134395 | 134395 | 125517 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 6008575.41519 | 2119026.3782099998 | 37.7989263127569 | -122.414418825785 | (37.7989263127569, -122.414418825785) | |||
| 134639 | 134639 | 203462 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 112 Baden St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 6000775.11209 | 2094438.40357 | 37.7309725397368 | -122.43964672021299 | (37.7309725397368, -122.439646720213) | |||
| 136680 | 136680 | 203485 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 101 Los Palmos Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5998424.41404 | 2096025.6755 | 37.7351967372311 | -122.447887674883 | (37.7351967372311, -122.447887674883) | |||
| 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) |
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");