trees
3,709 rows where qSpecies_id = 9 sorted by qSpecies_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12 | 264792 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 99 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2020 12:00:00 AM | 3 | 3x3 | 6011432 | 2091645 | 37.7239032314516 | -122.402607501044 | (37.7239032314516, -122.402607501044) | 10 | 3 | 7 | 309 | 28 | ||
| 20 | 264793 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 99 Dwight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2020 12:00:00 AM | 3 | 3x3 | 6011432 | 2091645 | 37.7239032314516 | -122.402607501044 | (37.7239032314516, -122.402607501044) | 10 | 3 | 7 | 309 | 28 | ||
| 67 | 99921 | Section 806 (d) 5 | Olea europaea :: Olive Tree 9 | 1740 Jones St | 1 | Front Yard : Yard | Tree | Private 2 | 06/01/2015 12:00:00 AM | 3 | Permit Number 774389 | 6008331.64636 | 2118443.68708 | 37.7973126906849 | -122.415221079511 | (37.7973126906849, -122.415221079511) | 5 | 1 | 10 | 308 | 21 | ||
| 136 | 11131 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2400X Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007074.9072505 | 2120528.613771 | 37.802966665104 | -122.419717737051 | (37.802966665104, -122.419717737051) | 5 | 1 | 1 | 28858 | 32 | |||
| 178 | 233603 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 199 Franconia St | 9 | : Yard | Tree | Private 2 | 6 | Width 3ft | 6010152.72418 | 2099634.52308 | 37.7457692517475 | -122.407592814071 | (37.7457692517475, -122.407592814071) | 2 | 7 | 7 | 28859 | 2 | |||
| 191 | 244985 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1250 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6000147.9035 | 2108881.2284 | 37.7705933244615 | -122.442851810939 | (37.7705933244615, -122.442851810939) | 15 | 5 | 11 | 29492 | 9 | |||
| 196 | 116631 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 12 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
| 269 | 194187 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1100 19th St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6014241.14855 | 2105287.11165 | 37.7615180580268 | -122.393851124637 | (37.7615180580268, -122.393851124637) | 10 | 3 | 8 | 28856 | 29 | |||
| 274 | 232433 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Church St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6004078.25972 | 2108290.75217 | 37.7691953086514 | -122.429214555715 | (37.7691953086514, -122.429214555715) | 7 | 9 | 5 | 28862 | 3 | |||
| 291 | 210733 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 239 Ramsell St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992956.15258 | 2088805.34296 | 37.7150573966491 | -122.466268722147 | (37.7150573966491, -122.466268722147) | 9 | 8 | 6 | 64 | 24 | |||
| 304 | 132028 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 33x Battery St | 1 | Median : Yard | Tree | DPW 1 | 27 | 6012842.61776 | 2116100.99756 | 37.7911327033699 | -122.399447311639 | (37.7911327033699, -122.399447311639) | 4 | 1 | 10 | 28854 | 6 | ||||
| 324 | 97786 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 810 Battery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6012446.82878 | 2118928.41788 | 37.7988740576432 | -122.401015485586 | (37.7988740576432, -122.401015485586) | 3 | 1 | 10 | 28860 | 6 | |||
| 357 | 232461 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1300 San Jose Ave | 12 | Front Yard : Yard | Tree | Private 2 | 11 | 6003612.68018 | 2095726.39764 | 37.7346701778724 | -122.429928614715 | (37.7346701778724, -122.429928614715) | 2 | 7 | 5 | 63 | 7 | ||||
| 416 | 116621 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 2 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
| 580 | 65382 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1709 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/29/1989 12:00:00 AM | 9 | Permit Number 28221 | 6000542.2902 | 2114603.4223 | 37.7863274878262 | -122.441898393886 | (37.7863274878262, -122.441898393886) | 13 | 6 | 1 | 29490 | 27 | |
| 593 | 1419 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 41 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 5X5PL | 5995462.58605 | 2115703.10829 | 37.7890561644519 | -122.459552424818 | (37.7890561644519, -122.459552424818) | 11 | 6 | 1 | 54 | 11 | |||
| 642 | 260182 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 66x McCoppin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2019 12:00:00 AM | 3 | 3x3 | 6006141 | 2109130 | 37.7716162396968 | -122.422139269172 | (37.7716162396968, -122.422139269172) | 8 | 2 | 9 | 28853 | 19 | ||
| 765 | 9065 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5537 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5989786.9858 | 2112602.3503 | 37.7802143684845 | -122.478962158407 | (37.7802143684845, -122.478962158407) | 11 | 6 | 2 | 55 | 26 | |||
| 780 | 210671 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2043 Monterey Blvd | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5992088.794 | 2095394.24092 | 37.7330988041611 | -122.469746063247 | (37.7330988041611, -122.469746063247) | 9 | 8 | 4 | 59 | 40 | |||
| 941 | 233728 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 4570 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000770.37011 | 2104674.3409 | 37.7590777197736 | -122.440396940071 | (37.7590777197736, -122.440396940071) | 2 | 4 | 5 | 28862 | 3 | |||
| 975 | 4380 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2421X Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007006.0129161 | 2120659.6131485 | 37.8033224749672 | -122.419965449311 | (37.8033224749672, -122.419965449311) | 5 | 1 | 1 | 28858 | 32 | |||
| 998 | 233796 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 35 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6004294.34985 | 2098061.60809 | 37.74112071635 | -122.427738180998 | (37.74112071635, -122.427738180998) | 2 | 7 | 5 | 63 | 7 | |||
| 1005 | 39481 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 0 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40941 | |||||||||||||
| 1088 | 20259 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/16/2015 07:41:00 AM | 3 | 3X3 | 6009947.7744 | 2120592.07204 | 37.8033023200197 | -122.40978056566 | (37.8033023200197, -122.40978056566) | 3 | 1 | 10 | 308 | 23 | ||
| 1155 | 117421 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 29 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5996647.4398 | 2112726.9752 | 37.7809525538521 | -122.455237845507 | (37.7809525538521, -122.455237845507) | 11 | 6 | 2 | 54 | 16 | |||
| 1196 | 41203 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 18 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1999 12:00:00 AM | 9 | Permit Number 41910 | 5993961.82877 | 2115413.43591 | 37.7881743948276 | -122.464723766289 | (37.7881743948276, -122.464723766289) | 11 | 6 | 1 | 54 | 11 | ||
| 1220 | 75333 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 550 37th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5984432.92075 | 2112122.55763 | 37.7785846311766 | -122.497448611437 | (37.7785846311766, -122.497448611437) | 11 | 6 | 2 | 55 | 26 | |||
| 1262 | 47855 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1339 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/2002 12:00:00 AM | 3 | Permit Number 45614 | 5982734.7831 | 2106002.3859 | 37.7616807275351 | -122.502869846098 | (37.7616807275351, -122.502869846098) | 1 | 8 | 3 | 56 | 35 | |
| 1281 | 78213 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 718 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6011018.02822 | 2091413.5341 | 37.7232445529643 | -122.40402226092 | (37.7232445529643, -122.40402226092) | 10 | 3 | 7 | 309 | 28 | |||
| 1401 | 123788 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1300 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5994626 | 2112195 | 37.7793757071335 | -122.46219235943 | (37.7793757071335, -122.46219235943) | 11 | 6 | 2 | 54 | 11 | |||
| 1512 | 177963 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5988967.05933 | 2088996.09626 | 37.7153501871281 | -122.480070526755 | (37.7153501871281, -122.480070526755) | 1 | 8 | 4 | 64 | 14 | ||||
| 1571 | 56051 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 49 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/1973 12:00:00 AM | 36 | Permit Number 12140 | 6003182.54972715 | 2108023.57751638 | 37.7684109649411 | -122.43229368198 | (37.7684109649411, -122.43229368198) | 15 | 5 | 5 | 28862 | 3 | ||
| 1662 | 30844 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 238 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/16/1995 12:00:00 AM | 9 | Permit Number 34692 | 5999056.13874 | 2115758.23439 | 37.7894135017764 | -122.447123215185 | (37.7894135017764, -122.447123215185) | 13 | 6 | 1 | 29490 | 31 | |
| 1714 | 216680 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 430 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2017 07:33:00 AM | 3 | Width 3ft | 5995444.86919 | 2090582.23732 | 37.7200796093562 | -122.457795211804 | (37.7200796093562, -122.457795211804) | 9 | 8 | 6 | 28861 | 24 | ||
| 1727 | 249457 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 201 Olive St | 2 | : | Tree | Private 2 | 11 | Width 4ft | 6006319.82833 | 2113698.46294 | 37.7841702168319 | -122.421845255461 | (37.7841702168319, -122.421845255461) | 7 | 9 | 11 | 28858 | 41 | |||
| 1732 | 74552 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2345 Ortega St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5986706.7381 | 2102298.6623 | 37.7517439532499 | -122.488860374683 | (37.7517439532499, -122.488860374683) | 1 | 8 | 3 | 29491 | 35 | |||
| 1763 | 184039 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1600 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984935.4051 | 2103815.5297 | 37.755805317385 | -122.4950976324 | (37.755805317385, -122.4950976324) | 1 | 8 | 3 | 56 | 35 | |||
| 1842 | 11178 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2741 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6006856.2652 | 2121744.00393 | 37.8062914977061 | -122.420560679149 | (37.8062914977061, -122.420560679149) | 5 | 1 | 1 | 28858 | 32 | |||
| 1896 | 17856 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2121 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2000 12:00:00 AM | 10 | 3X3 | 6003596.6138 | 2115206.3541 | 37.7881565558045 | -122.431374278321 | (37.7881565558045, -122.431374278321) | 13 | 9 | 11 | 29490 | 27 | ||
| 1910 | 78533 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 240 Wayland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6010784.93141 | 2092430.64312 | 37.7260242971617 | -122.404899612537 | (37.7260242971617, -122.404899612537) | 10 | 3 | 7 | 309 | 28 | |||
| 1912 | 261449 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 306 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006931 | 2095728 | 37.7348619417662 | -122.418456144702 | (37.7348619417662, -122.418456144702) | 2 | 7 | 7 | 28859 | 2 | ||||
| 1958 | 244068 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 414 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5998440.5999 | 2109109.2833 | 37.7711220225463 | -122.448773795857 | (37.7711220225463, -122.448773795857) | 15 | 5 | 11 | 29492 | 9 | |||
| 2003 | 56319 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 255 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1973 12:00:00 AM | 11 | Permit Number 12454 | 5993047.12459 | 2113743.61417 | 37.7835367452404 | -122.467766966515 | (37.7835367452404, -122.467766966515) | 11 | 6 | 2 | 54 | 11 | ||
| 2011 | 264734 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1364 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006427.83864 | 2119405.514 | 37.7998464469137 | -122.42187710854 | (37.7998464469137, -122.42187710854) | 13 | 9 | 1 | 28858 | 32 | |||||
| 2096 | 3697 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 401X Cargo Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016390.48971 | 2099364.75407 | 37.7453757156112 | -122.3860045182 | (37.7453757156112, -122.3860045182) | 10 | 3 | 8 | 58 | 1 | |||
| 2218 | 210632 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1695 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5993073.70749 | 2104007.38642 | 37.7568051923228 | -122.46696694227 | (37.7568051923228, -122.46696694227) | 1 | 8 | 4 | 56 | 12 | |||
| 2288 | 50724 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3110 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/2004 12:00:00 AM | 2 | Permit Number 47275 | 6001439.94101 | 2119110.04202 | 37.798752603299 | -122.439115871123 | (37.798752603299, -122.439115871123) | 13 | 9 | 1 | 57 | 17 | |
| 2291 | 29222 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1902X 41st Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
| 2357 | 210723 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 221 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5994792.87709 | 2087738.88584 | 37.7122349616579 | -122.459843056229 | (37.7122349616579, -122.459843056229) | 9 | 8 | 6 | 28861 | 24 | |||
| 2359 | 35980 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 349 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39134 | 6006399.96537133 | 2097866.62265006 | 37.740704214618 | -122.420443871581 | (37.740704214618, -122.420443871581) | 2 | 7 | 7 | 28859 | 2 | ||
| 2530 | 69848 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 731 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6001876.24877 | 2089667.33696 | 37.7179348800801 | -122.43549873219 | (37.7179348800801, -122.43549873219) | 9 | 7 | 6 | 28861 | 5 | |||
| 2557 | 63304 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 359 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | 10 | Permit Number 23870 | 6006863.90683 | 2092790.57723 | 37.7267926428583 | -122.418479889853 | (37.7267926428583, -122.418479889853) | 9 | 3 | 7 | 309 | 5 | |
| 2601 | 71109 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1280 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6004811.8428 | 2113348.9801 | 37.7831254666613 | -122.427037449556 | (37.7831254666613, -122.427037449556) | 7 | 9 | 11 | 28858 | 41 | |||
| 2689 | 8750 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 3301 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5996889.89707 | 2112871.05246 | 37.7813620597582 | -122.454409481549 | (37.7813620597582, -122.454409481549) | 11 | 6 | 2 | 54 | 16 | |||
| 2693 | 72299 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 790 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011682.79959 | 2109646.37516 | 37.7733451034182 | -122.403006076485 | (37.7733451034182, -122.403006076485) | 14 | 2 | 9 | 28853 | 34 | |||
| 2707 | 19008 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3080X Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000062.56676 | 2115470.42095 | 37.7886806928938 | -122.443620414474 | (37.7886806928938, -122.443620414474) | 13 | 6 | 1 | 29490 | 27 | |||
| 2714 | 113322 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6004079.74050315 | 2108375.213269 | 37.7694273021614 | -122.42921545709 | (37.7694273021614, -122.42921545709) | 7 | 9 | 5 | 28862 | 3 | ||||
| 2720 | 194183 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1100 19th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6014273.14939 | 2105289.03804 | 37.7615251258084 | -122.393740580889 | (37.7615251258084, -122.393740580889) | 10 | 3 | 8 | 28856 | 29 | |||
| 2818 | 38377 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3815 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | 2 | Permit Number 40436 | 5982149.2806 | 2102814.4314 | 37.7528930799905 | -122.504658614747 | (37.7528930799905, -122.504658614747) | 1 | 8 | 3 | 56 | 35 | |
| 2873 | 73548 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1707 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000544.9075 | 2114594.6979 | 37.7863036820207 | -122.441888712315 | (37.7863036820207, -122.441888712315) | 13 | 6 | 1 | 29490 | 27 | |||
| 2927 | 35280 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
| 2947 | 35356 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 578 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 5 | Permit Number 38818 | 6011762.62224 | 2105687.97943 | 37.7624807004553 | -122.402451565313 | (37.7624807004553, -122.402451565313) | 8 | 3 | 8 | 28856 | 29 | |
| 2976 | 138679 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1719 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6000526.15 | 2114747.8117 | 37.7867230240237 | -122.441964602207 | (37.7867230240237, -122.441964602207) | 13 | 6 | 1 | 29490 | 27 | |||
| 2981 | 70375 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1590 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5983148.8552 | 2104320.0131 | 37.757085733924 | -122.501313312685 | (37.757085733924, -122.501313312685) | 1 | 8 | 3 | 56 | 35 | |||
| 3001 | 80365 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500 Campbell Ave | 1 | Front Yard : Yard | Tree | Private 2 | FUF | 1 | 6010298.58269 | 2088549.93008 | 37.7153414628213 | -122.406307590233 | (37.7153414628213, -122.406307590233) | 9 | 7 | 8 | 309 | 39 | |||
| 3058 | 11168 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2666 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3X3 | 6006944.2763295 | 2121452.6056321 | 37.8054963520093 | -122.420235406119 | (37.8054963520093, -122.420235406119) | 5 | 1 | 1 | 28858 | 32 | |||
| 3065 | 131818 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 245 Alhambra St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6001145.96871 | 2120047.09018 | 37.8013087580395 | -122.440200340178 | (37.8013087580395, -122.440200340178) | 13 | 9 | 1 | 57 | 17 | |||
| 3293 | 74706 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2345 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5986691.3356 | 2102298.6623 | 37.7517430543366 | -122.488913637871 | (37.7517430543366, -122.488913637871) | 1 | 8 | 3 | 29491 | 35 | |||
| 3298 | 210771 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 115 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5994196.30129 | 2105955.3306 | 37.7622184734172 | -122.463225970324 | (37.7622184734172, -122.463225970324) | 1 | 5 | 11 | 56 | 12 | |||
| 3338 | 83763 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 361 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | Permit Number 776681 | 5993691.54318 | 2113064.28499 | 37.7817086802882 | -122.465488178701 | (37.7817086802882, -122.465488178701) | 11 | 6 | 2 | 54 | 11 | ||
| 3400 | 71791 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 470 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6011261.07929 | 2119033.68709 | 37.7990968853742 | -122.405126006053 | (37.7990968853742, -122.405126006053) | 3 | 1 | 10 | 308 | 23 | |||
| 3566 | 246019 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 609 Clayton St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 16 | Width 0ft | 5998477.1179 | 2108551.0541 | 37.7695913556898 | -122.448607268219 | (37.7695913556898, -122.448607268219) | 15 | 5 | 11 | 29492 | 9 | |||
| 3574 | 218861 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 44 Hugo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5995517.64423 | 2107073.72636 | 37.7653653316693 | -122.458736946766 | (37.7653653316693, -122.458736946766) | 15 | 5 | 11 | 56 | 12 | |||
| 3596 | 264801 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 350 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011023 | 2089107 | 37.7169115603385 | -122.403842847789 | (37.7169115603385, -122.403842847789) | 10 | 7 | 8 | 309 | 39 | ||||
| 3619 | 55603 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 655 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1973 12:00:00 AM | 2 | Permit Number 11578 | 5982556.76294 | 2111288.67841 | 37.7761848980348 | -122.503877074189 | (37.7761848980348, -122.503877074189) | 11 | 6 | 2 | 55 | 26 | ||
| 3655 | 131989 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2445 Hyde St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006994.979 | 2120718.72375 | 37.803484156018 | -122.420007829916 | (37.803484156018, -122.420007829916) | 5 | 1 | 1 | 28858 | 32 | |||
| 3657 | 78310 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 542 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002972.7622 | 2090478.24127 | 37.7202236600817 | -122.431766435094 | (37.7202236600817, -122.431766435094) | 9 | 7 | 6 | 28861 | 5 | |||
| 3750 | 90460 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 786 25th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988216.47669 | 2110650.29112 | 37.7747632366882 | -122.484252000581 | (37.7747632366882, -122.484252000581) | 11 | 6 | 2 | 55 | 26 | |||
| 3784 | 233206 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 103 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007392.99224 | 2097693.10233 | 37.7402836768503 | -122.416998061628 | (37.7402836768503, -122.416998061628) | 2 | 7 | 7 | 28859 | 2 | |||
| 3791 | 84239 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 477 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988082.61952 | 2112758.69748 | 37.7805445336829 | -122.484869743283 | (37.7805445336829, -122.484869743283) | 11 | 6 | 2 | 55 | 26 | |||
| 3891 | 232910 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 229 Haight St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004811.55535 | 2109480.0616 | 37.7725023496476 | -122.426762832059 | (37.7725023496476, -122.426762832059) | 7 | 9 | 5 | 28852 | 10 | |||
| 3954 | 232446 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3742 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005626.63295 | 2100825.4971 | 37.7487850005374 | -122.423328051366 | (37.7487850005374, -122.423328051366) | 2 | 4 | 5 | 28859 | 19 | |||
| 3990 | 60261 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2495 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2015 12:00:00 AM | 12 | 3x3 | Permit Number 776014 | 6008888.61229415 | 2103948.71328851 | 37.7575442102667 | -122.412268813453 | (37.7575442102667, -122.412268813453) | 2 | 4 | 7 | 28859 | 19 | |
| 4025 | 73557 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 734 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 5982628.31308 | 2110748.29603 | 37.7747053725117 | -122.503589540533 | (37.7747053725117, -122.503589540533) | 11 | 6 | 2 | 55 | 26 | |||
| 4050 | 173690 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 690X 03RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2015 12:00:00 AM | 3x3 | 6014548 | 2111604 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | 6 | 2 | 9 | 28856 | 34 | |||
| 4113 | 194123 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 963 Minna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007973 | 2110046 | 37.7742345191157 | -122.415867130014 | (37.7742345191157, -122.415867130014) | 8 | 2 | 9 | 28853 | 34 | |||
| 4117 | 17881 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2205 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003346.6048 | 2115178.7939 | 37.7880667103656 | -122.432237297056 | (37.7880667103656, -122.432237297056) | 13 | 9 | 11 | 29490 | 27 | |||
| 4124 | 177990 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 287 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003882.75599 | 2091839.3373 | 37.7240124714806 | -122.428717866434 | (37.7240124714806, -122.428717866434) | 9 | 7 | 6 | 28861 | 5 | |||
| 4203 | 72834 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6015894.43243 | 2105382.09889 | 37.7618706120468 | -122.388139674229 | (37.7618706120468, -122.388139674229) | 10 | 3 | 8 | 28856 | 29 | |||
| 4236 | 233222 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 300x Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006874 | 2096520 | 37.7370333899893 | -122.418709361786 | (37.7370333899893, -122.418709361786) | 2 | 7 | 7 | 28859 | 2 | |||
| 4258 | 232897 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 188 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004783.23018 | 2109050.50758 | 37.7713212969648 | -122.426830214663 | (37.7713212969648, -122.426830214663) | 7 | 9 | 5 | 28852 | 10 | |||
| 4278 | 236503 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 4142 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008312.28371 | 2095873.575 | 37.7353393220422 | -122.413690843461 | (37.7353393220422, -122.413690843461) | 2 | 7 | 7 | 28859 | 2 | |||
| 4290 | 232871 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 301 Putnam St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 9ft | 6009080.37891 | 2095903.22512 | 37.7354638376772 | -122.411037337111 | (37.7354638376772, -122.411037337111) | 10 | 7 | 7 | 28859 | 2 | |||
| 4304 | 17630 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 150 Phelps St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10M | |||||||||||||
| 4405 | 78800 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 214 Curtis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6000803.49845 | 2087336.82758 | 37.7114748366708 | -122.439039819944 | (37.7114748366708, -122.439039819944) | 9 | 7 | 6 | 28861 | 5 | |||
| 4503 | 233620 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2880 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008954.95147 | 2103937.12232 | 37.7575161063958 | -122.412038565841 | (37.7575161063958, -122.412038565841) | 2 | 4 | 7 | 28859 | 19 | |||
| 4530 | 232895 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1621 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010456.86654 | 2100207.03244 | 37.7473582575881 | -122.406581465278 | (37.7473582575881, -122.406581465278) | 2 | 7 | 7 | 28859 | 2 | |||
| 4541 | 184962 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1990 41st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5983548.4855 | 2101665.8278 | 37.7498215412297 | -122.499735091789 | (37.7498215412297, -122.499735091789) | 1 | 8 | 3 | 29491 | 35 | |||
| 4553 | 74059 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6015912.53475 | 2105383.55959 | 37.7618756257676 | -122.388077166837 | (37.7618756257676, -122.388077166837) | 10 | 3 | 8 | 28856 | 29 | |||
| 4573 | 232883 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2800 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009514.50062 | 2105024.85439 | 37.7605341511365 | -122.410180205851 | (37.7605341511365, -122.410180205851) | 2 | 4 | 7 | 28859 | 19 |
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) );