trees
3,709 rows where qSpecies_id = 9 sorted by qCareAssistant 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
116839 | 99309 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1902X 41st Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 6 | 3X3 | 5983703.9 | 2101544.3 | 37.7494969779561 | -122.499188691375 | (37.7494969779561, -122.499188691375) | 1 | 8 | 3 | 29491 | 35 | ||
15423 | 85309 | - 12 | Olea europaea :: Olive Tree 9 | 1250 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/26/2007 12:00:00 AM | 3 | 3x3 | Under 3 yr maintenance agreement. Ends 7/27/2010. | 6000155.2862 | 2108898.36192 | 37.7706407896873 | -122.442827504693 | (37.7706407896873, -122.442827504693) | 15 | 5 | 11 | 29492 | 9 |
188548 | 85310 | - 12 | Olea europaea :: Olive Tree 9 | 1250 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/27/2007 12:00:00 AM | 3 | 3x3 | Under 3 yr maintenance agreement. Ends 7/27/2010. | 6000155.2862 | 2108898.36192 | 37.7706407896873 | -122.442827504693 | (37.7706407896873, -122.442827504693) | 15 | 5 | 11 | 29492 | 9 |
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 | |
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 | |||
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 | |
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 | |||
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 | |||
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 | |
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
4833 | 75711 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1360 43rd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5982781.2778 | 2105936.6274 | 37.7615029058487 | -122.502704174703 | (37.7615029058487, -122.502704174703) | 1 | 8 | 3 | 56 | 35 | |||
5112 | 71219 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2287 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988225.9763 | 2099753.3826 | 37.7448438391255 | -122.483420138524 | (37.7448438391255, -122.483420138524) | 1 | 8 | 3 | 29491 | 35 | |||
5198 | 75651 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 594 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5990000.19108 | 2111343.54291 | 37.7767704107746 | -122.47813253045 | (37.7767704107746, -122.47813253045) | 11 | 6 | 2 | 55 | 26 | |||
5421 | 78924 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2355 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988240.3654 | 2099300.0902 | 37.7436000553334 | -122.483337162026 | (37.7436000553334, -122.483337162026) | 1 | 8 | 3 | 29491 | 35 | |||
6162 | 46753 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 378 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44855 | 5993270.29922187 | 2089695.37971007 | 37.7175193444423 | -122.465247516931 | (37.7175193444423, -122.465247516931) | 9 | 8 | 6 | 64 | 24 | ||
6307 | 83045 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6018793.96585 | 2097631.53768 | 37.7407493718785 | -122.377573338964 | (37.7407493718785, -122.377573338964) | 10 | 3 | 8 | 58 | 1 | |||
6676 | 70370 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1462 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5983119.2114 | 2105188.9573 | 37.7594698688276 | -122.501480109549 | (37.7594698688276, -122.501480109549) | 1 | 8 | 3 | 56 | 35 | |||
6841 | 45453 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 191 Corona St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/2001 12:00:00 AM | Permit Number 44237 | 5993006.32104665 | 2092505.10355506 | 37.7252189362985 | -122.466364051503 | (37.7252189362985, -122.466364051503) | 9 | 8 | 4 | 59 | 40 | ||
7046 | 69901 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 607 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6002511.32191 | 2089559.78285 | 37.7176756091205 | -122.433295884208 | (37.7176756091205, -122.433295884208) | 9 | 7 | 6 | 28861 | 5 | |||
7048 | 70747 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 775 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988472.81051 | 2110739.80778 | 37.7750239462768 | -122.483371863607 | (37.7750239462768, -122.483371863607) | 11 | 6 | 2 | 55 | 26 | |||
7416 | 52562 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1267 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2006 12:00:00 AM | 3 | Permit Number 48659 | 5983648.1273 | 2106539.2749 | 37.7632085093228 | -122.49975069135 | (37.7632085093228, -122.49975069135) | 1 | 8 | 3 | 56 | 35 | |
7701 | 97237 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 125 Excelsior Ave | Sidewalk: Property side : Yard | Tree | SFUSD 4 | FUF | 09/07/2011 12:00:00 AM | Permit Number 767513 | 6002911 | 2092621.3 | 37.7261045201699 | -122.432132888294 | (37.7261045201699, -122.432132888294) | 9 | 7 | 6 | 28861 | 5 | |||
7716 | 47426 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 573 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 3 | Permit Number 45337 | 5983462.70057 | 2111933.41652 | 37.7780083900123 | -122.50079093001 | (37.7780083900123, -122.50079093001) | 11 | 6 | 2 | 55 | 26 | |
8079 | 42144 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 471 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 10 | Permit Number 42439 | 5990590.8617 | 2112190.82997 | 37.7791310957428 | -122.476151146082 | (37.7791310957428, -122.476151146082) | 11 | 6 | 2 | 55 | 26 | |
9131 | 75410 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 550 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5984433.26554 | 2112138.70931 | 37.7786289992279 | -122.497448611431 | (37.7786289992279, -122.497448611431) | 11 | 6 | 2 | 55 | 26 | |||
9251 | 64294 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 369 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | 11 | Permit Number 25100 | 6004186.81103281 | 2098943.74928531 | 37.7435367899994 | -122.428172863442 | (37.7435367899994, -122.428172863442) | 2 | 7 | 5 | 63 | 22 | |
9669 | 71248 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1853 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6009517.1243 | 2120069.0751 | 37.8018421572412 | -122.411233884286 | (37.8018421572412, -122.411233884286) | 3 | 1 | 10 | 308 | 23 | |||
9713 | 71215 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2143 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5988194.3764 | 2100717.2109 | 37.7474884169564 | -122.483600053104 | (37.7474884169564, -122.483600053104) | 1 | 8 | 3 | 29491 | 35 | |||
9743 | 34866 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 579 Miramar Ave | 1 | Median : Cutout | Tree | Private 2 | FUF | 12/29/2015 12:00:00 AM | Permit Number 775311 | 5995338.59696042 | 2093168.95782094 | 37.7271760192259 | -122.458349689476 | (37.7271760192259, -122.458349689476) | 9 | 7 | 4 | 28861 | 40 | ||
10318 | 78551 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2255 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5982019.5732 | 2099750.385 | 37.7444724345971 | -122.504880128796 | (37.7444724345971, -122.504880128796) | 1 | 8 | 3 | 29491 | 35 | |||
11049 | 74796 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2338 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5983322.3378 | 2099244.9576 | 37.7431612263111 | -122.500338147126 | (37.7431612263111, -122.500338147126) | 1 | 8 | 3 | 29491 | 35 | |||
11455 | 71633 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 666 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5983841.90754 | 2111286.39703 | 37.7762541180901 | -122.499431311865 | (37.7762541180901, -122.499431311865) | 11 | 6 | 2 | 55 | 26 | |||
11500 | 80930 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 214 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6000799.22346 | 2087352.62937 | 37.7115179816306 | -122.439055727159 | (37.7115179816306, -122.439055727159) | 9 | 7 | 6 | 28861 | 5 | |||
11523 | 80597 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 443 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6014099.89803 | 2105040.34202 | 37.7608326316413 | -122.394322377476 | (37.7608326316413, -122.394322377476) | 10 | 3 | 8 | 28856 | 29 | |||
11711 | 38775 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 660 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1998 12:00:00 AM | 8 | Permit Number 40638 | 6014484.21875 | 2111755.81993 | 37.7792932023544 | -122.393463157999 | (37.7792932023544, -122.393463157999) | 6 | 2 | 9 | 28856 | 34 | |
11782 | 75252 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 550 37th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5984435.27406 | 2112051.02131 | 37.7783883510577 | -122.497435187925 | (37.7783883510577, -122.497435187925) | 11 | 6 | 2 | 55 | 26 | |||
11999 | 78469 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 620 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6007750.85494 | 2094230.07543 | 37.730795086422 | -122.415515595769 | (37.730795086422, -122.415515595769) | 9 | 3 | 7 | 309 | 28 | |||
12031 | 262472 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 210 Drake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5x5 | 6001697 | 2086437 | 37.7090549070704 | -122.435887307636 | (37.7090549070704, -122.435887307636) | 9 | 7 | 6 | 28861 | 5 | |||
12171 | 84266 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 705 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988141.50064 | 2111140.28908 | 37.7761042683076 | -122.484547303766 | (37.7761042683076, -122.484547303766) | 11 | 6 | 2 | 55 | 26 | |||
12429 | 71684 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 163 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994555.12862 | 2086427.38157 | 37.7086202032335 | -122.460569802865 | (37.7086202032335, -122.460569802865) | 9 | 8 | 6 | 28861 | 25 | |||
12517 | 83658 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 735 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6001863.16562 | 2089646.83142 | 37.717877833364 | -122.435542488698 | (37.717877833364, -122.435542488698) | 9 | 7 | 6 | 28861 | 5 | |||
12888 | 260885 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 639 32nd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985963.68769 | 2111543.65127 | 37.7770847226637 | -122.49211054124 | (37.7770847226637, -122.49211054124) | 11 | 6 | 2 | 55 | 26 | |||
13589 | 74272 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6015960.78285 | 2105386.23771 | 37.7618856523157 | -122.387910481099 | (37.7618856523157, -122.387910481099) | 10 | 3 | 8 | 28856 | 29 | |||
13702 | 83044 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6018777.54715 | 2097643.31156 | 37.7407807960029 | -122.377630926146 | (37.7407807960029, -122.377630926146) | 10 | 3 | 8 | 58 | 1 | |||
13779 | 48583 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1172 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | 6 | Permit Number 45898 | 6008021.61269 | 2118241.60717 | 37.7967404007911 | -122.416279558156 | (37.7967404007911, -122.416279558156) | 5 | 1 | 10 | 28858 | 21 | |
13867 | 38714 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 815 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1998 12:00:00 AM | 6 | Permit Number 40617 | 6002461.8782 | 2111447.7725 | 37.7777720662768 | -122.435031345285 | (37.7777720662768, -122.435031345285) | 15 | 5 | 11 | 29492 | 41 | |
13889 | 75170 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 550 37th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5984437.14625 | 2112031.30929 | 37.7783343372815 | -122.497427255785 | (37.7783343372815, -122.497427255785) | 11 | 6 | 2 | 55 | 26 | |||
13935 | 61515 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 84 De Long St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1984 12:00:00 AM | 11 | 3x3 | Permit Number 21471 | 5994704.395 | 2086819.71376 | 37.7097060419596 | -122.460082326249 | (37.7097060419596, -122.460082326249) | 9 | 8 | 6 | 28861 | 25 |
14327 | 70383 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1465 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5982453.54 | 2105161.4635 | 37.759355260686 | -122.503780254641 | (37.759355260686, -122.503780254641) | 1 | 8 | 3 | 56 | 35 | |||
14671 | 74991 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2345 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5986666.6916 | 2102296.6086 | 37.7517359771217 | -122.488998708008 | (37.7517359771217, -122.488998708008) | 1 | 8 | 3 | 29491 | 35 | |||
14962 | 41296 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 65 McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/19/2000 12:00:00 AM | Permit Number 41973 | 6006281.33179879 | 2109112.42754659 | 37.7715759040746 | -122.421652604165 | (37.7715759040746, -122.421652604165) | 8 | 2 | 9 | 28853 | 19 | ||
15274 | 74231 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2054 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6009468.6226 | 2120763.8774 | 37.8037471914209 | -122.411450838489 | (37.8037471914209, -122.411450838489) | 3 | 1 | 10 | 308 | 23 | |||
15372 | 38680 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1619 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/02/1998 12:00:00 AM | 6 | Permit Number 40597 | 5999956.5013 | 2110885.8742 | 37.7760866601423 | -122.44365790473 | (37.7760866601423, -122.44365790473) | 15 | 5 | 11 | 29492 | 16 | |
15933 | 75880 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1360 43rd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5982784.1317 | 2105860.9992 | 37.7612954200169 | -122.502688706201 | (37.7612954200169, -122.502688706201) | 1 | 8 | 3 | 56 | 35 | |||
16334 | 70226 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1466 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5982190.0408 | 2105127.5478 | 37.759246640966 | -122.504689034952 | (37.759246640966, -122.504689034952) | 1 | 8 | 3 | 56 | 35 | |||
16427 | 262473 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 210 Drake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5x5 | 6001697 | 2086437 | 37.7090549070704 | -122.435887307636 | (37.7090549070704, -122.435887307636) | 9 | 7 | 6 | 28861 | 5 | |||
16480 | 50938 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4752 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | Permit Number 48543 | 5998450.03825367 | 2105698.06494287 | 37.7617562199837 | -122.448495440986 | (37.7617562199837, -122.448495440986) | 15 | 5 | 11 | 29492 | 9 | ||
16568 | 61791 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1243 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/1985 12:00:00 AM | 13 | Permit Number 21814 | 6011992.65884 | 2102590.77396 | 37.7539892971928 | -122.40143827126 | (37.7539892971928, -122.40143827126) | 10 | 3 | 8 | 28856 | 29 | |
17332 | 38426 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 126 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/1999 12:00:00 AM | Permit Number 41732 | 6001233.109597 | 2094965.61225629 | 37.7324461904854 | -122.438101100943 | (37.7324461904854, -122.438101100943) | 9 | 7 | 5 | 63 | 40 | ||
17416 | 30836 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 115 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1995 12:00:00 AM | 2 | Permit Number 34685 | 6005037.93149 | 2099286.88921 | 37.7445270937564 | -122.425254310132 | (37.7445270937564, -122.425254310132) | 2 | 7 | 5 | 63 | 22 | |
17500 | 37109 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1301X 46th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39705 | 5981799.7427 | 2106129.159 | 37.7619738119048 | -122.506113117253 | (37.7619738119048, -122.506113117253) | 1 | 8 | 3 | 56 | 35 |
17660 | 70991 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1280 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6004787.3366 | 2113342.9897 | 37.7831076327374 | -122.427121804289 | (37.7831076327374, -122.427121804289) | 7 | 9 | 11 | 28858 | 41 | |||
17696 | 39128 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 755 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40809 | 6007359.12700155 | 2102919.00118427 | 37.7546309134503 | -122.417485428329 | (37.7546309134503, -122.417485428329) | 2 | 4 | 7 | 28859 | 19 | ||
17711 | 42162 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1407 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 8 | Permit Number 42457 | 5991237.30182 | 2110614.79116 | 37.7748411888545 | -122.473799860621 | (37.7748411888545, -122.473799860621) | 11 | 6 | 2 | 54 | 26 | |
17798 | 84258 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 863 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988178.23714 | 2110103.90338 | 37.7732607816923 | -122.484344195576 | (37.7732607816923, -122.484344195576) | 11 | 6 | 2 | 55 | 26 | |||
17950 | 79191 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1750 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6011751.02985 | 2092731.77406 | 37.7269050958844 | -122.401581006276 | (37.7269050958844, -122.401581006276) | 10 | 3 | 8 | 58 | 1 | |||
18046 | 71265 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1707 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000547.9611 | 2114579.8664 | 37.7862631325586 | -122.441877082784 | (37.7862631325586, -122.441877082784) | 13 | 6 | 1 | 29490 | 27 | |||
18114 | 70313 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 215-217 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5997813.3422 | 2109805.1078 | 37.7729966883074 | -122.450993675957 | (37.7729966883074, -122.450993675957) | 15 | 5 | 11 | 29492 | 16 | |||
18179 | 74854 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2345 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5986677.9867 | 2102297.122 | 37.7517380460087 | -122.48895968631 | (37.7517380460087, -122.48895968631) | 1 | 8 | 3 | 29491 | 35 | |||
18381 | 78364 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 426 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6002109.01666 | 2091133.31338 | 37.721973341484 | -122.434798932837 | (37.721973341484, -122.434798932837) | 9 | 7 | 6 | 28861 | 5 | |||
18440 | 60477 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1343 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1982 12:00:00 AM | Permit Number 20072 | 6002221.27409585 | 2113110.91985101 | 37.7823249851452 | -122.435982713361 | (37.7823249851452, -122.435982713361) | 15 | 5 | 11 | 29490 | 41 | ||
18920 | 47271 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1838 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 9 | Permit Number 45212 | 5988771.9103 | 2105832.039 | 37.7615659640444 | -122.48197762946 | (37.7615659640444, -122.48197762946) | 1 | 8 | 3 | 56 | 35 | |
19229 | 75709 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 594 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5990000.25011 | 2111357.84535 | 37.77680968475 | -122.478133372191 | (37.77680968475, -122.478133372191) | 11 | 6 | 2 | 55 | 26 | |||
19237 | 74938 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2340 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5983322.8922 | 2099223.3332 | 37.7431018841787 | -122.500334631769 | (37.7431018841787, -122.500334631769) | 1 | 8 | 3 | 29491 | 35 | |||
19401 | 45516 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2975 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | Permit Number 44280 | 5988544.38188689 | 2095413.25132317 | 37.7329454972405 | -122.482001286035 | (37.7329454972405, -122.482001286035) | 1 | 8 | 4 | 64 | 35 | ||
19520 | 37110 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1301X 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39705 | 5981797.2694 | 2106191.6975 | 37.7621453791042 | -122.506126308526 | (37.7621453791042, -122.506126308526) | 1 | 8 | 3 | 56 | 35 |
19780 | 38710 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1996 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1998 12:00:00 AM | 6 | Permit Number 40615 | 5999645.261 | 2111241.3734 | 37.7770450137925 | -122.44476012317 | (37.7770450137925, -122.44476012317) | 15 | 5 | 11 | 29490 | 16 | |
20783 | 42043 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | 2 | 4 | 5 | 28862 | 22 | ||
21121 | 51223 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 78 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/11/2004 12:00:00 AM | Permit Number 47589 | 5999349.25090269 | 2107863.63052883 | 37.7677536935842 | -122.445541163796 | (37.7677536935842, -122.445541163796) | 15 | 5 | 11 | 29492 | 9 |
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) );