Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4964 | 4964 | 253756 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 41x Division St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 5x5 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5007 | 5007 | 253755 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 41x Division St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 5x5 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4344 | 4344 | 253624 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 735 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5998960.0 | 2095994.0 | 37.735140362702396 | -122.446033688862 | (37.7351403627024, -122.446033688862) | ||||
| 3812 | 3812 | 253561 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 530 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5993033.55222 | 2099443.36305 | 37.744271238444206 | -122.46677405027799 | (37.7442712384442, -122.466774050278) | ||||
| 3256 | 3256 | 253373 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 78 Peralta Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6010457.0 | 2100357.0 | 37.7477700431666 | -122.406591570174 | (37.7477700431666, -122.406591570174) | ||||
| 3037 | 3037 | 253283 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 673 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005929.0 | 2099335.0 | 37.7447094953859 | -122.422176588207 | (37.7447094953859, -122.422176588207) | ||||
| 2775 | 2775 | 253211 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1858 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993493.0 | 2102864.0 | 37.753689940286606 | -122.465433828694 | (37.7536899402866, -122.465433828694) | ||||
| 2365 | 2365 | 253069 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 2380 | 2380 | 253068 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 2382 | 2382 | 253067 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 2384 | 2384 | 253066 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 781 | 781 | 251370 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 390 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6011351.0 | 2111108.0 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | |||
| 674 | 674 | 251361 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 301 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010388.0 | 2110913.0 | 37.7767505721368 | -122.40757431033701 | (37.7767505721368, -122.407574310337) | ||||
| 709 | 709 | 251360 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 301 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/1991 12:00:00 AM | 3x3 | 6010388.0 | 2110913.0 | 37.7767505721368 | -122.40757431033701 | (37.7767505721368, -122.407574310337) | |||
| 454 | 454 | 251309 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2111 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991606.081259999 | 2101026.68041 | 37.7485361329461 | -122.471825260742 | (37.7485361329461, -122.471825260742) | ||||
| 56917 | 56917 | 250996 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 453 44th Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5982195.03644 | 2112765.4035099996 | 37.780218274692004 | -122.505237834779 | (37.780218274692, -122.505237834779) | |||
| 71699 | 71699 | 250844 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 242 30th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5986530.96095 | 2114207.2735200003 | 37.784431412324295 | -122.490344186658 | (37.7844314123243, -122.490344186658) | |||
| 69600 | 69600 | 250770 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 247 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5985863.4711 | 2114256.40781 | 37.7845273142332 | -122.492657058592 | (37.7845273142332, -122.492657058592) | |||
| 185839 | 185839 | 250211 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 212 Union St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 6011741.8662 | 2119796.92436 | 37.80121941579 | -122.40351603796002 | (37.80121941579, -122.40351603796) | |||
| 46848 | 46848 | 249650 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2401 Lyon St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 10ft | 5999216.2482900005 | 2117285.03492 | 37.793614839395204 | -122.446679155136 | (37.7936148393952, -122.446679155136) | |||
| 30450 | 30450 | 249647 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2460 Lyon St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 10ft | 5999284.57219 | 2117293.7782799997 | 37.7936427489551 | -122.44644337897101 | (37.7936427489551, -122.446443378971) | |||
| 31356 | 31356 | 248452 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 733 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997923.3949 | 2107987.1864 | 37.7680114417823 | -122.450481911702 | (37.7680114417823, -122.450481911702) | |||
| 166236 | 166236 | 248394 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1345 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999506.8881 | 2108123.6109 | 37.768476532437 | -122.44501460966002 | (37.768476532437, -122.44501460966) | |||
| 26284 | 26284 | 248135 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 115 Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6010354.084919999 | 2099463.5381099996 | 37.745311033696105 | -122.406884485526 | (37.7453110336961, -122.406884485526) | |||
| 49434 | 49434 | 247805 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 488 30th St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6003450.91279 | 2098365.25645 | 37.741906717527705 | -122.43067614380199 | (37.7419067175277, -122.430676143802) | |||
| 188351 | 188351 | 247804 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 488 30th St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6003501.316380001 | 2098369.19661 | 37.7419203917212 | -122.430502145662 | (37.7419203917212, -122.430502145662) | |||
| 54751 | 54751 | 247473 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 838 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6002529.5119 | 2109559.0264 | 37.77258987959671 | -122.434662285947 | (37.7725898795967, -122.434662285947) | |||
| 158979 | 158979 | 247368 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 400 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001749.9295 | 2109917.0076 | 37.773528518653706 | -122.437384576125 | (37.7735285186537, -122.437384576125) | |||
| 176565 | 176565 | 247367 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 400 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001753.1306 | 2109900.2906 | 37.7734827999277 | -122.437372305789 | (37.7734827999277, -122.437372305789) | |||
| 129903 | 129903 | 247354 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 630 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6003928.5062 | 2110104.6761 | 37.7741674220984 | -122.429861947834 | (37.7741674220984, -122.429861947834) | |||
| 166851 | 166851 | 247350 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1563 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999192.1295 | 2109050.0804 | 37.771002413539 | -122.44616997883301 | (37.771002413539, -122.446169978833) | |||
| 150921 | 150921 | 247349 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1563 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999140.3269 | 2109043.1665 | 37.7709804712442 | -122.446348667441 | (37.7709804712442, -122.446348667441) | |||
| 138067 | 138067 | 247269 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1035 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5999326.3938 | 2109239.9147 | 37.7715313170334 | -122.445719210419 | (37.7715313170334, -122.445719210419) | |||
| 40846 | 40846 | 247267 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1015 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999314.857999999 | 2109330.4914 | 37.7717793590176 | -122.4457656283 | (37.7717793590176, -122.4457656283) | |||
| 125301 | 125301 | 247266 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1015 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999307.5948 | 2109374.9253 | 37.771900948519104 | -122.445793948227 | (37.7719009485191, -122.445793948227) | |||
| 59087 | 59087 | 247265 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1569 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999051.8863 | 2109030.7763 | 37.770941399373704 | -122.446653693236 | (37.7709413993737, -122.446653693236) | |||
| 130458 | 130458 | 247223 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 161 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6001877.39877 | 2108558.68003 | 37.7698061344742 | -122.436846384277 | (37.7698061344742, -122.436846384277) | |||
| 147828 | 147828 | 247222 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 187 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6001857.53471 | 2108690.91436 | 37.7701680882111 | -122.436924561446 | (37.7701680882111, -122.436924561446) | |||
| 24622 | 24622 | 247221 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 187 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6001849.330080001 | 2108668.89946 | 37.770107174421796 | -122.436951364836 | (37.7701071744218, -122.436951364836) | |||
| 152409 | 152409 | 247000 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 415 Valley St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6003159.75235 | 2099193.72668 | 37.7441650051229 | -122.431742019398 | (37.7441650051229, -122.431742019398) | |||
| 39953 | 39953 | 246990 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 78 Clipper St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6004670.61163 | 2101066.74727 | 37.7493934152835 | -122.426651147943 | (37.7493934152835, -122.426651147943) | |||
| 42788 | 42788 | 246481 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 330 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 5ft | 6004176.06205 | 2099871.25195 | 37.74608289033021 | -122.42827612036301 | (37.7460828903302, -122.428276120363) | |||
| 182755 | 182755 | 246476 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 320 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6004295.790030001 | 2099877.9312 | 37.7461080038827 | -122.42786259230301 | (37.7461080038827, -122.427862592303) | |||
| 149878 | 149878 | 246427 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 464 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6003499.77628 | 2099836.70737 | 37.74594974928 | -122.430612163326 | (37.74594974928, -122.430612163326) | |||
| 37865 | 37865 | 246294 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 300 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | Permit Number 50790 | 6002905.9647 | 2106288.4454 | 37.7636310281204 | -122.43312637362 | (37.7636310281204, -122.43312637362) | ||
| 175490 | 175490 | 246293 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 300 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 2 | Width 0ft | Permit Number 50790 | 6002903.8326 | 2106309.7667 | 37.763689450299 | -122.433135271378 | (37.763689450299, -122.433135271378) | |
| 55577 | 55577 | 246292 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 300 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 4 | Width 0ft | Permit Number 50790 | 6002901.7005 | 2106332.154 | 37.763750799453895 | -122.433144245321 | (37.7637507994539, -122.433144245321) | |
| 25904 | 25904 | 246050 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1260 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999528.5404 | 2108445.6696 | 37.769362060220004 | -122.444962871278 | (37.76936206022, -122.444962871278) | |||
| 31825 | 31825 | 246049 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1260 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5999544.2875 | 2108448.0922 | 37.7693696107845 | -122.444908577153 | (37.7693696107845, -122.444908577153) | |||
| 28214 | 28214 | 246048 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1260 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999560.3375 | 2108450.212 | 37.76937634719779 | -122.44485321353399 | (37.7693763471978, -122.444853213534) | |||
| 154562 | 154562 | 245043 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 327 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001734.262999999 | 2109552.9566 | 37.7725280347604 | -122.43741269473301 | (37.7725280347604, -122.437412694733) | |||
| 74167 | 74167 | 244954 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 281 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6005222.1859 | 2109884.4441 | 37.7736358939954 | -122.425371201101 | (37.7736358939954, -122.425371201101) | |||
| 39579 | 39579 | 244952 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 290 Page St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 6005205.1684 | 2109938.5353 | 37.7737834538473 | -122.425433917449 | (37.7737834538473, -122.425433917449) | |||
| 131986 | 131986 | 244546 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1055 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999338.3567 | 2109157.8829 | 37.7713067615329 | -122.44567193008801 | (37.7713067615329, -122.445671930088) | |||
| 156298 | 156298 | 244070 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 407 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997428.8532 | 2109093.8347 | 37.771021696572795 | -122.452272330766 | (37.7710216965728, -122.452272330766) | |||
| 138117 | 138117 | 244069 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 405 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997423.6428 | 2109118.4396 | 37.77108895680129 | -122.45229212933 | (37.7710889568013, -122.45229212933) | |||
| 1546 | 1546 | 237042 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2627 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2017 12:00:00 AM | 3 | 4x4 | Permit Number 779999 | 6010308.84654 | 2103966.51965 | 37.757672694545896 | -122.407358302349 | (37.7576726945459, -122.407358302349) | |
| 175933 | 175933 | 228346 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 68 McCoppin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006197.13194 | 2109167.3816400003 | 37.7717220465789 | -122.421947761107 | (37.7717220465789, -122.421947761107) | |||
| 52962 | 52962 | 228345 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 5587 Diamond Heights Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001625.45528 | 2097121.42182 | 37.7383878502062 | -122.436898948753 | (37.7383878502062, -122.436898948753) | |||
| 24789 | 24789 | 228344 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2 Digby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003262.92712 | 2097108.5929599998 | 37.7384455570072 | -122.4312364574 | (37.7384455570072, -122.4312364574) | |||
| 38697 | 38697 | 228343 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 50 Everson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6003603.71357 | 2097148.2169 | 37.7385736618306 | -122.43006100933201 | (37.7385736618306, -122.430061009332) | |||
| 175527 | 175527 | 228342 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 225 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004124.16137 | 2097587.45021 | 37.739809158568 | -122.428292845936 | (37.739809158568, -122.428292845936) | |||
| 176337 | 176337 | 228341 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 221 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004146.11825 | 2097570.73294 | 37.739764499139106 | -122.428215737193 | (37.7397644991391, -122.428215737193) | |||
| 131512 | 131512 | 228340 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 527 30th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003227.90552 | 2098318.66443 | 37.7417661498904 | -122.431443904912 | (37.7417661498904, -122.431443904912) | |||
| 62612 | 62612 | 228339 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 527 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003202.64576 | 2098317.8527900004 | 37.7417624896535 | -122.43153118682899 | (37.7417624896535, -122.431531186829) | |||
| 184648 | 184648 | 228338 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1768 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003965.24462 | 2097947.62405 | 37.7407891201243 | -122.428867983974 | (37.7407891201243, -122.428867983974) | |||
| 162869 | 162869 | 228337 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1768 Sanchez St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 6003964.05943 | 2097961.58291 | 37.740827380874 | -122.428873076831 | (37.740827380874, -122.428873076831) | |||
| 169958 | 169958 | 228336 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 20 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004252.72568 | 2098174.1864099996 | 37.741427476008894 | -122.427890122347 | (37.7414274760089, -122.427890122347) | |||
| 29458 | 29458 | 228335 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 61 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004305.625030001 | 2097893.91637 | 37.7406609109864 | -122.427687250574 | (37.7406609109864, -122.427687250574) | |||
| 151966 | 151966 | 228334 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 65 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004308.16319 | 2097838.3697200003 | 37.740508536136 | -122.427674517971 | (37.740508536136, -122.427674517971) | |||
| 69902 | 69902 | 228333 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1860 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004567.46714 | 2097876.94226 | 37.7406291118418 | -122.42678069166901 | (37.7406291118418, -122.426780691669) | |||
| 32342 | 32342 | 228332 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1851 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004603.41729 | 2097955.34204 | 37.740846412323705 | -122.42666197129499 | (37.7408464123237, -122.426661971295) | |||
| 60369 | 60369 | 228331 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 50 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006613.24139 | 2110474.9452400003 | 37.775335761765206 | -122.42060124485201 | (37.7753357617652, -122.420601244852) | |||
| 57818 | 57818 | 228330 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 50 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006629.486740001 | 2110479.58962 | 37.7753494296554 | -122.420545378067 | (37.7753494296554, -122.420545378067) | |||
| 61735 | 61735 | 228329 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 50 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006643.38674 | 2110482.36773 | 37.7753578410187 | -122.42049749188801 | (37.7753578410187, -122.420497491888) | |||
| 163280 | 163280 | 228328 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 50 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006665.66427 | 2110481.1444200003 | 37.775355737523206 | -122.420420341729 | (37.7753557375232, -122.420420341729) | |||
| 123407 | 123407 | 228327 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Rose St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006141.43109 | 2109876.17462 | 37.7736650804216 | -122.422190799263 | (37.7736650804216, -122.422190799263) | |||
| 132183 | 132183 | 228326 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Rose St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006167.99201 | 2109877.54342 | 37.77367033693589 | -122.42209901807199 | (37.7736703369359, -122.422099018072) | |||
| 147010 | 147010 | 228325 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Rose St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6006186.85777 | 2109878.68777 | 37.7736745430901 | -122.422033839708 | (37.7736745430901, -122.422033839708) | |||
| 55758 | 55758 | 228324 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Rose St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006206.47677 | 2109879.05055 | 37.7736766456861 | -122.42196600022699 | (37.7736766456861, -122.421966000227) | |||
| 130972 | 130972 | 228323 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Rose St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006226.54275 | 2109882.46757 | 37.77368715965971 | -122.421896831567 | (37.7736871596597, -122.421896831567) | |||
| 49685 | 49685 | 228322 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Rose St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006240.81173 | 2109884.47213 | 37.7736934684005 | -122.421847615292 | (37.7736934684005, -122.421847615292) | |||
| 153985 | 153985 | 228321 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Rose St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006257.78716 | 2109887.18689 | 37.7737018797836 | -122.421789087419 | (37.7737018797836, -122.421789087419) | |||
| 38261 | 38261 | 228320 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Rose St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006273.61713 | 2109890.3080599997 | 37.7737113424482 | -122.421734550735 | (37.7737113424482, -122.421734550735) | |||
| 71346 | 71346 | 228319 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Rose St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6006324.21381 | 2109901.13969 | 37.773743936574 | -122.421560298068 | (37.773743936574, -122.421560298068) | |||
| 27521 | 27521 | 228318 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006345.064180001 | 2109905.30645 | 37.7737565531424 | -122.42148846921002 | (37.7737565531424, -122.42148846921) | |||
| 2959 | 2959 | 228317 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 119 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 3 | Width 3ft | Permit Number 37770 | 6003543.433130001 | 2108799.0519999997 | 37.7705606845675 | -122.4311007758 | (37.7705606845675, -122.4311007758) | |
| 51945 | 51945 | 228316 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 11 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004193.31394 | 2108893.70276 | 37.7708573771991 | -122.428859580726 | (37.7708573771991, -122.428859580726) | |||
| 176555 | 176555 | 228315 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 82 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002875.02874 | 2108789.24998 | 37.77049587221529 | -122.43341209010599 | (37.7704958722153, -122.433412090106) | |||
| 133921 | 133921 | 228314 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 139 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001423.6130800005 | 2106189.90222 | 37.763276254226106 | -122.438246293254 | (37.7632762542261, -122.438246293254) | |||
| 129409 | 129409 | 228313 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 227 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000857.23053 | 2106447.25055 | 37.76395063963779 | -122.44022367488701 | (37.7639506396378, -122.440223674887) | |||
| 188067 | 188067 | 228312 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 229 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000835.94926 | 2106462.40588 | 37.7639910407901 | -122.440298367199 | (37.7639910407901, -122.440298367199) | |||
| 66787 | 66787 | 228311 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 72 Mars St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999574.46786 | 2105368.95977 | 37.760916805498 | -122.444582848025 | (37.760916805498, -122.444582848025) | |||
| 76424 | 76424 | 228310 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 75 Mars St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5999601.029180001 | 2105410.13538 | 37.7610313791082 | -122.44449394375799 | (37.7610313791082, -122.444493943758) | |||
| 34572 | 34572 | 228309 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 75 Mars St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999604.66781 | 2105398.83885 | 37.761000569253795 | -122.44448054746599 | (37.7610005692538, -122.444480547466) | |||
| 67663 | 67663 | 228308 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 4343 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6000503.771819999 | 2105757.81022 | 37.762037476779795 | -122.441396705606 | (37.7620374767798, -122.441396705606) | |||
| 133671 | 133671 | 228307 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 34 Uranus Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999284.0241 | 2105538.8681799998 | 37.76136675427979 | -122.44559958015499 | (37.7613667542798, -122.445599580155) | |||
| 34699 | 34699 | 228306 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 52 Ord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6000824.72696 | 2106073.0484599997 | 37.762921322371 | -122.44030925708799 | (37.762921322371, -122.440309257088) | |||
| 185488 | 185488 | 228305 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 27 Ord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000858.57569 | 2106214.0094 | 37.7633102935442 | -122.440202295322 | (37.7633102935442, -122.440202295322) | |||
| 51184 | 51184 | 228304 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 75 Ord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000873.50701 | 2105964.6347 | 37.762626422100894 | -122.44013276960699 | (37.7626264221009, -122.440132769607) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");