trees
3,709 rows where qSpecies_id = 9 sorted by qAddress descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 59968 | 47489 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 99X LYELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | 10 | 3x3 | Permit Number 45384 | 6003192 | 2094433 | 37.7310949685834 | -122.431290753374 | (37.7310949685834, -122.431290753374) | 9 | 7 | 5 | 28861 | 25 | |
| 96582 | 47488 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 99X LYELL ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | 3x3 | Permit Number 45384 | 6003192 | 2094433 | 37.7310949685834 | -122.431290753374 | (37.7310949685834, -122.431290753374) | 9 | 7 | 5 | 28861 | 25 | ||
| 150764 | 210672 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 992 Waithman Way | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 5996018.88182 | 2098492.62213 | 37.7418325783074 | -122.456382749179 | (37.7418325783074, -122.456382749179) | 1 | 8 | 4 | 59 | 40 | |||
| 104246 | 247408 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 990 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001866.3003 | 2109465.7283 | 37.7722960331347 | -122.436949719287 | (37.7722960331347, -122.436949719287) | 15 | 5 | 11 | 29492 | 9 | |||
| 179661 | 247409 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 990 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6001845.9485 | 2109464.3715 | 37.772291150933 | -122.43702002072 | (37.772291150933, -122.43702002072) | 15 | 5 | 11 | 29492 | 9 | |||
| 193158 | 178007 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 99 Trumbull St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004047.84176 | 2094334.75752 | 37.7308736817673 | -122.42832496073 | (37.7308736817673, -122.42832496073) | 9 | 7 | 6 | 28861 | 5 | |||
| 164150 | 177969 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 99 Rotteck St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6003395.37547 | 2094530.47467 | 37.7313741355927 | -122.430594602255 | (37.7313741355927, -122.430594602255) | 9 | 7 | 5 | 28861 | 25 | |||
| 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 | ||||
| 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 | ||
| 74360 | 177864 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 989 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001714.74238 | 2088380.40679 | 37.7143920818056 | -122.43596495334 | (37.7143920818056, -122.43596495334) | 9 | 7 | 6 | 28861 | 5 | |||
| 158288 | 177866 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 989 Naples St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001726.64511 | 2088400.0268 | 37.7144466301838 | -122.43592521588 | (37.7144466301838, -122.43592521588) | 9 | 7 | 6 | 28861 | 5 | |||
| 193284 | 177865 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 989 Naples St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001720.67634 | 2088389.37557 | 37.7144170451902 | -122.43594508462 | (37.7144170451902, -122.43594508462) | 9 | 7 | 6 | 28861 | 5 | |||
| 100362 | 51078 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 988 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2004 12:00:00 AM | Permit Number 47539 | 6001840.60215529 | 2109468.12960392 | 37.7723011658658 | -122.437038783281 | (37.7723011658658, -122.437038783281) | 15 | 5 | 11 | 29492 | 9 | |||
| 150238 | 51077 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 988 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2004 12:00:00 AM | Permit Number 47539 | 6001840.60215529 | 2109468.12960392 | 37.7723011658658 | -122.437038783281 | (37.7723011658658, -122.437038783281) | 15 | 5 | 11 | 29492 | 9 | |||
| 93857 | 233176 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 980 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | 10 | Width 3ft | Permit Number 14045 | 5999260.53687 | 2106690.21186 | 37.7645267156554 | -122.445763615616 | (37.7645267156554, -122.445763615616) | 15 | 5 | 5 | 29492 | 9 | |
| 75801 | 232436 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 98 Laussat St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6004291.45992 | 2109275.43151 | 37.7719110660771 | -122.428547305538 | (37.7719110660771, -122.428547305538) | 7 | 9 | 11 | 28852 | 10 | |||
| 30384 | 247406 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 978 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001915.1447 | 2109474.5474 | 37.7723230242624 | -122.436781393812 | (37.7723230242624, -122.436781393812) | 15 | 5 | 11 | 29492 | 9 | |||
| 78814 | 247407 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 978 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001900.8985 | 2109471.8338 | 37.7723147637335 | -122.436830478345 | (37.7723147637335, -122.436830478345) | 15 | 5 | 11 | 29492 | 9 | |||
| 31396 | 232989 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 977 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5998799.73328 | 2106531.10588 | 37.7640635297174 | -122.44734595117 | (37.7640635297174, -122.44734595117) | 15 | 5 | 11 | 29492 | 9 | |||
| 127140 | 232988 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 977 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5998796.78708 | 2106549.89977 | 37.7641149646647 | -122.447357493961 | (37.7641149646647, -122.447357493961) | 15 | 5 | 11 | 29492 | 9 | |||
| 133611 | 115523 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 977 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x5 | 5998789.42868854 | 2106581.63825895 | 37.7642016900986 | -122.447385228976 | (37.7642016900986, -122.447385228976) | 15 | 5 | 11 | 29492 | 9 | ||||
| 173735 | 56850 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 977 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | 3x5 | Permit Number 14084 | 5998789.42868854 | 2106581.63825895 | 37.7642016900986 | -122.447385228976 | (37.7642016900986, -122.447385228976) | 15 | 5 | 11 | 29492 | 9 | ||
| 53254 | 31901 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 973 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 6 | Permit Number 35326 | 6007886.26854 | 2110026.25074 | 37.7741754160005 | -122.416165751655 | (37.7741754160005, -122.416165751655) | 8 | 2 | 9 | 28853 | 34 | |
| 156441 | 233727 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 97 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6000601.20003 | 2104887.54159 | 37.7596534828344 | -122.440997304107 | (37.7596534828344, -122.440997304107) | 2 | 4 | 5 | 28862 | 3 | |||
| 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 | |
| 123733 | 178000 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 964 Avalon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6005277.15219 | 2092117.50935 | 37.7248550903643 | -122.423917422954 | (37.7248550903643, -122.423917422954) | 9 | 7 | 6 | 309 | 5 | |||
| 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 | |||
| 32507 | 194124 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 963 Minna St | 3 | Sidewalk: Curb side : Hanging Pot | Tree | Private 2 | 9 | Width 3ft | 6007973 | 2110046 | 37.7742345191157 | -122.415867130014 | (37.7742345191157, -122.415867130014) | 8 | 2 | 9 | 28853 | 34 | |||
| 59707 | 194126 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 963 Minna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007973 | 2110046 | 37.7742345191157 | -122.415867130014 | (37.7742345191157, -122.415867130014) | 8 | 2 | 9 | 28853 | 34 | |||
| 73227 | 194128 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 963 Minna St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007973 | 2110046 | 37.7742345191157 | -122.415867130014 | (37.7742345191157, -122.415867130014) | 8 | 2 | 9 | 28853 | 34 | |||
| 108853 | 194125 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 963 Minna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007973 | 2110046 | 37.7742345191157 | -122.415867130014 | (37.7742345191157, -122.415867130014) | 8 | 2 | 9 | 28853 | 34 | |||
| 136445 | 194127 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 963 Minna St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007973 | 2110046 | 37.7742345191157 | -122.415867130014 | (37.7742345191157, -122.415867130014) | 8 | 2 | 9 | 28853 | 34 | |||
| 174630 | 194122 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 963 Minna St | 1 | 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 | |||
| 88632 | 60705 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 963 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/1983 12:00:00 AM | 1 | 3x3 | Permit Number 20354 | 6009178.18020232 | 2103559.73737881 | 37.7564924147418 | -122.4112398899 | (37.7564924147418, -122.4112398899) | 2 | 4 | 7 | 28859 | 19 | |
| 168341 | 233029 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 963 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6009170.11197 | 2103561.96647 | 37.7564980828263 | -122.411267950278 | (37.7564980828263, -122.411267950278) | 2 | 4 | 7 | 28859 | 19 | |||
| 165754 | 1980 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 96 Bertha Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017818.3743209 | 2094812.8777717 | 37.7329560922326 | -122.380750713036 | (37.7329560922326, -122.380750713036) | 10 | 3 | 8 | 58 | 1 | ||
| 76712 | 132018 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 955 Green St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 6008453.78402 | 2118980.23859 | 37.798792791306 | -122.414836443949 | (37.798792791306, -122.414836443949) | 5 | 1 | 10 | 308 | 32 | ||||
| 87409 | 132017 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 955 Green St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6008451.79632 | 2118948.6521 | 37.7987059509698 | -122.414841085365 | (37.7987059509698, -122.414841085365) | 5 | 1 | 10 | 308 | 21 | |||
| 126844 | 132016 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 955 Green St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6008442.208 | 2118980.08343 | 37.7987917148299 | -122.414876489872 | (37.7987917148299, -122.414876489872) | 5 | 1 | 10 | 308 | 32 | ||||
| 93136 | 44455 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 95 Winding Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43779 | 6002576.22413505 | 2086867.96270094 | 37.710288143695 | -122.432879348949 | (37.710288143695, -122.432879348949) | 9 | 7 | 6 | 28861 | 5 | ||
| 38628 | 233765 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6003185.97234 | 2107800.97527 | 37.7677999475382 | -122.432265943725 | (37.7677999475382, -122.432265943725) | 15 | 5 | 5 | 28862 | 3 | |||
| 21611 | 210678 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Ravenwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5994279.56156 | 2095923.39934 | 37.7346781260787 | -122.462210416302 | (37.7346781260787, -122.462210416302) | 9 | 8 | 4 | 59 | 40 | |||
| 91030 | 210677 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Ravenwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5994252.28198 | 2095933.09384 | 37.7347031740156 | -122.462305433265 | (37.7347031740156, -122.462305433265) | 9 | 8 | 4 | 59 | 40 | |||
| 142945 | 210679 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Ravenwood Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5994311.07494 | 2095913.96689 | 37.7346540413551 | -122.46210078083 | (37.7346540413551, -122.46210078083) | 9 | 8 | 4 | 59 | 40 | |||
| 53735 | 210805 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993451.46095 | 2093589.86504 | 37.728223100899 | -122.464904003611 | (37.728223100899, -122.464904003611) | 9 | 8 | 4 | 59 | 40 | |||
| 76539 | 210804 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Pinehurst Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993437.69651 | 2093562.79994 | 37.7281479931339 | -122.464949622637 | (37.7281479931339, -122.464949622637) | 9 | 8 | 4 | 59 | 40 | |||
| 87254 | 42017 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 95 Pinehurst Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42344 | 5993454.75406454 | 2093611.71639617 | 37.728283289236 | -122.46489420554 | (37.728283289236, -122.46489420554) | 9 | 8 | 4 | 59 | 40 | ||
| 106656 | 42016 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 95 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42344 | 5993454.75406454 | 2093611.71639617 | 37.728283289236 | -122.46489420554 | (37.728283289236, -122.46489420554) | 9 | 8 | 4 | 59 | 40 | ||
| 125049 | 42018 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 95 Pinehurst Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42344 | 5993454.75406454 | 2093611.71639617 | 37.728283289236 | -122.46489420554 | (37.728283289236, -122.46489420554) | 9 | 8 | 4 | 59 | 40 | ||
| 9805 | 246529 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Laguna St | 2 | : | Tree | Private 2 | 10 | Width 4ft | 6005210.23202 | 2109136.89842 | 37.77158263905 | -122.425359343752 | (37.77158263905, -122.425359343752) | 7 | 9 | 5 | 28852 | 10 | |||
| 44605 | 246528 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Laguna St | 1 | : | Tree | Private 2 | 13 | Width 7ft | 6005204.62433 | 2109172.65839 | 37.7716805104709 | -122.425381286315 | (37.7716805104709, -122.425381286315) | 7 | 9 | 5 | 28852 | 10 | |||
| 91693 | 246530 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Laguna St | 3 | : | Tree | Private 2 | 13 | Width 7ft | 6005220.62037 | 2109069.23024 | 37.7713974254703 | -122.425318593679 | (37.7713974254703, -122.425318593679) | 7 | 9 | 5 | 28852 | 10 | |||
| 15702 | 66427 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/1991 12:00:00 AM | 8 | Permit Number 29569 | 6012980.71061 | 2090558.71757 | 37.7210068625643 | -122.397177686318 | (37.7210068625643, -122.397177686318) | 10 | 3 | 8 | 58 | 1 | ||
| 95479 | 232991 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 949 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5999199.10241 | 2106826.45802 | 37.7648973055976 | -122.445985900135 | (37.7648973055976, -122.445985900135) | 15 | 5 | 11 | 29492 | 9 | |||
| 9185 | 177862 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 941 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000858.94149 | 2091517.81461 | 37.7229580424721 | -122.439147663029 | (37.7229580424721, -122.439147663029) | 9 | 7 | 6 | 28861 | 25 | |||
| 163975 | 177861 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 941 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000851.1649 | 2091503.36041 | 37.7229179120133 | -122.439173509568 | (37.7229179120133, -122.439173509568) | 9 | 7 | 6 | 28861 | 25 | |||
| 108307 | 51436 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 940 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2004 12:00:00 AM | 3 | Permit Number 47756 | 5999532.4011 | 2111754.0971 | 37.7784463804052 | -122.445187410654 | (37.7784463804052, -122.445187410654) | 15 | 5 | 11 | 29490 | 16 | ||
| 35570 | 68419 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 94 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32262 | 5993499.28123568 | 2093584.8530568 | 37.728212096333 | -122.464738324511 | (37.728212096333, -122.464738324511) | 9 | 8 | 4 | 59 | 40 | ||
| 95150 | 210657 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 94 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5993485.31951 | 2093573.22652 | 37.7281793677659 | -122.46478574639 | (37.7281793677659, -122.46478574639) | 9 | 8 | 4 | 59 | 40 | |||
| 40141 | 34838 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 94 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/1997 12:00:00 AM | Permit Number 38463 | 6004273.91738669 | 2109284.40431145 | 37.7719347104397 | -122.428608626151 | (37.7719347104397, -122.428608626151) | 7 | 9 | 11 | 28852 | 10 | |||
| 86508 | 34839 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 94 Laussat St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/1997 12:00:00 AM | Permit Number 38463 | 6004273.91738669 | 2109284.40431145 | 37.7719347104397 | -122.428608626151 | (37.7719347104397, -122.428608626151) | 7 | 9 | 11 | 28852 | 10 | |||
| 142869 | 12642 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 934 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3PL | 5992520.61532 | 2114855.72668 | 37.7865598847705 | -122.469669457241 | (37.7865598847705, -122.469669457241) | 11 | 6 | 1 | 54 | 11 | |||
| 180524 | 12641 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 934 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3PL | 5992552.11638 | 2114856.32512 | 37.7865633485486 | -122.469560515868 | (37.7865633485486, -122.469560515868) | 11 | 6 | 1 | 54 | 11 | |||
| 176799 | 88075 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 931 Elizabeth St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2008 12:00:00 AM | Permit Number 51070 | 6000446 | 2101962 | 37.7516118173154 | -122.441324145572 | (37.7516118173154, -122.441324145572) | 2 | 4 | 5 | 28862 | 22 | ||||
| 187167 | 132022 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 928 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007892.79628 | 2120308.15692 | 37.8024073851468 | -122.416871780604 | (37.8024073851468, -122.416871780604) | 5 | 1 | 1 | 308 | 32 | |||
| 193795 | 132023 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 928 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007881.27524 | 2120306.58627 | 37.8024024244937 | -122.416911537842 | (37.8024024244937, -122.416911537842) | 5 | 1 | 1 | 308 | 32 | |||
| 112755 | 111035 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 927 Ashbury St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 774368 | 5999163.7 | 2106974.1 | 37.7653006717936 | -122.446118968287 | (37.7653006717936, -122.446118968287) | 15 | 5 | 11 | 29492 | 9 | ||||
| 122109 | 50498 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 924 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 6 | Permit Number 47135 | 6002542.62317 | 2088276.78564 | 37.7141545573574 | -122.433096072852 | (37.7141545573574, -122.433096072852) | 9 | 7 | 6 | 28861 | 5 | |
| 142230 | 247239 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 923 Buena Vista Ave West | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 1ft | 6000025.84088 | 2108639.91315 | 37.7699237738831 | -122.443256690652 | (37.7699237738831, -122.443256690652) | 15 | 5 | 11 | 29492 | 9 | |||
| 153267 | 69554 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 920 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/01/1998 12:00:00 AM | 5 | Permit Number 40588 | 6000963.4177 | 2111955.7965 | 37.7790817729887 | -122.440251465706 | (37.7790817729887, -122.440251465706) | 15 | 5 | 11 | 29490 | 41 | |
| 92918 | 38506 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 918 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1998 12:00:00 AM | 5 | Permit Number 40497 | 6008538.5126 | 2119358.21788 | 37.7998353888413 | -122.4145700162 | (37.7998353888413, -122.4145700162) | 5 | 1 | 10 | 308 | 32 | |
| 172785 | 233105 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 917 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6000407.86557 | 2102546.72234 | 37.7532151508723 | -122.441497973773 | (37.7532151508723, -122.441497973773) | 2 | 4 | 5 | 28862 | 22 | |||
| 62236 | 177863 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 916 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6000908.69865 | 2091687.2057 | 37.723425983093 | -122.438987796851 | (37.723425983093, -122.438987796851) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 21201 | 47307 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 905 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/2002 12:00:00 AM | Permit Number 45238 | 6009420.31304698 | 2103898.06138647 | 37.7574349528314 | -122.410426393727 | (37.7574349528314, -122.410426393727) | 2 | 4 | 7 | 28859 | 19 | ||
| 21129 | 132012 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 902 Vallejo St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6009174.97876 | 2118751.12637 | 37.7982042021283 | -122.412324664466 | (37.7982042021283, -122.412324664466) | 3 | 1 | 10 | 308 | 21 | |||
| 86112 | 88122 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 901 Castro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51124 | 6002493 | 2102968 | 37.7544904507874 | -122.434317282412 | (37.7544904507874, -122.434317282412) | 2 | 4 | 5 | 28862 | 22 | ||
| 121296 | 88121 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 901 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51124 | 6002493 | 2102968 | 37.7544904507874 | -122.434317282412 | (37.7544904507874, -122.434317282412) | 2 | 4 | 5 | 28862 | 22 | ||
| 140087 | 88120 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 901 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51124 | 6002493 | 2102968 | 37.7544904507874 | -122.434317282412 | (37.7544904507874, -122.434317282412) | 2 | 4 | 5 | 28862 | 22 | ||
| 76952 | 194195 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 9 Pomona St | 1 | : | Tree | Private 2 | 2 | Width 6ft | 6014203.67115 | 2094680.19203 | 37.7323916096872 | -122.393238495663 | (37.7323916096872, -122.393238495663) | 10 | 3 | 8 | 58 | 1 | |||
| 75764 | 177973 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 9 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004866.23981 | 2093407.58721 | 37.7283741528226 | -122.425429666248 | (37.7283741528226, -122.425429666248) | 9 | 7 | 6 | 28861 | 5 | |||
| 52471 | 233219 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 9 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007282.53208 | 2099823.35941 | 37.7461266729033 | -122.417530929716 | (37.7461266729033, -122.417530929716) | 2 | 7 | 7 | 28859 | 2 | |||
| 158017 | 233218 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 9 Mirabel Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007228.55769 | 2099799.12427 | 37.7460570914765 | -122.417715849229 | (37.7460570914765, -122.417715849229) | 2 | 7 | 7 | 28859 | 2 | |||
| 83326 | 194225 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 9 Jakey Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6016755.26705 | 2095536.04747 | 37.7348830429134 | -122.384476538576 | (37.7348830429134, -122.384476538576) | 10 | 3 | 8 | 58 | 1 | |||
| 39036 | 194228 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 9 Hawkins Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6016962.87933 | 2095412.73629 | 37.7345559334103 | -122.38375016066 | (37.7345559334103, -122.38375016066) | 10 | 3 | 8 | 58 | 1 | |||
| 114482 | 210768 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 8x Judah St | 1 | Median : Cutout | Tree | DPW 1 | 4 | Width 4ft | 5994536.81883 | 2106004.59746 | 37.7623733582716 | -122.46205183074 | (37.7623733582716, -122.46205183074) | 1 | 5 | 11 | 56 | 12 | |||
| 85047 | 92258 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 891 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52707 | 5981374.1327 | 2109674.4758 | 37.7716831604786 | -122.507848221548 | (37.7716831604786, -122.507848221548) | 11 | 6 | 2 | 55 | 26 | |
| 51183 | 57242 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 89 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/1975 12:00:00 AM | 24 | 5x5 | Permit Number 14530 | 6003195.89085899 | 2107782.79222796 | 37.7677505837132 | -122.432230338052 | (37.7677505837132, -122.432230338052) | 15 | 5 | 5 | 28862 | 3 | |
| 57004 | 233766 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 89 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6003184.93105 | 2107820.05191 | 37.7678522682995 | -122.432270907995 | (37.7678522682995, -122.432270907995) | 15 | 5 | 5 | 28862 | 3 | |||
| 88410 | 177968 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 89 Lyell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003146.74577 | 2094486.41557 | 37.731239070909 | -122.431451016762 | (37.731239070909, -122.431451016762) | 9 | 7 | 5 | 28861 | 25 | |||
| 88527 | 177967 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 89 Lyell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003150.9738 | 2094473.33946 | 37.7312034064987 | -122.431435466595 | (37.7312034064987, -122.431435466595) | 9 | 7 | 5 | 28861 | 25 | |||
| 7198 | 233017 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 89 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785451 | 6007345.5921 | 2098843.81852 | 37.7434406209891 | -122.417243474931 | (37.7434406209891, -122.417243474931) | 2 | 7 | 7 | 28859 | 2 | |
| 156797 | 233175 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 886 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5999204.22068 | 2107162.24762 | 37.7658195918379 | -122.445992350981 | (37.7658195918379, -122.445992350981) | 15 | 5 | 5 | 29492 | 9 | |||
| 190300 | 194161 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 882 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012411.15187 | 2103867.3361 | 37.7575177989154 | -122.400080658315 | (37.7575177989154, -122.400080658315) | 10 | 3 | 8 | 28856 | 29 | |||
| 71024 | 233030 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 881 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6009146.45262 | 2103976.05338 | 37.7576337449237 | -122.411379025546 | (37.7576337449237, -122.411379025546) | 2 | 4 | 7 | 28859 | 19 | |||
| 55919 | 178013 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 88 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6007561.5406 | 2093436.50677 | 37.7286054755646 | -122.416113907532 | (37.7286054755646, -122.416113907532) | 9 | 3 | 7 | 309 | 5 | |||
| 192490 | 210795 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 88 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992506.66983 | 2098544.35554 | 37.741772370506 | -122.468530483796 | (37.741772370506, -122.468530483796) | 1 | 8 | 4 | 29491 | 40 | |||
| 160574 | 232882 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 877 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6010202.29933 | 2104146.86733 | 37.7581619248595 | -122.407739504273 | (37.7581619248595, -122.407739504273) | 10 | 4 | 7 | 28859 | 19 | |||
| 52959 | 97989 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 876 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2011 12:00:00 AM | 3x3 | Permit Number 768167 | 6000897 | 2099683 | 37.7453799097395 | -122.439601171278 | (37.7453799097395, -122.439601171278) | 2 | 4 | 5 | 63 | 22 |
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) );