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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6258 | 6258 | 36871 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 12355 | 12355 | 36869 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 12626 | 12626 | 36872 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 14259 | 14259 | 36873 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 50268 | 50268 | 226146 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 0 Chattanooga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004672.1171 | 2103577.59935 | 37.756287714330796 | -122.42682473328199 | (37.7562877143308, -122.426824733282) | |||
| 71030 | 71030 | 225636 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 0 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008158.437390001 | 2095854.0250900001 | 37.7352770017363 | -122.414221366146 | (37.7352770017363, -122.414221366146) | |||
| 61834 | 61834 | 201616 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 0 Innes Ct | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6021349.55513 | 2092801.0747099998 | 37.7276263098888 | -122.36840346285801 | (37.7276263098888, -122.368403462858) | |||
| 55697 | 55697 | 143068 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1 Child St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6010607.1256 | 2120351.0165 | 37.8026773688895 | -122.40748184222299 | (37.8026773688895, -122.407481842223) | |||
| 24792 | 24792 | 93957 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1 Hawthorne St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53397 | 6012892.58363 | 2114155.98675 | 37.7857949437324 | -122.39913784414499 | (37.7857949437324, -122.399137844145) | |
| 39510 | 39510 | 93954 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1 Hawthorne St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53397 | 6012934.64989 | 2114104.9095099997 | 37.7856570416874 | -122.398988719454 | (37.7856570416874, -122.398988719454) | |
| 52142 | 52142 | 93951 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1 Hawthorne St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53397 | 6012976.25628 | 2114064.01935 | 37.7855470851813 | -122.39884190155199 | (37.7855470851813, -122.398841901552) | |
| 137030 | 137030 | 93956 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1 Hawthorne St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53397 | 6012912.43006 | 2114137.6628 | 37.7857457364097 | -122.399067893988 | (37.7857457364097, -122.399067893988) | |
| 137751 | 137751 | 93953 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1 Hawthorne St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53397 | 6012948.58524 | 2114090.90941 | 37.785619377185604 | -122.398939523867 | (37.7856193771856, -122.398939523867) | |
| 168075 | 168075 | 93955 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1 Hawthorne St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53397 | 6012923.46043 | 2114122.83633 | 37.785705641042796 | -122.39902869074699 | (37.7857056410428, -122.399028690747) | |
| 179543 | 179543 | 93952 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1 Hawthorne St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53397 | 6012964.977030001 | 2114077.5230400003 | 37.7855835346973 | -122.39888187279499 | (37.7855835346973, -122.398881872795) | |
| 63771 | 63771 | 128891 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1 Locust St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997465.761580001 | 2116272.47482 | 37.7907344727794 | -122.45266284112499 | (37.7907344727794, -122.452662841125) | |||
| 71632 | 71632 | 45748 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2001 12:00:00 AM | 3 | Permit Number 44395 | 5997461.24318 | 2116299.42267 | 37.790808205469396 | -122.452680420191 | (37.7908082054694, -122.452680420191) | ||
| 134904 | 134904 | 128889 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1 Locust St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997463.35178 | 2116288.09249 | 37.790777216646 | -122.452672306504 | (37.790777216646, -122.452672306504) | |||
| 161164 | 161164 | 128893 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1 Locust St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997470.08406 | 2116254.8716700003 | 37.790686386907204 | -122.452646614665 | (37.7906863869072, -122.452646614665) | |||
| 167102 | 167102 | 128892 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1 Locust St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997467.544369999 | 2116264.26497 | 37.7907120328778 | -122.452656080026 | (37.7907120328778, -122.452656080026) | |||
| 185148 | 185148 | 128890 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1 Locust St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997463.97068 | 2116280.29604 | 37.790755845141796 | -122.452669602227 | (37.7907558451418, -122.452669602227) | |||
| 65304 | 65304 | 56472 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1 Massasoit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/03/2014 12:00:00 AM | 3 | Permit Number 773427 | 6010126.92776078 | 2099291.06805198 | 37.7448247552135 | -122.40765780266001 | (37.7448247552135, -122.40765780266) | ||
| 107859 | 107859 | 1389 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017228.6912616 | 2095462.3520099 | 37.7347068580177 | -122.38283460251301 | (37.7347068580177, -122.382834602513) | ||
| 119539 | 119539 | 92973 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 1 on Market St. | 6001664.0 | 2105786.0 | 37.7621809066996 | -122.437385951828 | (37.7621809066996, -122.437385951828) | ||||
| 168120 | 168120 | 129006 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Fallon Pl | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6008915.40705 | 2118578.41421 | 37.7977154080083 | -122.41321064328301 | (37.7977154080083, -122.413210643283) | ||||
| 187189 | 187189 | 225618 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Lippard Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002076.31903 | 2096053.6546599998 | 37.7354816235692 | -122.435263729452 | (37.7354816235692, -122.435263729452) | |||
| 64690 | 64690 | 192441 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 McLea Ct | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6010051.802130001 | 2109236.00979 | 37.7721271227961 | -122.408618994484 | (37.7721271227961, -122.408618994484) | |||
| 154899 | 154899 | 192442 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 McLea Ct | 6 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6010037.847630001 | 2109199.90386 | 37.7720272027263 | -122.408664716903 | (37.7720272027263, -122.408664716903) | |||
| 155923 | 155923 | 192440 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 McLea Ct | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6010071.610859999 | 2109254.18785 | 37.772178144932205 | -122.40855175667801 | (37.7721781449322, -122.408551756678) | |||
| 31696 | 31696 | 219138 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002033.1704400005 | 2094872.15307 | 37.732235041303795 | -122.435328423075 | (37.7322350413038, -122.435328423075) | |||
| 65010 | 65010 | 219139 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002013.342069999 | 2094862.2394400002 | 37.7322066946676 | -122.435396265231 | (37.7322066946676, -122.435396265231) | |||
| 136825 | 136825 | 219137 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Monterey Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001957.40334 | 2094833.9008099998 | 37.732125706236 | -122.43558763107299 | (37.732125706236, -122.435587631073) | |||
| 156696 | 156696 | 219141 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Monterey Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001980.05699 | 2094846.1524900002 | 37.73216063319639 | -122.435510188655 | (37.7321606331964, -122.435510188655) | |||
| 183755 | 183755 | 219140 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002002.66106 | 2094856.00835 | 37.732188978916994 | -122.43543274625 | (37.732188978917, -122.43543274625) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 182088 | 182088 | 226177 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007585.38429 | 2098145.9344200003 | 37.7415378740877 | -122.41636491103 | (37.7415378740877, -122.41636491103) | |||
| 31448 | 31448 | 219118 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Brompton Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002034.57495 | 2095088.74444 | 37.7328298313259 | -122.435339054851 | (37.7328298313259, -122.435339054851) | |||
| 54082 | 54082 | 219117 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Brompton Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002040.90491 | 2095107.61189 | 37.732881996497 | -122.435318519728 | (37.732881996497, -122.435318519728) | |||
| 75895 | 75895 | 219119 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Brompton Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002030.49307 | 2095074.1316099998 | 37.7327894760326 | -122.435352122012 | (37.7327894760326, -122.435352122012) | |||
| 132626 | 132626 | 219123 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Brompton Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002016.155119999 | 2095016.1779599998 | 37.7326295343225 | -122.435397547681 | (37.7326295343225, -122.435397547681) | |||
| 169156 | 169156 | 219121 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Brompton Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002025.50342 | 2095049.38545 | 37.7327212453836 | -122.43536760293699 | (37.7327212453836, -122.435367602937) | |||
| 173189 | 173189 | 219122 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Brompton Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002020.049930001 | 2095030.436 | 37.7326689048259 | -122.43538510194901 | (37.7326689048259, -122.435385101949) | |||
| 184786 | 184786 | 219120 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Brompton Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002027.685269999 | 2095060.20973 | 37.7327510902846 | -122.435360833759 | (37.7327510902846, -122.435360833759) | |||
| 100184 | 100184 | 49340 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Clifford Ter | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2003 12:00:00 AM | Permit Number 46332 | 5999646.98705896 | 2106515.41862964 | 37.764068834305206 | -122.444414431135 | (37.7640688343052, -122.444414431135) | |||
| 126133 | 126133 | 49342 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Clifford Ter | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2003 12:00:00 AM | Permit Number 46332 | 5999646.98705896 | 2106515.41862964 | 37.764068834305206 | -122.444414431135 | (37.7640688343052, -122.444414431135) | |||
| 121415 | 121415 | 33469 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1996 12:00:00 AM | Permit Number 37568 | 6006683.58482984 | 2099106.89574168 | 37.74412570540729 | -122.419551194294 | (37.7441257054073, -122.419551194294) | ||
| 23023 | 23023 | 32465 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2013 12:00:00 AM | 1 | 3x3 | Permit Number 769711 | 6000816.86333 | 2105689.19673 | 37.7618669122537 | -122.440308925238 | (37.7618669122537, -122.440308925238) |
| 36592 | 36592 | 44200 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | 4 | Permit Number 43651 | 6015644.9623 | 2115187.5878 | 37.7887804851876 | -122.389687383164 | (37.7887804851876, -122.389687383164) | ||
| 53179 | 53179 | 44191 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | |||
| 60489 | 60489 | 44198 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | 4 | Permit Number 43651 | 6015613.21564 | 2115159.68111 | 37.7887020993715 | -122.389795273027 | (37.7887020993715, -122.389795273027) | ||
| 82358 | 82358 | 44194 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | |||
| 82887 | 82887 | 44189 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | |||
| 88797 | 88797 | 44190 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | |||
| 103387 | 103387 | 44201 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | |||
| 108462 | 108462 | 44192 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | |||
| 113372 | 113372 | 44193 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | |||
| 128614 | 128614 | 44195 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | |||
| 136336 | 136336 | 44196 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | 4 | Permit Number 43651 | 6015590.27485 | 2115136.0126900002 | 37.788635839119294 | -122.389872991572 | (37.7886358391193, -122.389872991572) | ||
| 157322 | 157322 | 44199 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | 3 | Permit Number 43651 | 6015629.81658 | 2115174.24288 | 37.7887430032356 | -122.38973885318899 | (37.7887430032356, -122.389738853189) | ||
| 170632 | 170632 | 44197 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2000 12:00:00 AM | 4 | Permit Number 43651 | 6015604.12637 | 2115150.5006 | 37.7886763877505 | -122.389826079337 | (37.7886763877505, -122.389826079337) | ||
| 53043 | 53043 | 128951 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008567.44995 | 2112479.14828 | 37.7809487678993 | -122.413982974738 | (37.7809487678993, -122.413982974738) | |||
| 158966 | 158966 | 128954 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008488.64785 | 2112470.36476 | 37.7809202243324 | -122.414254969316 | (37.7809202243324, -122.414254969316) | |||
| 175739 | 175739 | 128952 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008545.08155 | 2112474.66764 | 37.780935208818896 | -122.41406004124399 | (37.7809352088189, -122.414060041244) | |||
| 176122 | 176122 | 128953 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008513.20798 | 2112471.4914700002 | 37.7809246975586 | -122.414170083205 | (37.7809246975586, -122.414170083205) | |||
| 10370 | 10370 | 107580 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992406.39157 | 2086830.73395 | 37.709603859212706 | -122.468025367885 | (37.7096038592127, -122.468025367885) | ||
| 10524 | 10524 | 107581 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992393.946819999 | 2086830.9956900002 | 37.7096038591978 | -122.46806839775299 | (37.7096038591978, -122.468068397753) | ||
| 11907 | 11907 | 107582 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992337.55751 | 2086836.4734200002 | 37.7096156430274 | -122.46826368552 | (37.7096156430274, -122.46826368552) | ||
| 12169 | 12169 | 107579 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992416.91174 | 2086830.03613 | 37.7096025506984 | -122.467988957943 | (37.7096025506984, -122.467988957943) | ||
| 51729 | 51729 | 176543 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 6 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992283.95996 | 2086838.07777 | 37.709616952417704 | -122.468449043003 | (37.7096169524177, -122.468449043003) | |||
| 60465 | 60465 | 176542 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 5 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992312.69836 | 2086838.42699 | 37.7096195712459 | -122.468349744347 | (37.7096195712459, -122.468349744347) | |||
| 161043 | 161043 | 176544 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 7 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992259.97775 | 2086836.1982 | 37.7096104062721 | -122.46853179230499 | (37.7096104062721, -122.468531792305) | |||
| 68051 | 68051 | 176527 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6004589.78271 | 2090506.01263 | 37.7203914438823 | -122.42617890585 | (37.7203914438823, -122.42617890585) | |||
| 155785 | 155785 | 176528 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Prague St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004578.32338 | 2090490.7118799998 | 37.7203487836515 | -122.426217428296 | (37.7203487836515, -122.426217428296) | |||
| 170889 | 170889 | 176526 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004597.29185 | 2090518.89763 | 37.720427247709 | -122.426153866008 | (37.720427247709, -122.426153866008) | |||
| 10764 | 10764 | 19741 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY15 | -14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 1OST | ||||||||
| 12425 | 12425 | 19740 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY15 | -50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 1OST | ||||||||
| 11829 | 11829 | 19801 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY21 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40ST | ||||||||
| 14064 | 14064 | 19797 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY21 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40ST | ||||||||
| 16189 | 16189 | 19840 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY25 | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60X | ||||||||
| 37504 | 37504 | 192469 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1000 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6014870.03943 | 2103923.77532 | 37.7578095596756 | -122.39158071238 | (37.7578095596756, -122.39158071238) | |||
| 38061 | 38061 | 192471 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1000 22nd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6014799.35155 | 2103920.33928 | 37.757796201155706 | -122.391824942193 | (37.7577962011557, -122.391824942193) | |||
| 76248 | 76248 | 192468 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1000 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6014906.49786 | 2103925.69197 | 37.757816845998505 | -122.39145475692499 | (37.7578168459985, -122.391454756925) | |||
| 169106 | 169106 | 192470 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1000 22nd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014832.70201 | 2103922.31866 | 37.757803487458794 | -122.39170973991001 | (37.7578034874588, -122.39170973991) | |||
| 16441 | 16441 | 34987 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | Permit Number 41601 | 6011225.3523699995 | 2111221.4707400003 | 37.7776443970062 | -122.404699365001 | (37.7776443970062, -122.404699365001) | |||
| 14183 | 14183 | 7380 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010853.2469 | 2111475.4662 | 37.7783210049209 | -122.40600450833401 | (37.7783210049209, -122.406004508334) | |||
| 15454 | 15454 | 7377 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010910.3764 | 2111530.9317 | 37.7784764953194 | -122.405810783213 | (37.7784764953194, -122.405810783213) | |||
| 15604 | 15604 | 7382 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 60 | 3X3 | 6010814.6984 | 2111439.6909 | 37.7782206182135 | -122.406135341461 | (37.7782206182135, -122.406135341461) | |||
| 15693 | 15693 | 7378 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010884.8623 | 2111505.4176 | 37.7784050126686 | -122.40589724881 | (37.7784050126686, -122.40589724881) | |||
| 15850 | 15850 | 7381 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/19/2012 12:00:00 AM | 3 | 3x3 | 6010836.3299 | 2111459.1038 | 37.7782751314106 | -122.40606187778499 | (37.7782751314106, -122.406061877785) | ||
| 16764 | 16764 | 7379 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010870.4412 | 2111489.3325 | 37.7783600402028 | -122.40594600363998 | (37.7783600402028, -122.40594600364) | |||
| 57003 | 57003 | 59618 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1004 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 2 | Permit Number 31152 | 6015486.09515 | 2104460.8215099997 | 37.759318349579395 | -122.38948762214899 | (37.7593183495794, -122.389487622149) |
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");