trees
267 rows where qSpecies_id = 100 sorted by Location
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18738 | 19646 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 45 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
| 18793 | 19631 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
| 18817 | 19689 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 88 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
| 18925 | 19645 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 44 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 30 | |||||||||||||
| 19223 | 19615 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
| 19228 | 19750 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY15 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
| 19337 | 20012 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY47 | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 100ST | |||||||||||||
| 19429 | 19994 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY46 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | |||||||||||||
| 19598 | 19633 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
| 101304 | 24281 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 300X Winding Way | 19 | Median : Cutout | Tree | DPW 1 | 3 | 8 | 6001646.2933309 | 2086550.8578367 | 37.7093646550959 | -122.436070699117 | (37.7093646550959, -122.436070699117) | 9 | 7 | 6 | 28861 | 5 | |||
| 192604 | 24284 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 300X Winding Way | 22 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6001646.2933309 | 2086550.8578367 | 37.7093646550959 | -122.436070699117 | (37.7093646550959, -122.436070699117) | 9 | 7 | 6 | 28861 | 5 | |||
| 28928 | 116154 | Property Tree 8 | Pinus Spp :: Pine Spp 100 | 324 POPE ST | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6000502 | 2087202 | 37.7110874704678 | -122.440072212787 | (37.7110874704678, -122.440072212787) | 9 | 7 | 6 | 28861 | 5 | ||||
| 57780 | 12503 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1200X Lake Merced Blvd | 5 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 5987438.4549992 | 2087542.2692131 | 37.7112694082243 | -122.485247377649 | (37.7112694082243, -122.485247377649) | 1 | 8 | 4 | 64 | 14 | |||
| 174020 | 12499 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1200X Lake Merced Blvd | 1 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 5987438.4549992 | 2087542.2692131 | 37.7112694082243 | -122.485247377649 | (37.7112694082243, -122.485247377649) | 1 | 8 | 4 | 64 | 14 | |||
| 90168 | 91487 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 750x Brotherhood Way | 21 | Median : Cutout | Tree | DPW 1 | 03/15/2007 12:00:00 AM | 3 | 5991053.474445 | 2088092.036965 | 37.7129888676025 | -122.472793145921 | (37.7129888676025, -122.472793145921) | 1 | 8 | 4 | 64 | 14 | |||
| 72299 | 200142 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 700 Jamestown Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015325.0376 | 2088350.2198 | 37.7150729908419 | -122.388919862472 | (37.7150729908419, -122.388919862472) | 10 | 3 | 8 | 58 | 1 | |||
| 177971 | 200796 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 700 Jamestown Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015315.685 | 2088368.925 | 37.7151238332906 | -122.388953494511 | (37.7151238332906, -122.388953494511) | 10 | 3 | 8 | 58 | 1 | |||
| 57396 | 106550 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 81 MINERVA ST | Median : Cutout | Tree | DPW 1 | 5996079.6 | 2088963.3 | 37.7156708325413 | -122.455484227095 | (37.7156708325413, -122.455484227095) | 9 | 8 | 6 | 28861 | 24 | ||||||
| 35747 | 93927 | Permitted Site 7 | Pinus Spp :: Pine Spp 100 | 737 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5988857.6 | 2089713.7 | 37.7173141872637 | -122.480501360019 | (37.7173141872637, -122.480501360019) | 1 | 8 | 4 | 64 | 14 | |||
| 63239 | 93054 | Permitted Site 7 | Pinus Spp :: Pine Spp 100 | 737 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 04/28/2010 12:00:00 AM | 49 | Permit Number 53387 | 5988857.6 | 2089713.7 | 37.7173141872637 | -122.480501360019 | (37.7173141872637, -122.480501360019) | 1 | 8 | 4 | 64 | 14 | ||
| 162240 | 93928 | Permitted Site 7 | Pinus Spp :: Pine Spp 100 | 737 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5988857.6 | 2089713.7 | 37.7173141872637 | -122.480501360019 | (37.7173141872637, -122.480501360019) | 1 | 8 | 4 | 64 | 14 | |||
| 173188 | 29631 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1110X Junipero Serra Blvd | 4 | Median : Cutout | Tree | DPW 1 | 3 | 3X3 | 5991107.8990451 | 2089843.5367701 | 37.717801208369 | -122.47273266668 | (37.717801208369, -122.47273266668) | 9 | 8 | 4 | 64 | 40 | |||
| 48765 | 98082 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 525 Grafton Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5995193.7 | 2090526.9 | 37.7199132334677 | -122.45865940878 | (37.7199132334677, -122.45865940878) | 9 | 8 | 6 | 28861 | 24 | |||||
| 177628 | 93925 | Permitted Site 7 | Pinus Spp :: Pine Spp 100 | 3711 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990297.3 | 2090806 | 37.7203969366505 | -122.475604756889 | (37.7203969366505, -122.475604756889) | 1 | 8 | 4 | 64 | 14 | |||||
| 50522 | 93931 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | Front Yard : Yard | Tree | Private 2 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5990375.96797 | 2090932.55284 | 37.7207489795508 | -122.475342064841 | (37.7207489795508, -122.475342064841) | 1 | 8 | 4 | 64 | 14 | |||||
| 105498 | 93932 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | Front Yard : Yard | Tree | Private 2 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5990375.96797 | 2090932.55284 | 37.7207489795508 | -122.475342064841 | (37.7207489795508, -122.475342064841) | 1 | 8 | 4 | 64 | 14 | |||||
| 26457 | 194520 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1600 Bay Shore Blvd | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6012006.62045 | 2091255.62525 | 37.7228661524341 | -122.400593779099 | (37.7228661524341, -122.400593779099) | 10 | 3 | 7 | 309 | 28 | |||
| 193841 | 211046 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 251 Wildwood Way | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 3ft | 5995705.57302 | 2093291.07499 | 37.7275324053909 | -122.457089894179 | (37.7275324053909, -122.457089894179) | 9 | 7 | 4 | 28861 | 40 | |||
| 124810 | 107321 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 400X JUNIPERO SERRA BLVD | 4 | Median : Cutout | Tree | DPW 1 | 14 | 5991395 | 2094254 | 37.7299278633008 | -122.47206158935 | (37.7299278633008, -122.47206158935) | 9 | 8 | 4 | 64 | 40 | ||||
| 124287 | 211045 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 380 Santa Clara Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | Width 3ft | 5993150.7745 | 2095420.35942 | 37.7332318444736 | -122.466076441693 | (37.7332318444736, -122.466076441693) | 9 | 8 | 4 | 59 | 40 | |||
| 98857 | 211044 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 372 Santa Clara Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 53 | Width 3ft | 5993146.9743 | 2095534.41654 | 37.7335447977497 | -122.466097865337 | (37.7335447977497, -122.466097865337) | 9 | 8 | 4 | 59 | 40 | |||
| 103685 | 248958 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 98x Rosewood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2017 12:00:00 AM | 3 | 3x3 | 5994824 | 2095658 | 37.7339807377795 | -122.460308897898 | (37.7339807377795, -122.460308897898) | 9 | 8 | 4 | 59 | 40 | ||
| 45445 | 21490 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2792X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985060.3629888 | 2096294.4798015 | 37.7351618711636 | -122.49411119238 | (37.7351618711636, -122.49411119238) | 1 | 8 | 3 | 29491 | 35 | |||
| 985 | 262391 | Private 9 | Pinus Spp :: Pine Spp 100 | 2646 38th Ave | 1 | Back Yard : Yard | Tree | Private 2 | Width 0ft | 5984657 | 2097167 | 37.7375339667511 | -122.495570077384 | (37.7375339667511, -122.495570077384) | 1 | 8 | 3 | 29491 | 35 | ||||
| 175429 | 187119 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2600 Sunset Blvd | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985168.1593 | 2097316.6584 | 37.7379748077492 | -122.493813809362 | (37.7379748077492, -122.493813809362) | 1 | 8 | 3 | 29491 | 35 | |||
| 135364 | 185161 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2500 Sunset Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985124.0613 | 2097656.7845 | 37.7389061227579 | -122.493991335448 | (37.7389061227579, -122.493991335448) | 1 | 8 | 3 | 29491 | 35 | |||
| 10838 | 233336 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 5545 Diamond Heights Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 9ft | 6001777.47587 | 2097325.41548 | 37.7389566084644 | -122.436387932367 | (37.7389566084644, -122.436387932367) | 2 | 7 | 5 | 63 | 7 | |||
| 161472 | 185163 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2500 Sunset Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985155.9352 | 2097682.682 | 37.7389790952829 | -122.493883039881 | (37.7389790952829, -122.493883039881) | 1 | 8 | 3 | 29491 | 35 | |||
| 35177 | 13405 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 362 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 45 | 5 | 5999656.8275613 | 2097385.3812268 | 37.7390005339934 | -122.443724438614 | (37.7390005339934, -122.443724438614) | 9 | 7 | 4 | 59 | 40 | |||
| 182791 | 13404 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 360 Marietta Dr | 2 | Median : Cutout | Tree | DPW 1 | 40 | 5x1000 | 5999647.998558 | 2097391.335153 | 37.7390163784819 | -122.44375539278 | (37.7390163784819, -122.44375539278) | 9 | 7 | 4 | 59 | 40 | |||
| 185727 | 185166 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2500 Sunset Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985143.9825 | 2097713.2278 | 37.7390622665176 | -122.493926616722 | (37.7390622665176, -122.493926616722) | 1 | 8 | 3 | 29491 | 35 | |||
| 193255 | 185171 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2500 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985156.5992 | 2097759.0465 | 37.7391888105651 | -122.493886370266 | (37.7391888105651, -122.493886370266) | 1 | 8 | 3 | 29491 | 35 | |||
| 97619 | 187039 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2501 Sunset Blvd | 58 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984947.4301 | 2097783.6094 | 37.7392440133349 | -122.494611382457 | (37.7392440133349, -122.494611382457) | 1 | 8 | 3 | 29491 | 35 | |||
| 43322 | 21267 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2492X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984994.4282385 | 2098239.2478178 | 37.740497824548 | -122.494482465671 | (37.740497824548, -122.494482465671) | 1 | 8 | 3 | 29491 | 35 | |||
| 169924 | 187279 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2401 Sunset Blvd | 62 | Median : Yard | Tree | DPW 1 | 4 | Width 0ft | 5984952.4466 | 2098301.7622 | 37.7406670151021 | -122.494632227246 | (37.7406670151021, -122.494632227246) | 1 | 8 | 3 | 29491 | 35 | |||
| 45981 | 185462 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2400 Sunset Blvd | 13 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985138.3382 | 2098374.943 | 37.740878828405 | -122.493994886454 | (37.740878828405, -122.493994886454) | 1 | 8 | 3 | 29491 | 35 | |||
| 130886 | 187232 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2401 Sunset Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984921.2891 | 2098611.514 | 37.7415156862998 | -122.494762787921 | (37.7415156862998, -122.494762787921) | 1 | 8 | 3 | 29491 | 35 | |||
| 183847 | 185496 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2400 Sunset Blvd | 50 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5985141.6583 | 2098649.8553 | 37.7416338578085 | -122.494003662835 | (37.7416338578085, -122.494003662835) | 1 | 8 | 3 | 29491 | 35 | |||
| 151873 | 187220 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2401 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | Width 0ft | 5984921.2891 | 2098780.6261 | 37.7419800224632 | -122.494775253241 | (37.7419800224632, -122.494775253241) | 1 | 8 | 3 | 29491 | 35 | |||
| 25634 | 211049 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 50 Garcia Ave | 25 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 3ft | 5994782.37935 | 2099248.26832 | 37.7438363316793 | -122.460712887715 | (37.7438363316793, -122.460712887715) | 1 | 8 | 4 | 59 | 40 | |||
| 96210 | 211047 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 50 Garcia Ave | 23 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 5994823.08708 | 2099248.01179 | 37.7438379693465 | -122.460572112329 | (37.7438379693465, -122.460572112329) | 1 | 8 | 4 | 59 | 40 | |||
| 177806 | 211048 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 50 Garcia Ave | 24 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 3ft | 5994800.34548 | 2099248.4883 | 37.743837969354 | -122.460650781424 | (37.743837969354, -122.460650781424) | 1 | 8 | 4 | 59 | 40 | |||
| 104875 | 211050 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 50 Garcia Ave | 26 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 3ft | 5994765.06139 | 2099250.41987 | 37.7438412428942 | -122.460772924632 | (37.7438412428942, -122.460772924632) | 1 | 8 | 4 | 59 | 40 | |||
| 3507 | 91430 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 800X Portola Dr | 4 | Median : Cutout | Tree | DPW 1 | 10/10/2005 12:00:00 AM | 4x4 | 5996711.121131 | 2099335.742872 | 37.7441872967186 | -122.454050104178 | (37.7441872967186, -122.454050104178) | 1 | 7 | 4 | 59 | 40 | |||
| 52821 | 91428 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 800X Portola Dr | 2 | Median : Cutout | Tree | DPW 1 | 10/10/2005 12:00:00 AM | 3 | 4x4 | 5996711.121131 | 2099335.742872 | 37.7441872967186 | -122.454050104178 | (37.7441872967186, -122.454050104178) | 1 | 7 | 4 | 59 | 40 | ||
| 68559 | 91429 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 800X Portola Dr | 3 | Median : Cutout | Tree | DPW 1 | 10/10/2005 12:00:00 AM | 4x4 | 5996711.121131 | 2099335.742872 | 37.7441872967186 | -122.454050104178 | (37.7441872967186, -122.454050104178) | 1 | 7 | 4 | 59 | 40 | |||
| 137658 | 91427 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 800X Portola Dr | 1 | Median : Cutout | Tree | DPW 1 | 10/10/2005 12:00:00 AM | 4x4 | 5996711.121131 | 2099335.742872 | 37.7441872967186 | -122.454050104178 | (37.7441872967186, -122.454050104178) | 1 | 7 | 4 | 59 | 40 | |||
| 113538 | 11196 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 180 Idora Ave | 2 | Median : Cutout | Tree | DPW 1 | 3 | 8 | 5995389.3079719 | 2099438.232962 | 37.7443928282829 | -122.458628033721 | (37.7443928282829, -122.458628033721) | 1 | 8 | 4 | 59 | 40 | |||
| 151588 | 11197 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 180 Idora Ave | 3 | Median : Cutout | Tree | DPW 1 | 3 | 8 | 5995389.3079719 | 2099438.232962 | 37.7443928282829 | -122.458628033721 | (37.7443928282829, -122.458628033721) | 1 | 8 | 4 | 59 | 40 | |||
| 168059 | 187335 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2200 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985078.6769 | 2099672.3252 | 37.744437598438 | -122.49429677682 | (37.744437598438, -122.49429677682) | 1 | 8 | 3 | 29491 | 35 | |||
| 84533 | 185510 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2200 Sunset Blvd | 57 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985082.4009 | 2099946.5475 | 37.7451907564521 | -122.494304109241 | (37.7451907564521, -122.494304109241) | 1 | 8 | 3 | 29491 | 35 | |||
| 175590 | 110271 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 298X 28TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004269 | 2099559 | 37.7452307768148 | -122.427932506483 | (37.7452307768148, -122.427932506483) | 2 | 7 | 5 | 63 | 22 | ||||
| 129083 | 185537 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2201 Sunset Blvd | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984862.7264 | 2100065.7068 | 37.7455050775816 | -122.495072479787 | (37.7455050775816, -122.495072479787) | 1 | 8 | 3 | 29491 | 35 | |||
| 90765 | 113415 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 450 PORTOLA DR | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 5998094 | 2100018 | 37.7461398052423 | -122.449317577522 | (37.7461398052423, -122.449317577522) | 2 | 7 | 5 | 63 | 7 | ||||
| 21989 | 187401 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2100 Sunset Blvd | 54 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985066.4729 | 2100733.1142 | 37.747349522643 | -122.494417155333 | (37.747349522643, -122.494417155333) | 1 | 8 | 3 | 29491 | 35 | |||
| 130182 | 185865 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2000 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985059.0462 | 2100990.2907 | 37.7480552245721 | -122.494461791049 | (37.7480552245721, -122.494461791049) | 1 | 8 | 3 | 29491 | 35 | |||
| 1202 | 254563 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 98x High St | 1 | unknown : Yard | Tree | DPW 1 | 3x3 | 5999731 | 2100707 | 37.748125134697 | -122.443706547761 | (37.748125134697, -122.443706547761) | 2 | 4 | 5 | 63 | 22 | ||||
| 96144 | 186012 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1900 Sunset Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985010.9219 | 2101736.8552 | 37.750102270029 | -122.494683232466 | (37.750102270029, -122.494683232466) | 1 | 8 | 3 | 29491 | 35 | |||
| 182249 | 173897 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 90x Knollview Way | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997593 | 2101480 | 37.7501254274205 | -122.451155378281 | (37.7501254274205, -122.451155378281) | 1 | 5 | 4 | 63 | 38 | ||||
| 167631 | 112904 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 727 BURNETT AVE | Back Yard : Yard | Tree | Private 2 | 3x3 | 5999303 | 2101616 | 37.750596607185 | -122.44525189688 | (37.750596607185, -122.44525189688) | 2 | 5 | 5 | 63 | 38 | |||||
| 15464 | 262332 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1X Cuesta Ct | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5999654 | 2101769 | 37.7510367373071 | -122.444049107076 | (37.7510367373071, -122.444049107076) | 2 | 5 | 5 | 63 | 38 | ||||
| 97021 | 105907 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 1837 30TH AVE | 1 | Front Yard : Yard | Tree | Private 2 | 6 | 5986904 | 2102674 | 37.7527860393128 | -122.488205804709 | (37.7527860393128, -122.488205804709) | 1 | 8 | 3 | 56 | 35 | ||||
| 72931 | 234470 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 3717 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005016.09462 | 2102506.34942 | 37.7533657549424 | -122.425558901529 | (37.7533657549424, -122.425558901529) | 2 | 4 | 5 | 28862 | 22 | |||
| 1192 | 262086 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 6 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
| 1526 | 262088 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
| 1707 | 262090 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
| 5089 | 262085 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
| 11844 | 262089 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
| 11958 | 262083 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 9 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
| 12562 | 262087 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 5 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
| 13846 | 262084 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 8 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
| 18853 | 262082 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
| 139990 | 186132 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1700 Sunset Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984975.4043 | 2103142.7715 | 37.753960450821 | -122.494909702152 | (37.753960450821, -122.494909702152) | 1 | 8 | 3 | 56 | 35 | |||
| 70195 | 186133 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1700 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5984952.5547 | 2103165.275 | 37.7540209016237 | -122.494990379508 | (37.7540209016237, -122.494990379508) | 1 | 8 | 3 | 56 | 35 | |||
| 48449 | 186134 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1700 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984955.6705 | 2103171.5067 | 37.754038194553 | -122.49498006395 | (37.754038194553, -122.49498006395) | 1 | 8 | 3 | 56 | 35 | |||
| 90455 | 186135 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1700 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984963.2871 | 2103177.7384 | 37.7540557509571 | -122.494954183766 | (37.7540557509571, -122.494954183766) | 1 | 8 | 3 | 56 | 35 | |||
| 152496 | 186156 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1700 Sunset Blvd | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984977.8278 | 2103337.3397 | 37.7544948232836 | -122.49491566635 | (37.7544948232836, -122.49491566635) | 1 | 8 | 3 | 56 | 35 | |||
| 140163 | 194432 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 900x Carolina St | 64 | Median : Yard | Tree | DPW 1 | 17 | 6012507.9331 | 2102881.18314 | 37.754815434199 | -122.399676708016 | (37.754815434199, -122.399676708016) | 10 | 3 | 8 | 28856 | 29 | ||||
| 112548 | 3763 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1074 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 18 | 6012456.6037355 | 2102966.9856684 | 37.7550481677782 | -122.399860245008 | (37.7550481677782, -122.399860245008) | 10 | 3 | 8 | 28856 | 29 | |||
| 167995 | 3761 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1074 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 18 | 6012458 | 2102979 | 37.7550812343514 | -122.399856259894 | (37.7550812343514, -122.399856259894) | 10 | 3 | 8 | 28856 | 29 | |||
| 176168 | 3760 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1062X Carolina St | 2 | Median : Cutout | Tree | DPW 1 | 20 | 6012453.5755993 | 2103020.9691678 | 37.7551962258659 | -122.399874507795 | (37.7551962258659, -122.399874507795) | 10 | 3 | 8 | 28856 | 29 | ||||
| 40408 | 20784 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1701X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5984888.092725 | 2103630.7874996 | 37.7552952964732 | -122.49524762816 | (37.7552952964732, -122.49524762816) | 1 | 8 | 3 | 56 | 35 | |||
| 99835 | 20781 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1701X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | 5984888.092725 | 2103630.7874996 | 37.7552952964732 | -122.49524762816 | (37.7552952964732, -122.49524762816) | 1 | 8 | 3 | 56 | 35 | |||
| 157910 | 16689 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 620 Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 12 | 2 | 5992122.8128645 | 2103567.9103998 | 37.7555435761415 | -122.470223454796 | (37.7555435761415, -122.470223454796) | 1 | 8 | 4 | 56 | 12 | |||
| 28797 | 106211 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1646 35TH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | Permit Number 773238 | 5985355 | 2103995.9 | 37.7563251201532 | -122.493659849192 | (37.7563251201532, -122.493659849192) | 1 | 8 | 3 | 56 | 35 | ||||
| 123375 | 234485 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 3690 21st St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 3ft | 6003802.67178 | 2103657.18078 | 37.7564570287815 | -122.429837250793 | (37.7564570287815, -122.429837250793) | 2 | 4 | 5 | 28862 | 3 | |||
| 141912 | 234486 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 787 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 3ft | 6003746.3772 | 2103694.46852 | 37.756556224011 | -122.430034597112 | (37.756556224011, -122.430034597112) | 2 | 4 | 5 | 28862 | 3 | |||
| 4432 | 181365 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1600 Sunset Blvd | 92 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984912.4611 | 2104151.8757 | 37.7567274870678 | -122.495201781242 | (37.7567274870678, -122.495201781242) | 1 | 8 | 3 | 56 | 35 | |||
| 130527 | 234484 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 310 Liberty St | 42 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 6003878.87158 | 2103925.4289 | 37.7571978893843 | -122.42959285554 | (37.7571978893843, -122.42959285554) | 2 | 4 | 5 | 28862 | 3 | |||
| 192049 | 234489 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 4067 20th St | 2 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6003294.37691 | 2104155.43702 | 37.7577963243568 | -122.431630684215 | (37.7577963243568, -122.431630684215) | 2 | 4 | 5 | 28862 | 3 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );