trees
1,069 rows where qSpecies_id = 93 sorted by Fire Prevention Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2386 | 19745 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 STAIRWAY15 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
18752 | 51349 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 6401 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2004 12:00:00 AM | Permit Number 47697 | |||||||||||||
16461 | 183905 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101 22nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5989441.4873 | 2100495.8044 | 37.7469530039163 | -122.479271477973 | (37.7469530039163, -122.479271477973) | 1 | 8 | 3 | 29491 | 35 | |||
18292 | 214176 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2570 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991436.65565 | 2097934.35886 | 37.7400356087611 | -122.4721857495 | (37.7400356087611, -122.4721857495) | 1 | 8 | 4 | 29491 | 40 | |||
32589 | 183903 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101 22nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5989437.5475 | 2100612.4238 | 37.7472729813132 | -122.479293631278 | (37.7472729813132, -122.479293631278) | 1 | 8 | 3 | 29491 | 35 | |||
47324 | 214178 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 229 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 5994148.82976 | 2098782.7623 | 37.7425216973119 | -122.462869772235 | (37.7425216973119, -122.462869772235) | 1 | 8 | 4 | 59 | 40 | |||
47515 | 21149 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2292X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696 | (37.7442358239277, -122.49474388696) | 1 | 8 | 3 | 29491 | 35 | |||
59029 | 101259 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1830 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990081.34478 | 2106545.17551 | 37.763600113076 | -122.477501005027 | (37.763600113076, -122.477501005027) | 1 | 8 | 3 | 56 | 35 | ||||
71412 | 214177 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 225 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 5994177.64343 | 2098765.47338 | 37.7424758858443 | -122.462768889883 | (37.7424758858443, -122.462768889883) | 1 | 8 | 4 | 59 | 40 | |||
81254 | 214179 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 247 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 5994052.93286 | 2098838.27918 | 37.742668608777 | -122.46320538032 | (37.742668608777, -122.46320538032) | 1 | 8 | 4 | 59 | 40 | |||
81367 | 62611 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2262 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/07/1986 12:00:00 AM | Permit Number 22921 | 5989510.16412079 | 2099957.30856958 | 37.7454784240667 | -122.478994620655 | (37.7454784240667, -122.478994620655) | 1 | 8 | 3 | 29491 | 35 | ||
94767 | 179482 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5988878.80429 | 2090370.98469 | 37.7191201586413 | -122.48047615337 | (37.7191201586413, -122.48047615337) | 1 | 8 | 4 | 64 | 14 | ||||
95430 | 215007 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 226 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5994166.81469 | 2098811.63729 | 37.7426020166841 | -122.462809680445 | (37.7426020166841, -122.462809680445) | 1 | 8 | 4 | 59 | 40 | |||
100719 | 184134 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3240 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5984156.0453 | 2104307.189 | 37.757109619352 | -122.497829171247 | (37.757109619352, -122.497829171247) | 1 | 8 | 3 | 56 | 35 | |||
102044 | 179480 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5989599 | 2090767 | 37.7202493457345 | -122.478015677124 | (37.7202493457345, -122.478015677124) | 1 | 8 | 4 | 64 | 14 | ||||
106197 | 183901 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101 22nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5989435.1836 | 2100729.0432 | 37.7475930502179 | -122.479310335467 | (37.7475930502179, -122.479310335467) | 1 | 8 | 3 | 29491 | 35 | |||
108229 | 214175 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2574 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5991436.71189 | 2097914.45578 | 37.7399809632369 | -122.472184104624 | (37.7399809632369, -122.472184104624) | 1 | 8 | 4 | 29491 | 40 | |||
109955 | 95070 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2165 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989059 | 2106465 | 37.7633205959205 | -122.481031062121 | (37.7633205959205, -122.481031062121) | 1 | 8 | 3 | 56 | 35 | ||||
112112 | 66607 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1991 12:00:00 AM | 12 | Permit Number 29802 | 5989869.39246895 | 2090726.40504468 | 37.7201535727537 | -122.477078065149 | (37.7201535727537, -122.477078065149) | 1 | 8 | 4 | 64 | 14 | ||
112158 | 179483 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 5988918.91652 | 2090347.02209 | 37.7190566943955 | -122.480335749404 | (37.7190566943955, -122.480335749404) | 1 | 8 | 4 | 64 | 14 | ||||
117041 | 183904 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101 22nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5989435.9716 | 2100535.9908 | 37.7470630248592 | -122.479293489941 | (37.7470630248592, -122.479293489941) | 1 | 8 | 3 | 29491 | 35 | |||
120490 | 21150 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2292X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696 | (37.7442358239277, -122.49474388696) | 1 | 8 | 3 | 29491 | 35 | |||
125151 | 21148 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2292X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696 | (37.7442358239277, -122.49474388696) | 1 | 8 | 3 | 29491 | 35 | |||
127628 | 179481 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5988902.49405 | 2090393.59661 | 37.7191836220039 | -122.480395922129 | (37.7191836220039, -122.480395922129) | 1 | 8 | 4 | 64 | 14 | ||||
134533 | 68795 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2574 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32734 | 5991441.9162308 | 2097904.96501407 | 37.7399552051973 | -122.472165418715 | (37.7399552051973, -122.472165418715) | 1 | 8 | 4 | 29491 | 40 | ||
134763 | 215008 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 230 Granville Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5994122.16655 | 2098836.84765 | 37.7426686663343 | -122.462965888181 | (37.7426686663343, -122.462965888181) | 1 | 8 | 4 | 59 | 40 | |||
140571 | 114382 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 402X SERRANO DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5988379 | 2090615 | 37.7197611043299 | -122.482221632222 | (37.7197611043299, -122.482221632222) | 1 | 8 | 4 | 64 | 14 | ||||
141567 | 214173 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2252 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991053.76562 | 2100086.62004 | 37.7459229980593 | -122.473666574964 | (37.7459229980593, -122.473666574964) | 1 | 8 | 4 | 29491 | 40 | |||
154036 | 183898 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5989422.5761 | 2101010.3481 | 37.7483647071475 | -122.479374507677 | (37.7483647071475, -122.479374507677) | 1 | 8 | 3 | 29491 | 35 | |||
155923 | 214172 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1370 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5992428.9422 | 2106122.35536 | 37.76257510589 | -122.469350698796 | (37.76257510589, -122.469350698796) | 1 | 8 | 11 | 56 | 12 | |||
157428 | 183899 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5989428.0919 | 2100803.1123 | 37.7477960125827 | -122.479340275734 | (37.7477960125827, -122.479340275734) | 1 | 8 | 3 | 29491 | 35 | |||
162222 | 179478 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989807.06872 | 2090726.39006 | 37.720149915678 | -122.477293493993 | (37.720149915678, -122.477293493993) | 1 | 8 | 4 | 64 | 14 | ||||
163290 | 114214 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 230 SERRANO DR | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5988981 | 2090766 | 37.7202107101289 | -122.480151800691 | (37.7202107101289, -122.480151800691) | 1 | 8 | 4 | 64 | 14 | ||||
165340 | 215013 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 9 Locksley Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5994094.36202 | 2104778.03714 | 37.7589800579143 | -122.463493095026 | (37.7589800579143, -122.463493095026) | 1 | 5 | 4 | 56 | 12 | |||
168629 | 214171 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1337 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5994229.27069 | 2106420.50927 | 37.7634976322383 | -122.46314569683 | (37.7634976322383, -122.46314569683) | 1 | 5 | 11 | 56 | 12 | |||
169768 | 187383 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2200 Sunset Blvd | 69 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985095.2656 | 2100101.9401 | 37.7456181752007 | -122.494271077686 | (37.7456181752007, -122.494271077686) | 1 | 8 | 3 | 29491 | 35 | |||
169793 | 179479 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5989502.72531 | 2090743.34169 | 37.7201787974032 | -122.478346734135 | (37.7201787974032, -122.478346734135) | 1 | 8 | 4 | 64 | 14 | ||||
175362 | 214174 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2574 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991436.00676 | 2097903.57199 | 37.7399510383196 | -122.4721857495 | (37.7399510383196, -122.4721857495) | 1 | 8 | 4 | 29491 | 40 | |||
176933 | 179484 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5988536.49014 | 2090373.27915 | 37.7191065591004 | -122.481659555971 | (37.7191065591004, -122.481659555971) | 1 | 8 | 4 | 64 | 14 | ||||
350 | 119661 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699x Missouri St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
1613 | 112905 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1500 Bancroft Ave | 1 | Front Yard : Yard | Tree | DPW 1 | 25 | 6014696 | 2091834 | 37.7246038778524 | -122.391337493735 | (37.7246038778524, -122.391337493735) | 10 | 3 | 8 | 58 | 1 | ||||
3162 | 202093 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2403 Keith St | 4 | Sidewalk: Property side : Yard | Tree | DPW 1 | 25 | 6014456 | 2092405 | 37.7261584067484 | -122.392207065149 | (37.7261584067484, -122.392207065149) | 10 | 3 | 8 | 58 | 1 | ||||
3578 | 261993 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1557x Bancroft Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014548 | 2092008 | 37.7250734320456 | -122.391861276019 | (37.7250734320456, -122.391861276019) | 10 | 3 | 8 | 58 | 1 | ||||
6032 | 50628 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1198 Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2004 12:00:00 AM | Permit Number 47728 | 6014541.97081926 | 2090297.22948146 | 37.7203756614272 | -122.39176255443 | (37.7203756614272, -122.39176255443) | 10 | 3 | 8 | 58 | 1 | |||
6230 | 262036 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1557x Bancroft Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014548 | 2092008 | 37.7250734320456 | -122.391861276019 | (37.7250734320456, -122.391861276019) | 10 | 3 | 8 | 58 | 1 | ||||
7784 | 197575 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1121 Jamestown Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | 6013269.3073 | 2090137.6242 | 37.7198666867704 | -122.396150589498 | (37.7198666867704, -122.396150589498) | 10 | 3 | 8 | 58 | 1 | ||||
11444 | 261994 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1557x Bancroft Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014548 | 2092008 | 37.7250734320456 | -122.391861276019 | (37.7250734320456, -122.391861276019) | 10 | 3 | 8 | 58 | 1 | ||||
12244 | 261985 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1500x Bancroft Ave | Front Yard : Yard | Tree | Private 2 | 6014696 | 2091834 | 37.7246038778524 | -122.391337493735 | (37.7246038778524, -122.391337493735) | 10 | 3 | 8 | 58 | 1 | ||||||
13099 | 197577 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 299x Cashmere St | 5 | Median : Yard | Tree | DPW 1 | 33 | 6016820.77887 | 2095888.49241 | 37.735854408739 | -122.38427457691 | (37.735854408739, -122.38427457691) | 10 | 3 | 8 | 58 | 1 | ||||
15213 | 78534 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 240 Wayland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6010805.45879 | 2092437.25464 | 37.7260435984308 | -122.404829115572 | (37.7260435984308, -122.404829115572) | 10 | 3 | 7 | 309 | 28 | |||
17557 | 261982 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2403 Keith St | 3 | Sidewalk: Property side : Yard | Tree | DPW 1 | 6014456 | 2092405 | 37.7261584067484 | -122.392207065149 | (37.7261584067484, -122.392207065149) | 10 | 3 | 8 | 58 | 1 | |||||
17656 | 261984 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1557 Bancroft Ave | 4 | Sidewalk: Property side : Yard | Tree | DPW 1 | 6014517 | 2091967 | 37.7249591332222 | -122.391965574806 | (37.7249591332222, -122.391965574806) | 10 | 3 | 8 | 58 | 1 | |||||
18238 | 200676 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6015656.8366 | 2095323.7293 | 37.7342392575487 | -122.388259416585 | (37.7342392575487, -122.388259416585) | 10 | 3 | 8 | 58 | 1 | |||
32927 | 179473 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 890 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011506.9921 | 2090808.93918 | 37.7216117663527 | -122.402289508352 | (37.7216117663527, -122.402289508352) | 10 | 3 | 7 | 309 | 28 | |||
39890 | 197532 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 651 Missouri St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6013605.01625 | 2103874.96409 | 37.757605236407 | -122.395952299753 | (37.757605236407, -122.395952299753) | 10 | 3 | 8 | 28856 | 29 | ||||
39904 | 200682 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6015703.0041 | 2095289.1037 | 37.7341467406335 | -122.388097383825 | (37.7341467406335, -122.388097383825) | 10 | 3 | 8 | 58 | 1 | |||
40892 | 200680 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | 6015687.0653 | 2095298.4471 | 37.734171512631 | -122.388153141599 | (37.734171512631, -122.388153141599) | 10 | 3 | 8 | 58 | 1 | |||
43725 | 200673 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6015618.3638 | 2095361.6525 | 37.7343412551751 | -122.38839507653 | (37.7343412551751, -122.38839507653) | 10 | 3 | 8 | 58 | 1 | |||
44049 | 26131 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1500 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3x3 | 6015558.456 | 2095125.3192 | 37.7336890117673 | -122.388585707606 | (37.7336890117673, -122.388585707606) | 10 | 3 | 8 | 58 | 1 | |||
48484 | 108585 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 36 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6009820.40384 | 2094253.93436 | 37.7309767080873 | -122.408362486264 | (37.7309767080873, -122.408362486264) | 10 | 3 | 7 | 309 | 28 | |||
48571 | 197536 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 651 Missouri St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6013614.8063 | 2103893.08079 | 37.7576555255942 | -122.395919711032 | (37.7576555255942, -122.395919711032) | 10 | 3 | 8 | 28856 | 29 | ||||
52712 | 197535 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 651 Missouri St | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6013599.31223 | 2104067.77122 | 37.7581343255511 | -122.395985537795 | (37.7581343255511, -122.395985537795) | 10 | 3 | 8 | 28856 | 29 | |||
59121 | 119660 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699x Missouri St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
60432 | 112026 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101x 22nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||||
60920 | 98610 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1537 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 3x3 | 6015377.6336 | 2094141.2385 | 37.7309769017577 | -122.389142180051 | (37.7309769017577, -122.389142180051) | 10 | 3 | 8 | 58 | 1 | |||
62536 | 112022 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101x 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||||
70797 | 239676 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1356 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010842.92295 | 2102014.50671 | 37.7523427770036 | -122.405373771977 | (37.7523427770036, -122.405373771977) | 10 | 4 | 8 | 28859 | 19 | |||
73651 | 112027 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101x 22nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||||
84700 | 197537 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 266 Bridgeview Dr | 1 | : | Tree | Private 2 | 10 | Width 2ft | 6012934.68235 | 2095259.36475 | 37.7339113173389 | -122.397666323936 | (37.7339113173389, -122.397666323936) | 10 | 3 | 8 | 58 | 1 | |||
84712 | 16562 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 700X Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015552.29216 | 2097280.01448 | 37.7396050257983 | -122.388757385673 | (37.7396050257983, -122.388757385673) | 10 | 3 | 8 | 58 | 1 | |||
91855 | 197531 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2006 22nd St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6012046.11634 | 2103763.76948 | 37.7572130681337 | -122.401335827695 | (37.7572130681337, -122.401335827695) | 10 | 3 | 8 | 28856 | 29 | |||
106354 | 200678 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015671.6762 | 2095312.1874 | 37.7342083880601 | -122.388207305661 | (37.7342083880601, -122.388207305661) | 10 | 3 | 8 | 58 | 1 | |||
108079 | 200675 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6015661.7831 | 2095333.6223 | 37.7342666958117 | -122.388243005014 | (37.7342666958117, -122.388243005014) | 10 | 3 | 8 | 58 | 1 | |||
126956 | 94034 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1300X Lane St | 2 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 24 | 3x3 | 6015674.4242 | 2095246.7836 | 37.7340289546749 | -122.388193241926 | (37.7340289546749, -122.388193241926) | 10 | 3 | 8 | 58 | 1 | ||
129735 | 197534 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 651 Missouri St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6013594.2637 | 2104046.7535 | 37.7580763345811 | -122.396001525061 | (37.7580763345811, -122.396001525061) | 10 | 3 | 8 | 28856 | 29 | ||||
129965 | 112024 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101x 22nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||||
133863 | 200066 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1563 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6015094.0337 | 2094004.9347 | 37.7305869134552 | -122.390113122096 | (37.7305869134552, -122.390113122096) | 10 | 3 | 8 | 58 | 1 | |||
141666 | 26133 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1504 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 5x5 | 6015522.1816 | 2095153.8991 | 37.7337654760523 | -122.388713114387 | (37.7337654760523, -122.388713114387) | 10 | 3 | 8 | 58 | 1 | |||
142266 | 240529 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 185 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x6 | 6008658.35145 | 2097704.96683 | 37.7403873524888 | -122.412623778059 | (37.7403873524888, -122.412623778059) | 10 | 7 | 7 | 28859 | 2 | |||
143778 | 200679 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6015689.2638 | 2095313.8362 | 37.7342138898064 | -122.388146614226 | (37.7342138898064, -122.388146614226) | 10 | 3 | 8 | 58 | 1 | |||
143988 | 179489 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 36 Goettingen St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6009813.803 | 2094277.07127 | 37.7310398674871 | -122.408386937928 | (37.7310398674871, -122.408386937928) | 10 | 3 | 7 | 309 | 28 | |||
145312 | 98611 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1537 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6015388.0762 | 2094133.544 | 37.730956353088 | -122.389105540873 | (37.730956353088, -122.389105540873) | 10 | 3 | 8 | 58 | 1 | |||
149532 | 16559 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 702X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015638.3263 | 2097400.20162 | 37.7399398030878 | -122.388468300865 | (37.7399398030878, -122.388468300865) | 10 | 3 | 8 | 58 | 1 | |||
149818 | 22178 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3950X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6015635.4577 | 2097953.7776 | 37.7414596503706 | -122.38851684959 | (37.7414596503706, -122.38851684959) | 10 | 3 | 8 | 58 | 1 | |||
152092 | 50629 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1198 Gilman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2004 12:00:00 AM | Permit Number 47728 | 6014541.97081926 | 2090297.22948146 | 37.7203756614272 | -122.39176255443 | (37.7203756614272, -122.39176255443) | 10 | 3 | 8 | 58 | 1 | |||
152373 | 197576 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1121 Jamestown Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6013293.0543 | 2090118.55817 | 37.7198156565414 | -122.396067168381 | (37.7198156565414, -122.396067168381) | 10 | 3 | 8 | 58 | 1 | ||||
156854 | 197578 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 299x Cashmere St | 6 | Median : Yard | Tree | DPW 1 | 7 | 6016803.94707 | 2095896.67464 | 37.7358759448203 | -122.384333341329 | (37.7358759448203, -122.384333341329) | 10 | 3 | 8 | 58 | 1 | ||||
158494 | 108586 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 38 Goettingen St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009809 | 2094307 | 37.7311217764568 | -122.408405653048 | (37.7311217764568, -122.408405653048) | 10 | 3 | 7 | 309 | 28 | ||||
159854 | 119671 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699x Missouri St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
160392 | 122800 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1223 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6017230.3941 | 2093111.7012 | 37.7282525286375 | -122.382665199331 | (37.7282525286375, -122.382665199331) | 10 | 3 | 8 | 58 | 1 | |||
162517 | 104734 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 5490x 03RD ST | 1 | Median : Cutout | Tree | DPW 1 | 40 | 9x9 | 6014203 | 2093127 | 37.7281268221954 | -122.393132175736 | (37.7281268221954, -122.393132175736) | 10 | 3 | 8 | 58 | 1 | |||
163642 | 200677 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6015676.0731 | 2095323.7293 | 37.7342403234109 | -122.388192909274 | (37.7342403234109, -122.388192909274) | 10 | 3 | 8 | 58 | 1 | |||
169381 | 197533 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 651 Missouri St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6013601.75095 | 2103896.53741 | 37.7576642903943 | -122.395965104316 | (37.7576642903943, -122.395965104316) | 10 | 3 | 8 | 28856 | 29 | ||||
169480 | 200672 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6015595.8297 | 2095380.8889 | 37.7343928257308 | -122.388474327143 | (37.7343928257308, -122.388474327143) | 10 | 3 | 8 | 58 | 1 | |||
171923 | 49833 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 418@ 19th ST Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 12 | Permit Number 46616 | 6014316.07851 | 2105148.78787 | 37.7611424148166 | -122.393582289386 | (37.7611424148166, -122.393582289386) | 10 | 3 | 8 | 28856 | 29 | |
172859 | 200674 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1535 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | 6015639.7987 | 2095348.4618 | 37.7343062239298 | -122.388320048161 | (37.7343062239298, -122.388320048161) | 10 | 3 | 8 | 58 | 1 | |||
175962 | 119669 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699x Missouri St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
177148 | 22364 | Landmark tree 11 | Schinus terebinthifolius :: Brazilian Pepper 93 | 5490X 03rd St | 1 | Median : Cutout | Tree | DPW 1 | 48 | 40TR | 6014151.6099 | 2093070.9929 | 37.7279701830365 | -122.393305916851 | (37.7279701830365, -122.393305916851) | 10 | 3 | 8 | 58 | 1 | |||
177149 | 47230 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 890 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 6 | Permit Number 46770 | 6011503.10296 | 2090822.57098 | 37.7216489793918 | -122.40230391012 | (37.7216489793918, -122.40230391012) | 10 | 3 | 7 | 309 | 28 | |
189391 | 22196 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4049 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6015606.879 | 2097560.5249 | 37.7403782752921 | -122.38858822178 | (37.7403782752921, -122.38858822178) | 10 | 3 | 8 | 58 | 1 |
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) );