trees
1,985 rows where qSpecies_id = 83 sorted by qCareAssistant
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14804 | 264658 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2845X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2020 04:59:00 PM | 3X3 | 6014746.9934 | 2090564.9462 | 37.7211221378179 | -122.391072554716 | (37.7211221378179, -122.391072554716) | 10 | 3 | 8 | 58 | 1 | |||
| 15005 | 261438 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 384 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007303 | 2095696 | 37.7347950116026 | -122.417167741106 | (37.7347950116026, -122.417167741106) | 2 | 7 | 7 | 28859 | 2 | ||||
| 15242 | 49368 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 448 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2003 12:00:00 AM | Permit Number 46341 | 6010694.36763099 | 2088383.30285889 | 37.7149060701976 | -122.404927851118 | (37.7149060701976, -122.404927851118) | 9 | 7 | 8 | 309 | 39 | |||
| 15461 | 197112 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2051 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012308.80023 | 2102801.31444 | 37.7545850296985 | -122.400359759302 | (37.7545850296985, -122.400359759302) | 10 | 3 | 8 | 28856 | 29 | |||
| 15478 | 252965 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 115X Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 02:04:00 PM | 3 | |||||||||||||
| 15527 | 19972 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100 STAIRWAY44 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 36 | |||||||||||||
| 15634 | 136235 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 928 Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008235.61174 | 2115647.76794 | 37.7896303876902 | -122.415355351862 | (37.7896303876902, -122.415355351862) | 5 | 1 | 10 | 28858 | 21 | |||
| 15852 | 239886 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 190X Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007782.31959 | 2096534.49049 | 37.737124276671 | -122.415569909436 | (37.737124276671, -122.415569909436) | 2 | 7 | 7 | 28859 | 2 | |||
| 15862 | 99761 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 4212 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 4212-4216 25th St (4214 is visible address) | 6002485 | 2101232 | 37.7497233531083 | -122.434220849449 | (37.7497233531083, -122.434220849449) | 2 | 4 | 5 | 28862 | 22 | |||
| 15928 | 197140 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 53 Pomona St | 2 | : | Tree | Private 2 | 3 | Width 5ft | 6014151.58684 | 2094423.96338 | 37.7316851643341 | -122.39340063984 | (37.7316851643341, -122.39340063984) | 10 | 3 | 8 | 58 | 1 | |||
| 15988 | 136243 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1679 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006695.60451 | 2117001.64443 | 37.7932611216587 | -122.42077978457 | (37.7932611216587, -122.42077978457) | 13 | 9 | 10 | 28858 | 32 | |||
| 16016 | 5120 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2725 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2016 10:06:00 AM | 3 | 5X5 | 6002461.05615 | 2096042.42458 | 37.7354726294434 | -122.433932747209 | (37.7354726294434, -122.433932747209) | 2 | 7 | 5 | 63 | 7 | ||
| 16204 | 114507 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 10 LOMBARD ST | 2 | Back Yard : Cutout | Tree | Port 6 | 4x4 | 6011932 | 2120995 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | 3 | 1 | 10 | 28860 | 6 | ||||
| 16300 | 248300 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3175 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6006753.7624 | 2099865.7323 | 37.74621325229 | -122.419362356984 | (37.74621325229, -122.419362356984) | 2 | 7 | 7 | 28859 | 2 | |||
| 16436 | 142218 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 401 CENTRAL AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999746.1848 | 2109905.9886 | 37.773384146155 | -122.44431500945 | (37.773384146155, -122.44431500945) | 15 | 5 | 11 | 29492 | 16 | |||
| 16463 | 106806 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 167 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 5996526.1156 | 2113255.0824 | 37.7823956347772 | -122.455695748043 | (37.7823956347772, -122.455695748043) | 11 | 6 | 1 | 54 | 31 | ||||
| 16482 | 138377 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1805 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2019 12:00:00 AM | 3 | Width 0ft | 6002995.393 | 2114531.5766 | 37.7862696963806 | -122.433406159019 | (37.7862696963806, -122.433406159019) | 13 | 9 | 11 | 29490 | 27 | ||
| 16514 | 136241 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1679 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006661.22108 | 2116996.66069 | 37.7932454995431 | -122.42089839975 | (37.7932454995431, -122.42089839975) | 13 | 9 | 10 | 28858 | 32 | |||
| 16573 | 33529 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 171 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37639 | 6007349.55714183 | 2098075.84761469 | 37.7413321670111 | -122.417175357737 | (37.7413321670111, -122.417175357737) | 2 | 7 | 7 | 28859 | 2 | |||
| 17139 | 261451 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 295 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006893 | 2095807 | 37.7350767190782 | -122.41859312449 | (37.7350767190782, -122.41859312449) | 2 | 7 | 7 | 28859 | 2 | ||||
| 17262 | 258984 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 220 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 784344 | 6010137 | 2099925 | 37.7465659576292 | -122.407667663761 | (37.7465659576292, -122.407667663761) | 2 | 7 | 7 | 28859 | 2 | |||
| 17354 | 88467 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 119 Augusta St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51421 | 6011176 | 2095454 | 37.7343476550611 | -122.403760347511 | (37.7343476550611, -122.403760347511) | 10 | 3 | 8 | 58 | 1 | |||
| 17469 | 239268 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 43 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006498.06002 | 2108217.35728 | 37.769130472909 | -122.420839370946 | (37.769130472909, -122.420839370946) | 8 | 4 | 7 | 28853 | 19 | |||
| 17572 | 7280 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1805 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/2020 02:03:00 PM | 3 | 4X4 | 6002990.933 | 2114560.8146 | 37.7863497234839 | -122.433423679579 | (37.7863497234839, -122.433423679579) | 13 | 9 | 11 | 29490 | 27 | ||
| 17729 | 197162 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 123 Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6016438.8167 | 2095743.2053 | 37.735434352517 | -122.385585060917 | (37.735434352517, -122.385585060917) | 10 | 3 | 8 | 58 | 1 | |||
| 17844 | 239290 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 870 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009903.27648 | 2104148.96892 | 37.7581509513321 | -122.408773807391 | (37.7581509513321, -122.408773807391) | 2 | 4 | 7 | 28859 | 19 | |||
| 18235 | 42453 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 550 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51619 | 5997786.60898589 | 2095288.02825485 | 37.7331348573333 | -122.45003964005 | (37.7331348573333, -122.45003964005) | 9 | 7 | 4 | 59 | 40 | ||
| 18403 | 238853 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 299x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007982.71274 | 2096562.40282 | 37.7372121799922 | -122.414879032248 | (37.7372121799922, -122.414879032248) | 2 | 7 | 7 | 28859 | 2 | |||
| 18577 | 147771 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 275 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5993980.24137 | 2113705.13134 | 37.7834849172426 | -122.464535973179 | (37.7834849172426, -122.464535973179) | 11 | 6 | 2 | 54 | 11 | |||
| 18843 | 65788 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/1990 12:00:00 AM | 7 | Permit Number 28756 | 5998021.12629 | 2115778.19726 | 37.7894091238674 | -122.450705664532 | (37.7894091238674, -122.450705664532) | 11 | 6 | 1 | 54 | 31 | ||
| 18871 | 108376 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 995X Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2015 12:00:00 AM | 3 | Permit Number 775198 | 6003269.72698 | 2111024.20368 | 37.7766548889563 | -122.432206462364 | (37.7766548889563, -122.432206462364) | 15 | 9 | 11 | 29492 | 10 | ||
| 18940 | 137981 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1940 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002965.4976 | 2115097.1921 | 37.7878210367847 | -122.433550025903 | (37.7878210367847, -122.433550025903) | 13 | 9 | 11 | 29490 | 27 | |||
| 18976 | 44337 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1386 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2001 12:00:00 AM | 10 | Permit Number 43722 | 6016111.02072 | 2094370.93672 | 37.7316482354559 | -122.386622725671 | (37.7316482354559, -122.386622725671) | 10 | 3 | 8 | 58 | 1 | ||
| 19372 | 259083 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1029 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | 6009458.60985 | 2087249.80978 | 37.7117245759679 | -122.409119233208 | (37.7117245759679, -122.409119233208) | 9 | 7 | 8 | 309 | 39 | |||
| 19495 | 102487 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2001 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5999337.8085 | 2111150.0142 | 37.7767766147896 | -122.445817121147 | (37.7767766147896, -122.445817121147) | 15 | 5 | 11 | 29492 | 16 | |||
| 19620 | 46201 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
| 19667 | 7175 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 814 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1993 12:00:00 AM | 6 | 3X3 | 6003515.423 | 2111193.7442 | 37.7771343327183 | -122.431368633672 | (37.7771343327183, -122.431368633672) | 7 | 9 | 11 | 29492 | 10 | ||
| 20110 | 56158 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 447 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1973 12:00:00 AM | 8 | Permit Number 12266 | 5990893.79558 | 2112339.92163 | 37.7795580220906 | -122.475114071606 | (37.7795580220906, -122.475114071606) | 11 | 6 | 2 | 54 | 26 | ||
| 20112 | 213955 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 Faxon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5994772.87853 | 2091030.08167 | 37.721270654392 | -122.460150467873 | (37.721270654392, -122.460150467873) | 9 | 8 | 6 | 28861 | 24 | |||
| 20196 | 88552 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 649 15th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51497 | 5991271.54152 | 2111000.35442 | 37.7759018234336 | -122.473709552083 | (37.7759018234336, -122.473709552083) | 11 | 6 | 2 | 54 | 26 | ||
| 20240 | 239310 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 460 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005491.56971 | 2101034.94567 | 37.7493524745442 | -122.42380999086 | (37.7493524745442, -122.42380999086) | 2 | 4 | 5 | 28859 | 19 | |||
| 20465 | 193326 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1398 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6015584.37458 | 2102621.55349 | 37.754273559383 | -122.389019303814 | (37.754273559383, -122.389019303814) | 10 | 3 | 8 | 28856 | 29 | |||
| 20523 | 139996 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 450 FULTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005498.173 | 2111711.6583 | 37.77866856873 | -122.424546518451 | (37.77866856873, -122.424546518451) | 7 | 9 | 11 | 28852 | 41 | |||
| 20596 | 197113 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2030 23rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6012295.98887 | 2102846.65042 | 37.7547087979762 | -122.400407248893 | (37.7547087979762, -122.400407248893) | 10 | 3 | 8 | 28856 | 29 | |||
| 20652 | 239344 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 221 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010109.73807 | 2099963.72008 | 37.746670748365 | -122.407764662809 | (37.746670748365, -122.407764662809) | 2 | 7 | 7 | 28859 | 2 | |||
| 20758 | 38463 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1160 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1998 12:00:00 AM | 4 | Permit Number 40473 | 6017671.3057 | 2092861.7612 | 37.7275905904586 | -122.38112356357 | (37.7275905904586, -122.38112356357) | 10 | 3 | 8 | 58 | 1 | ||
| 20864 | 240184 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3371 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004431.11432 | 2106566.00014 | 37.7644795237217 | -122.427871135859 | (37.7644795237217, -122.427871135859) | 8 | 4 | 5 | 28862 | 3 | |||
| 20922 | 181803 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1915 Santiago St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5986942.1793 | 2099588.0871 | 37.7443151796952 | -122.487847067129 | (37.7443151796952, -122.487847067129) | 1 | 8 | 3 | 29491 | 35 | |||
| 21156 | 16551 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 500X Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/1998 12:00:00 AM | 3 | 3x3 | 6016006.287148 | 2097894.9109735 | 37.7413185578473 | -122.387230532448 | (37.7413185578473, -122.387230532448) | 10 | 3 | 8 | 58 | 1 | ||
| 21171 | 197125 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 31 Apparel Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 6011537.38847 | 2097577.661 | 37.7401989607078 | -122.402660197209 | (37.7401989607078, -122.402660197209) | 10 | 3 | 8 | 58 | 1 | |||
| 21384 | 239247 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1330 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010310.37957 | 2101498.2335 | 37.7508954153113 | -122.407179012596 | (37.7508954153113, -122.407179012596) | 2 | 4 | 7 | 28859 | 19 | |||
| 21391 | 16673 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 244 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002873.2969 | 2106860.82122 | 37.7652007800214 | -122.433280262977 | (37.7652007800214, -122.433280262977) | 15 | 5 | 5 | 28862 | 3 | |||
| 21589 | 136245 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1723 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006515.15933 | 2116648.60219 | 37.7922815836866 | -122.421379054996 | (37.7922815836866, -122.421379054996) | 13 | 9 | 10 | 28858 | 21 | |||
| 21693 | 197124 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2 Napoleon St | 12 | : | Tree | Private 2 | 3 | Width 4ft | 6013733.0286 | 2100130.55294 | 37.7473310072149 | -122.395247287949 | (37.7473310072149, -122.395247287949) | 10 | 3 | 8 | 58 | 1 | |||
| 21703 | 95365 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 661 Broadway | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 778058 | 6010478.0762 | 2118518.1883 | 37.797637647797 | -122.407799105269 | (37.797637647797, -122.407799105269) | 3 | 1 | 10 | 308 | 4 | ||
| 21709 | 47740 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3583 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2002 12:00:00 AM | 5 | 3x3 | Permit Number 45523 | 6005444.07123 | 2097374.1868 | 37.7392981824927 | -122.423713989591 | (37.7392981824927, -122.423713989591) | 2 | 7 | 7 | 28859 | 2 | |
| 21724 | 239356 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 111 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6005135.00311 | 2098711.3374 | 37.7429522432585 | -122.424877716331 | (37.7429522432585, -122.424877716331) | 2 | 7 | 5 | 63 | 22 | |||
| 21798 | 140393 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1795 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6002743.2077 | 2113356.8165 | 37.7830297920416 | -122.434194640623 | (37.7830297920416, -122.434194640623) | 15 | 9 | 11 | 29490 | 41 | |||
| 21845 | 179297 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 326 Peru Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004358.25207 | 2093034.47753 | 37.7273209621682 | -122.427159238819 | (37.7273209621682, -122.427159238819) | 9 | 7 | 6 | 28861 | 5 | |||
| 21903 | 138448 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1820 POST ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6003221.0376 | 2114171.7858 | 37.7852946007927 | -122.432599778439 | (37.7852946007927, -122.432599778439) | 13 | 9 | 11 | 29490 | 13 | |||
| 21998 | 110495 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 230 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6003598.79471 | 2092490.01573 | 37.7257830144685 | -122.429745863482 | (37.7257830144685, -122.429745863482) | 9 | 7 | 6 | 28861 | 5 | |||
| 22287 | 1701 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 46 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2015 02:11:00 PM | 3 | 3X3 | 6017792.761567 | 2093643.6318374 | 37.7297441585391 | -122.380758013182 | (37.7297441585391, -122.380758013182) | 10 | 3 | 8 | 58 | 1 | ||
| 22297 | 123102 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 401 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992511.21682 | 2112680.96666 | 37.7805880471465 | -122.469543602377 | (37.7805880471465, -122.469543602377) | 11 | 6 | 2 | 54 | 11 | |||
| 22372 | 18655 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 85 Reuel Ct | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/1999 12:00:00 AM | 3 | 3X4 | 6017364.7700717 | 2096131.8258237 | 37.7365526173752 | -122.382410690517 | (37.7365526173752, -122.382410690517) | 10 | 3 | 8 | 58 | 1 | ||
| 22517 | 41240 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 270 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1999 12:00:00 AM | Permit Number 41940 | 5999013.40299918 | 2112000.64122659 | 37.7790936893244 | -122.447000559943 | (37.7790936893244, -122.447000559943) | 15 | 5 | 1 | 54 | 16 | |||
| 22548 | 10416 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1399 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 5999442.73592 | 2108734.00442 | 37.7701488573322 | -122.445280397708 | (37.7701488573322, -122.445280397708) | 15 | 5 | 11 | 29492 | 9 | |||
| 22596 | 213938 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 159 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5992850.99558 | 2098086.47375 | 37.7405350265634 | -122.467306643206 | (37.7405350265634, -122.467306643206) | 1 | 8 | 4 | 59 | 40 | |||
| 22631 | 52058 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3165 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2005 12:00:00 AM | Permit Number 48256 | 6006783.78749917 | 2099933.06553583 | 37.746399825173 | -122.419263309296 | (37.746399825173, -122.419263309296) | 2 | 7 | 7 | 28859 | 2 | |||
| 22986 | 93972 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3425X 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2010 12:00:00 AM | 3 | 3x6 | Permit Number 53400 | 6006959.7 | 2100858.4 | 37.7489504900318 | -122.418720633691 | (37.7489504900318, -122.418720633691) | 2 | 4 | 7 | 28859 | 19 | |
| 23046 | 136230 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3100 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004683.10116 | 2120231.33167 | 37.8020153805639 | -122.427973432847 | (37.8020153805639, -122.427973432847) | 13 | 9 | 1 | 57 | 17 | |||
| 23079 | 240160 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 4903 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5997783.51169 | 2105613.08498 | 37.7614847543311 | -122.450794550851 | (37.7614847543311, -122.450794550851) | 15 | 5 | 11 | 29492 | 12 | |||
| 23216 | 136209 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3501 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997993.27095 | 2115789.6423 | 37.7894389544021 | -122.450802865961 | (37.7894389544021, -122.450802865961) | 11 | 6 | 1 | 54 | 31 | |||
| 23281 | 43506 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 161 Newman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2000 12:00:00 AM | Permit Number 43184 | 6007338.4828929 | 2096787.18196624 | 37.7377931534639 | -122.417122358052 | (37.7377931534639, -122.417122358052) | 2 | 7 | 7 | 28859 | 2 | |||
| 23362 | 93821 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
| 23672 | 247568 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 322 Alemany Blvd | 1 | : | Tree | Private 2 | 3 | Width 4ft | 6008688.67784 | 2095404.14208 | 37.7340714901943 | -122.412356334971 | (37.7340714901943, -122.412356334971) | 10 | 7 | 7 | 28859 | 2 | |||
| 23859 | 55920 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2480 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2006 12:00:00 AM | 3x3 | Permit Number 50600 | 6006935.48968262 | 2103919.31295705 | 37.7573536936319 | -122.419021429077 | (37.7573536936319, -122.419021429077) | 2 | 4 | 7 | 28859 | 19 | ||
| 23938 | 237023 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 8 Octavia St | 4 | : | Tree | DPW 1 | 04/15/2017 01:44:00 PM | 3 | Width 6ft | 6005765.01716 | 2109438.39176 | 37.7724417955802 | -122.423461745458 | (37.7724417955802, -122.423461745458) | 7 | 9 | 11 | 28852 | 10 | ||
| 23953 | 213964 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 621 Holloway Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994850.90322 | 2091215.19212 | 37.7217834109648 | -122.459894162891 | (37.7217834109648, -122.459894162891) | 9 | 8 | 6 | 28861 | 24 | |||
| 24392 | 138122 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1850 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6003040.5439 | 2114556.186 | 37.7863398290166 | -122.433251707831 | (37.7863398290166, -122.433251707831) | 13 | 9 | 11 | 29490 | 27 | |||
| 24416 | 81916 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52300 | 6013111.49661 | 2094334.18979 | 37.7313808220717 | -122.396990173153 | (37.7313808220717, -122.396990173153) | 10 | 3 | 8 | 58 | 1 | |
| 24442 | 24127 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 140X Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016343.6401634 | 2095980.6654178 | 37.7360811036021 | -122.385930671948 | (37.7360811036021, -122.385930671948) | 10 | 3 | 8 | 58 | 1 | ||
| 24628 | 239259 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 455 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005530.597 | 2101040.15381 | 37.749368977999 | -122.423675403717 | (37.749368977999, -122.423675403717) | 2 | 4 | 5 | 28859 | 19 | |||
| 24907 | 136189 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2914 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6002539.896 | 2118184.5507 | 37.7962739719132 | -122.435243443451 | (37.7962739719132, -122.435243443451) | 13 | 9 | 1 | 57 | 17 | |||
| 24941 | 239241 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1301 Potrero Ave | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6010653.63145 | 2101615.38344 | 37.7512362871225 | -122.406000261299 | (37.7512362871225, -122.406000261299) | 10 | 4 | 8 | 28859 | 19 | |||
| 25154 | 52631 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1725@ POLK Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2006 12:00:00 AM | 3 | Permit Number 48716 | 6006396.26388 | 2116959.24979 | 37.7931278403295 | -122.421812512039 | (37.7931278403295, -122.421812512039) | 13 | 9 | 10 | 28858 | 32 | ||
| 25176 | 85636 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1161 Quesada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017631.370144 | 2092826.687243 | 37.7274920796749 | -122.381259184857 | (37.7274920796749, -122.381259184857) | 10 | 3 | 8 | 58 | 1 | ||
| 25213 | 18261 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1870 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/1991 12:00:00 AM | 6 | 4X4 | 6003225.4707245 | 2114168.1799394 | 37.7852849514104 | -122.432584183534 | (37.7852849514104, -122.432584183534) | 13 | 9 | 11 | 29490 | 13 | ||
| 25494 | 48801 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
| 25528 | 239279 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 266 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006490.03164 | 2104559.30004 | 37.7590858550479 | -122.420607431291 | (37.7590858550479, -122.420607431291) | 2 | 4 | 7 | 28859 | 19 | |||
| 25557 | 197109 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 600 De Haro St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6012049.36164 | 2105557.39202 | 37.7621381396801 | -122.401450654931 | (37.7621381396801, -122.401450654931) | 10 | 3 | 8 | 28856 | 29 | ||||
| 26224 | 111868 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3399x 16TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004303 | 2106535 | 37.7643871563547 | -122.428312038708 | (37.7643871563547, -122.428312038708) | 8 | 4 | 5 | 28862 | 3 | ||||
| 26265 | 120516 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 888 Brannan St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011018 | 2109170 | 37.7719999408521 | -122.405272169822 | (37.7719999408521, -122.405272169822) | 14 | 2 | 9 | 28853 | 34 | ||||
| 26281 | 213989 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2583 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992043.57751 | 2097881.5544 | 37.7399257259925 | -122.470083438513 | (37.7399257259925, -122.470083438513) | 1 | 8 | 4 | 59 | 40 | |||
| 26378 | 96719 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1340 Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008320 | 2116937 | 37.7931750456071 | -122.415154672616 | (37.7931750456071, -122.415154672616) | 5 | 1 | 10 | 28858 | 21 | |||||
| 26416 | 48800 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
| 26571 | 150167 | Planning Code 138.1 required 2 | Pyrus kawakamii :: Evergreen Pear 83 | 333 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779492 | 6014367.55242 | 2105483.96934 | 37.7620656102492 | -122.393427719319 | (37.7620656102492, -122.393427719319) | 10 | 3 | 8 | 28856 | 29 | |
| 26708 | 240143 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 109 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5998171.35185 | 2106192.58759 | 37.7630981164972 | -122.449494935145 | (37.7630981164972, -122.449494935145) | 15 | 5 | 11 | 29492 | 9 | |||
| 26731 | 88124 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 266 Lexington St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51128 | 6006494 | 2104554 | 37.7590715260193 | -122.42059333056 | (37.7590715260193, -122.42059333056) | 2 | 4 | 7 | 28859 | 19 | |||
| 26875 | 240157 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 563 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5998602.31996 | 2105951.33852 | 37.7624603514868 | -122.447986997796 | (37.7624603514868, -122.447986997796) | 15 | 5 | 11 | 29492 | 9 | |||
| 27068 | 240206 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 81 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003903.54766 | 2097252.33034 | 37.7388765103369 | -122.429031747817 | (37.7388765103369, -122.429031747817) | 2 | 7 | 5 | 63 | 7 |
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) );