trees
3,709 rows where qSpecies_id = 9 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 101769 | 100178 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1270 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2012 12:00:00 AM | 3x3 | 6003851 | 2100874 | 37.7488178049495 | -122.42947164058 | (37.7488178049495, -122.42947164058) | 2 | 4 | 5 | 28862 | 22 | |||
| 84934 | 100179 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1270 Sanchez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2012 12:00:00 AM | 3x3 | 6003851 | 2100874 | 37.7488178049495 | -122.42947164058 | (37.7488178049495, -122.42947164058) | 2 | 4 | 5 | 28862 | 22 | |||
| 110176 | 100457 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4400 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | Permit Number 32872 | 6001426 | 2104682 | 37.7591360587515 | -122.438130013791 | (37.7591360587515, -122.438130013791) | 2 | 4 | 5 | 28862 | 3 | |||
| 151002 | 100458 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4400 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | Permit Number 32872 | 6001426 | 2104682 | 37.7591360587515 | -122.438130013791 | (37.7591360587515, -122.438130013791) | 2 | 4 | 5 | 28862 | 3 | |||
| 159178 | 100459 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4400 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | Permit Number 32872 | 6001426 | 2104682 | 37.7591360587515 | -122.438130013791 | (37.7591360587515, -122.438130013791) | 2 | 4 | 5 | 28862 | 3 | |||
| 58281 | 101130 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1477 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2015 12:00:00 AM | 3x3 | Permit Number 769344 | 6000788.3 | 2110635.6 | 37.7754468763902 | -122.44076254186 | (37.7754468763902, -122.44076254186) | 15 | 5 | 11 | 29492 | 10 | ||
| 30769 | 101291 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1573 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769634 | 6005984.6308 | 2118253.95583 | 37.7966595553549 | -122.423328868831 | (37.7966595553549, -122.423328868831) | 13 | 9 | 10 | 28858 | 32 | |
| 112705 | 101294 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1573 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769634 | 6006047.51921 | 2118262.74897 | 37.7966872481687 | -122.423111885821 | (37.7966872481687, -122.423111885821) | 13 | 9 | 10 | 28858 | 32 | |
| 81546 | 101318 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 35 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6003166 | 2108111 | 37.7686500673346 | -122.432357170543 | (37.7686500673346, -122.432357170543) | 15 | 5 | 5 | 28862 | 3 | ||||
| 111792 | 101398 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 319 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992300 | 2096997 | 37.7375117835922 | -122.46913248278 | (37.7375117835922, -122.46913248278) | 1 | 8 | 4 | 59 | 40 | ||||
| 128065 | 101528 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 819 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769457 | 5981975.18641 | 2110162.57659 | 37.773058737345 | -122.505805367237 | (37.773058737345, -122.505805367237) | 11 | 6 | 2 | 55 | 26 | |
| 50555 | 101713 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3337 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769456 | 5998828.12282 | 2115578.65478 | 37.7889073930203 | -122.447899187116 | (37.7889073930203, -122.447899187116) | 13 | 6 | 1 | 54 | 31 | |
| 164356 | 102011 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 469 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6014033.25215 | 2112677.25893 | 37.7817981973592 | -122.395087809375 | (37.7817981973592, -122.395087809375) | 6 | 2 | 9 | 28856 | 6 | |||
| 126288 | 102054 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 249 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6003856.7 | 2092188.8 | 37.7249705438857 | -122.428832839677 | (37.7249705438857, -122.428832839677) | 9 | 7 | 6 | 28861 | 5 | ||||
| 117229 | 102248 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 125X Powhattan Ave | 1 | Front Yard : Yard | Tree | Private 2 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606 | 2098071 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | 2 | 7 | 7 | 28859 | 2 | |||
| 108303 | 102249 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 125X Powhattan Ave | 2 | Front Yard : Yard | Tree | Private 2 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606 | 2098071 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | 2 | 7 | 7 | 28859 | 2 | |||
| 101616 | 102250 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 125X Powhattan Ave | 3 | Front Yard : Yard | Tree | Private 2 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606 | 2098071 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | 2 | 7 | 7 | 28859 | 2 | |||
| 23181 | 102518 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 498X Harkness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010140.7 | 2089714.5 | 37.7185302998738 | -122.406935337509 | (37.7185302998738, -122.406935337509) | 10 | 7 | 8 | 309 | 39 | |||||
| 146502 | 102520 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 498X Harkness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010140.7 | 2089714.5 | 37.7185302998738 | -122.406935337509 | (37.7185302998738, -122.406935337509) | 10 | 7 | 8 | 309 | 39 | |||||
| 105921 | 102569 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 0 Diaz Ave | 1 | Front Yard : Yard | Tree | Private 2 | 02/04/2013 12:00:00 AM | 2 | Permit Number 769785 | 5990053.95839 | 2089992.81974 | 37.7181500356804 | -122.476386530439 | (37.7181500356804, -122.476386530439) | 1 | 8 | 4 | 64 | 14 | ||
| 64751 | 10267 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 229X Haight St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 4x5 | 6004928.57518 | 2109497.01592 | 37.7725555175436 | -122.4263592559 | (37.7725555175436, -122.4263592559) | 7 | 9 | 5 | 28852 | 10 | |||
| 11761 | 10268 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 215X Haight St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 6005053.18335 | 2109512.97249 | 37.7726063733294 | -122.425929359246 | (37.7726063733294, -122.425929359246) | 7 | 9 | 5 | 28852 | 10 | ||||
| 82858 | 102724 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 280 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003347 | 2100986 | 37.7490967821938 | -122.431222463771 | (37.7490967821938, -122.431222463771) | 2 | 4 | 5 | 28862 | 22 | |||
| 190658 | 102732 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1217 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6016939.1559 | 2092633.1782 | 37.7269225044661 | -122.383638730259 | (37.7269225044661, -122.383638730259) | 10 | 3 | 8 | 58 | 1 | |||
| 69588 | 10276 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 215X Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 6004948.05546 | 2109498.71961 | 37.7725612966014 | -122.426291992897 | (37.7725612966014, -122.426291992897) | 7 | 9 | 5 | 28852 | 10 | |||
| 92325 | 102764 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1X Mirabel Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 3x3 | 6007238.4 | 2099828.6 | 37.7461385790624 | -122.417683904568 | (37.7461385790624, -122.417683904568) | 2 | 7 | 7 | 28859 | 2 | ||
| 165363 | 10278 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 215X Haight St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/1996 12:00:00 AM | 6 | 6X6 | 6005000.61509 | 2109505.63565 | 37.7725832571536 | -122.426110676071 | (37.7725832571536, -122.426110676071) | 7 | 9 | 5 | 28852 | 10 | ||
| 158504 | 102913 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2848 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/2013 12:00:00 AM | 10 | 3x3 | Permit Number 770041 | 5999375.62951 | 2118076.93636 | 37.7957982935174 | -122.446184674607 | (37.7957982935174, -122.446184674607) | 13 | 9 | 1 | 57 | 17 | |
| 144176 | 103278 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 231 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 5x7 | 6004094.86012 | 2092180.35694 | 37.7249608380525 | -122.428008945256 | (37.7249608380525, -122.428008945256) | 9 | 7 | 6 | 28861 | 5 | |||
| 174102 | 103479 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 205 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 12443 | 5993034.68598 | 2114064.69041 | 37.7844176145752 | -122.467833359195 | (37.7844176145752, -122.467833359195) | 11 | 6 | 2 | 54 | 11 | ||
| 174187 | 103501 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2050 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768855 | 5999398.93831 | 2121201.05628 | 37.8043776199 | -122.446328874603 | (37.8043776199, -122.446328874603) | 13 | 9 | 1 | 57 | 17 | |
| 77897 | 103525 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 21X Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6006570.3 | 2109690.3 | 37.773178894024 | -122.420694075081 | (37.773178894024, -122.420694075081) | 8 | 2 | 9 | 28853 | 19 | |||
| 7099 | 103526 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 1X Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6006435.6 | 2109828.8 | 37.7735515891286 | -122.421169857317 | (37.7735515891286, -122.421169857317) | 8 | 2 | 9 | 28853 | 19 | |||
| 156359 | 103527 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 1X Brady St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6006435.6 | 2109828.8 | 37.7735515891286 | -122.421169857317 | (37.7735515891286, -122.421169857317) | 8 | 2 | 9 | 28853 | 19 | |||
| 181504 | 103528 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 1X Brady St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6006435.6 | 2109828.8 | 37.7735515891286 | -122.421169857317 | (37.7735515891286, -122.421169857317) | 8 | 2 | 9 | 28853 | 19 | |||
| 140784 | 103575 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 101X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | ||||
| 136925 | 103576 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 101X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | ||||
| 115230 | 103577 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 101X Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | ||||
| 25642 | 103578 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 101X Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | ||||
| 82365 | 103579 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 101X Laguna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | ||||
| 32165 | 103580 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 55X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||||
| 38591 | 103581 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 55X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||||
| 173460 | 103582 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 55X Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||||
| 43500 | 103583 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 55X Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||||
| 112119 | 103587 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 55X Laguna St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||||
| 6161 | 103626 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2729 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770186 | 5999911.184 | 2118103.33782 | 37.79590135493 | -122.444333461525 | (37.79590135493, -122.444333461525) | 13 | 9 | 1 | 57 | 17 | |
| 137370 | 10374 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1292 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2001 12:00:00 AM | 6 | 3X3 | 6000060.6155 | 2108870.7918 | 37.7705596914501 | -122.443152990472 | (37.7705596914501, -122.443152990472) | 15 | 5 | 11 | 29492 | 9 | ||
| 56491 | 10375 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1296 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2007 12:00:00 AM | 12 | 3X3 | 6000028.8313 | 2108866.5222 | 37.7705461558325 | -122.443262625265 | (37.7705461558325, -122.443262625265) | 15 | 5 | 11 | 29492 | 9 | ||
| 90976 | 103877 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 791 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 7x9 | 6002369.63002 | 2088931.52673 | 37.7159425175008 | -122.433740770734 | (37.7159425175008, -122.433740770734) | 9 | 7 | 6 | 28861 | 5 | |||
| 194435 | 103878 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 791 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2017 12:00:00 AM | 3 | 6x6 | Permit Number 776939 | 6002377.91546 | 2088944.75079 | 37.7159792979937 | -122.433713076995 | (37.7159792979937, -122.433713076995) | 9 | 7 | 6 | 28861 | 5 | |
| 183970 | 104071 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 590 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2013 12:00:00 AM | 1 | 3x3 | Permit Number 770130 | 5985063.18032 | 2111850.11147 | 37.7778734932803 | -122.495248237578 | (37.7778734932803, -122.495248237578) | 11 | 6 | 2 | 55 | 26 | |
| 74642 | 104315 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 501X 25th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2015 12:00:00 AM | 18 | 3x3 | Permit Number 771760 | 5988094.43467 | 2112469.19466 | 37.7797503287439 | -122.484807625673 | (37.7797503287439, -122.484807625673) | 11 | 6 | 2 | 55 | 26 | |
| 55741 | 104461 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1601X Kansas St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 4 | 3x6 | 6011834.44242 | 2100473.73914 | 37.748167551187 | -122.401836621487 | (37.748167551187, -122.401836621487) | 10 | 3 | 8 | 58 | 1 | |||
| 139801 | 105052 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 501X 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2016 12:00:00 AM | 3x3 | Permit Number 770390 | 5987510.95423 | 2112219.64233 | 37.7790311285688 | -122.48680778308 | (37.7790311285688, -122.48680778308) | 11 | 6 | 2 | 55 | 26 | ||
| 57650 | 105054 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 501X 27th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2016 12:00:00 AM | 3x3 | Permit Number 770390 | 5987510.95423 | 2112219.64233 | 37.7790311285688 | -122.48680778308 | (37.7790311285688, -122.48680778308) | 11 | 6 | 2 | 55 | 26 | ||
| 182805 | 105057 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500X 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2016 12:00:00 AM | 3x3 | Permit Number 770390 | 5987202.10059 | 2112208.93891 | 37.7789837289288 | -122.487875431883 | (37.7789837289288, -122.487875431883) | 11 | 6 | 2 | 55 | 26 | ||
| 179829 | 105058 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500X 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2016 12:00:00 AM | 3x3 | Permit Number 770390 | 5987202.10059 | 2112208.93891 | 37.7789837289288 | -122.487875431883 | (37.7789837289288, -122.487875431883) | 11 | 6 | 2 | 55 | 26 | ||
| 22330 | 105059 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500X 28th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2016 12:00:00 AM | 3x3 | Permit Number 770390 | 5987202.10059 | 2112208.93891 | 37.7789837289288 | -122.487875431883 | (37.7789837289288, -122.487875431883) | 11 | 6 | 2 | 55 | 26 | ||
| 149146 | 105234 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 250 STATES ST | 5 | Front Yard : Yard | Tree | Private 2 | 12 | 6000595.6 | 2106681.2 | 37.7645781078798 | -122.441145360444 | (37.7645781078798, -122.441145360444) | 15 | 5 | 5 | 28862 | 3 | ||||
| 136049 | 105994 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 131 GRIJALVA DR | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5989195.7 | 2089107.3 | 37.7156688070552 | -122.479288383095 | (37.7156688070552, -122.479288383095) | 1 | 8 | 4 | 64 | 14 | ||||
| 114525 | 10604 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 18 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/1992 12:00:00 AM | 6 | 3X3 | 6017010.86457 | 2095475.59177 | 37.7347311744022 | -122.383588632512 | (37.7347311744022, -122.383588632512) | 10 | 3 | 8 | 58 | 1 | ||
| 141430 | 106183 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1327 ULLOA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5x4 | 5991893.8 | 2098371.4 | 37.7412620575898 | -122.470636971077 | (37.7412620575898, -122.470636971077) | 1 | 8 | 4 | 59 | 40 | ||
| 89112 | 106184 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 1327 ULLOA ST | 1 | Front Yard : Cutout | Tree | Private 2 | FUF | 2 | 4x4 | 5991893.8 | 2098371.4 | 37.7412620575898 | -122.470636971077 | (37.7412620575898, -122.470636971077) | 1 | 8 | 4 | 59 | 40 | ||
| 27770 | 106546 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 644 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2014 12:00:00 AM | 2 | 3x3 | Permit Number 772940 | 5982289.02973 | 2111361.80008 | 37.7763699221041 | -122.504808639708 | (37.7763699221041, -122.504808639708) | 11 | 6 | 2 | 55 | 26 | |
| 36251 | 106713 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 90X BURROWS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011052 | 2093468 | 37.7288875881876 | -122.404049339755 | (37.7288875881876, -122.404049339755) | 10 | 3 | 7 | 309 | 28 | |||
| 28155 | 106768 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 226 Mallorca Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x9 | 6001629.46862 | 2120633.92047 | 37.8029475537601 | -122.438569291156 | (37.8029475537601, -122.438569291156) | 13 | 9 | 1 | 57 | 17 | ||||
| 61160 | 106800 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 443 Clementina St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6011195 | 2112052 | 37.7799231406809 | -122.404862852803 | (37.7799231406809, -122.404862852803) | 14 | 2 | 9 | 28853 | 34 | |||||
| 6968 | 106969 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 504 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 772815 | 6007433 | 2096444 | 37.7368561680545 | -122.416771259928 | (37.7368561680545, -122.416771259928) | 2 | 7 | 7 | 28859 | 2 | |
| 24774 | 107077 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 10 BRADY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x4 | 6006482 | 2109752 | 37.7733433304068 | -122.421003898549 | (37.7733433304068, -122.421003898549) | 8 | 2 | 9 | 28853 | 19 | |||
| 97449 | 107405 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 501x 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3xe | 5987478.43547 | 2112467.9042 | 37.7797108895019 | -122.486938513954 | (37.7797108895019, -122.486938513954) | 11 | 6 | 2 | 55 | 26 | |||
| 74108 | 107482 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1306x Montgomery St | 4 | Median : Cutout | Tree | DPW 1 | 5 | 6011457.97806 | 2119852.64786 | 37.8013565579188 | -122.404502345126 | (37.8013565579188, -122.404502345126) | 3 | 1 | 10 | 308 | 23 | ||||
| 76007 | 107485 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1306x Montgomery St | 7 | Median : Cutout | Tree | DPW 1 | 5 | 6011457.45538 | 2119866.47345 | 37.8013944904094 | -122.404505127604 | (37.8013944904094, -122.404505127604) | 3 | 1 | 10 | 308 | 23 | ||||
| 67638 | 107486 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1306x Montgomery St | 8 | Median : Cutout | Tree | DPW 1 | 9 | 6011455.57226 | 2119886.90358 | 37.8014504813279 | -122.404513083014 | (37.8014504813279, -122.404513083014) | 3 | 1 | 10 | 308 | 23 | ||||
| 29341 | 107488 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1306x Montgomery St | 13 | Median : Cutout | Tree | DPW 1 | 6 | 6011453.59321 | 2119920.31769 | 37.8015421177278 | -122.404522284896 | (37.8015421177278, -122.404522284896) | 3 | 1 | 10 | 308 | 23 | ||||
| 41387 | 107678 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 330 Seacliff Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2014 12:00:00 AM | 3 | Permit Number 773561 | 5986760.07251 | 2115557.06448 | 37.7881509278055 | -122.489650845774 | (37.7881509278055, -122.489650845774) | 11 | 6 | 1 | 55 | 33 | ||
| 163974 | 107679 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 330 Seacliff Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2014 12:00:00 AM | 3 | Permit Number 773561 | 5986760.07251 | 2115557.06448 | 37.7881509278055 | -122.489650845774 | (37.7881509278055, -122.489650845774) | 11 | 6 | 1 | 55 | 33 | ||
| 113672 | 107681 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 330 Seacliff Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2014 12:00:00 AM | 3 | Permit Number 773561 | 5986760.07251 | 2115557.06448 | 37.7881509278055 | -122.489650845774 | (37.7881509278055, -122.489650845774) | 11 | 6 | 1 | 55 | 33 | ||
| 59649 | 107682 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 330 Seacliff Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2014 12:00:00 AM | 3 | Permit Number 773561 | 5986760.07251 | 2115557.06448 | 37.7881509278055 | -122.489650845774 | (37.7881509278055, -122.489650845774) | 11 | 6 | 1 | 55 | 33 | ||
| 58830 | 107683 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 330 Seacliff Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2014 12:00:00 AM | 3 | Permit Number 773561 | 5986760.07251 | 2115557.06448 | 37.7881509278055 | -122.489650845774 | (37.7881509278055, -122.489650845774) | 11 | 6 | 1 | 55 | 33 | ||
| 14364 | 107684 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 330 Seacliff Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2014 12:00:00 AM | 3 | Permit Number 773561 | 5986760.07251 | 2115557.06448 | 37.7881509278055 | -122.489650845774 | (37.7881509278055, -122.489650845774) | 11 | 6 | 1 | 55 | 33 | ||
| 138012 | 107685 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 330 Seacliff Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2014 12:00:00 AM | 3 | Permit Number 773561 | 5986760.07251 | 2115557.06448 | 37.7881509278055 | -122.489650845774 | (37.7881509278055, -122.489650845774) | 11 | 6 | 1 | 55 | 33 | ||
| 175009 | 107686 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 330 Seacliff Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2014 12:00:00 AM | 3 | Permit Number 773561 | 5986760.07251 | 2115557.06448 | 37.7881509278055 | -122.489650845774 | (37.7881509278055, -122.489650845774) | 11 | 6 | 1 | 55 | 33 | ||
| 158292 | 107822 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 115 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5999349 | 2107687 | 37.7672686962884 | -122.445529329015 | (37.7672686962884, -122.445529329015) | 15 | 5 | 5 | 29492 | 9 | ||||
| 83884 | 108032 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 145X Capra Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/2014 12:00:00 AM | 3 | Permit Number 774212 | 6001036.40906 | 2120513.75887 | 37.8025838681199 | -122.440612955426 | (37.8025838681199, -122.440612955426) | 13 | 9 | 1 | 57 | 17 | ||
| 142780 | 108033 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 145X Capra Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/2014 12:00:00 AM | 3 | Permit Number 774212 | 6001051.57629 | 2120515.71183 | 37.8025900941096 | -122.440560609499 | (37.8025900941096, -122.440560609499) | 13 | 9 | 1 | 57 | 17 | ||
| 126506 | 108034 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 145X Capra Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/2014 12:00:00 AM | 3 | Permit Number 774212 | 6001070.0116 | 2120518.4067 | 37.8025985432527 | -122.440497007638 | (37.8025985432527, -122.440497007638) | 13 | 9 | 1 | 57 | 17 | ||
| 181421 | 108178 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 1229 ULLOA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5992303.3 | 2098384.3 | 37.7413211490276 | -122.469222016479 | (37.7413211490276, -122.469222016479) | 1 | 8 | 4 | 59 | 40 | |||
| 22852 | 108395 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 311 Ordway St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 2 | 3x3 | 6011028.37272 | 2090050.89786 | 37.7195036115824 | -122.403890660433 | (37.7195036115824, -122.403890660433) | 10 | 7 | 8 | 309 | 28 | ||
| 64636 | 108496 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1331 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773640 | 5992376.99621 | 2106387.92207 | 37.7633012798944 | -122.469549692534 | (37.7633012798944, -122.469549692534) | 1 | 8 | 11 | 56 | 12 |
| 107892 | 108548 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 231 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773712 | 6001628.81735 | 2093873.11553 | 37.7294689416254 | -122.436654875418 | (37.7294689416254, -122.436654875418) | 9 | 7 | 6 | 28861 | 25 |
| 183808 | 108623 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 399X CHATTANOOGA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x16 | 6004869 | 2101687 | 37.7511076995848 | -122.426009263621 | (37.7511076995848, -122.426009263621) | 2 | 4 | 5 | 28862 | 22 | |||
| 124557 | 108626 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 99 LYELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003201 | 2094452 | 37.7311476483304 | -122.431260994556 | (37.7311476483304, -122.431260994556) | 9 | 7 | 5 | 28861 | 25 | ||||
| 21727 | 108687 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1076 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2014 12:00:00 AM | 3 | Permit Number 773107 | 6012169.21632 | 2103384.10466 | 37.7561774592463 | -122.400883423742 | (37.7561774592463, -122.400883423742) | 10 | 3 | 8 | 28856 | 29 | |
| 27253 | 108790 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 964 Avalon Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774648 | 6005260.71538 | 2092108.77889 | 37.7248301904685 | -122.423973622591 | (37.7248301904685, -122.423973622591) | 9 | 7 | 6 | 309 | 5 | |
| 26300 | 108974 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 3059 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773634 | 6009172.8 | 2101543.2 | 37.7509551538616 | -122.411116061085 | (37.7509551538616, -122.411116061085) | 2 | 4 | 7 | 28859 | 19 |
| 103008 | 108987 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3560 Baker St | 4 | Front Yard : Yard | Tree | Private 2 | 3 | 5999200.33498 | 2121108.96976 | 37.8041134305519 | -122.447009524696 | (37.8041134305519, -122.447009524696) | 13 | 9 | 1 | 57 | 17 | ||||
| 110498 | 109291 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 286 Cumberland St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774872 | 6003752.6 | 2104537.4 | 37.7588710659743 | -122.4300732064 | (37.7588710659743, -122.4300732064) | 2 | 4 | 5 | 28862 | 3 | |
| 117075 | 109926 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 3899 19TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003728.4 | 2104732.7 | 37.7594059426014 | -122.43017083397 | (37.7594059426014, -122.43017083397) | 2 | 4 | 5 | 28862 | 3 | ||||
| 42155 | 109967 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1019 Hollister Ave | 1 | Front Yard : Yard | Tree | Private 2 | 03/13/2015 12:00:00 AM | 3 | 12x17 | 6014729.1 | 2089712.4 | 37.7187802209924 | -122.391074848752 | (37.7187802209924, -122.391074848752) | 10 | 3 | 8 | 58 | 1 | ||
| 16998 | 109968 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1019 Hollister Ave | 2 | Front Yard : Yard | Tree | Private 2 | 03/13/2015 12:00:00 AM | 3 | 12x17 | 6014729.1 | 2089712.4 | 37.7187802209924 | -122.391074848752 | (37.7187802209924, -122.391074848752) | 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) );