trees
3,247 rows where qSpecies_id = 22 sorted by Zip Codes descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes ▲ | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9176 | 176544 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 7 | : | Tree | Private 2 | 1 | Width 3ft | 5992259.97775 | 2086836.1982 | 37.7096104062721 | -122.468531792305 | (37.7096104062721, -122.468531792305) | 9 | 8 | 4 | 64 | 24 | |||
| 9489 | 219078 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 23 Bright St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5993714.36027 | 2087390.34861 | 37.7112158768855 | -122.463545422096 | (37.7112158768855, -122.463545422096) | 9 | 8 | 4 | 64 | 24 | |||
| 20111 | 1217 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 3501 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/2016 12:00:00 AM | 3 | 3x3 | 5993695.72185 | 2087421.09824 | 37.7112992341463 | -122.463612070865 | (37.7112992341463, -122.463612070865) | 9 | 8 | 4 | 64 | 24 | ||
| 34238 | 1283 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 3995X Alemany Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 10x10 | 5992081.50866 | 2087171.04221 | 37.7105194967412 | -122.469172961285 | (37.7105194967412, -122.469172961285) | 9 | 8 | 4 | 64 | 24 | |||
| 52611 | 219077 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 494 Victoria St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993267.6387 | 2090426.62452 | 37.7195270128342 | -122.465309800205 | (37.7195270128342, -122.465309800205) | 9 | 8 | 6 | 64 | 24 | |||
| 84647 | 176542 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 5 | : | Tree | Private 2 | 1 | Width 3ft | 5992312.69836 | 2086838.42699 | 37.7096195712459 | -122.468349744347 | (37.7096195712459, -122.468349744347) | 9 | 8 | 4 | 64 | 24 | |||
| 91869 | 219079 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2674 Ocean Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5990725.25402 | 2095140.06488 | 37.7323219940584 | -122.474441593613 | (37.7323219940584, -122.474441593613) | 1 | 8 | 4 | 64 | 40 | |||
| 93251 | 176543 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 6 | : | Tree | Private 2 | 1 | Width 3ft | 5992283.95996 | 2086838.07777 | 37.7096169524177 | -122.468449043003 | (37.7096169524177, -122.468449043003) | 9 | 8 | 4 | 64 | 24 | |||
| 94025 | 52978 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 554 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48958 | 5993806.42000954 | 2090906.17268529 | 37.7208747934184 | -122.463482227177 | (37.7208747934184, -122.463482227177) | 9 | 8 | 6 | 64 | 24 | ||
| 116754 | 107580 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992406.39157 | 2086830.73395 | 37.7096038592127 | -122.468025367885 | (37.7096038592127, -122.468025367885) | 9 | 8 | 4 | 64 | 24 | ||
| 118561 | 176541 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 213 Saint Charles Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5992061.3412 | 2087065.50702 | 37.7102285570869 | -122.469234987506 | (37.7102285570869, -122.469234987506) | 9 | 8 | 4 | 64 | 24 | |||
| 131713 | 52974 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 561 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48955 | 5993754.8623302 | 2090944.41829471 | 37.7209768359267 | -122.463663219473 | (37.7209768359267, -122.463663219473) | 9 | 8 | 6 | 64 | 24 | ||
| 153512 | 107579 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992416.91174 | 2086830.03613 | 37.7096025506984 | -122.467988957943 | (37.7096025506984, -122.467988957943) | 9 | 8 | 4 | 64 | 24 | ||
| 175627 | 107582 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992337.55751 | 2086836.47342 | 37.7096156430274 | -122.46826368552 | (37.7096156430274, -122.46826368552) | 9 | 8 | 4 | 64 | 24 | ||
| 182443 | 107581 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992393.94682 | 2086830.99569 | 37.7096038591978 | -122.468068397753 | (37.7096038591978, -122.468068397753) | 9 | 8 | 4 | 64 | 24 | ||
| 194343 | 265044 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1250 Eucalyptus Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
| 194346 | 265043 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1250 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
| 321 | 219060 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 221 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6000072.85251 | 2094491.10418 | 37.731077247812 | -122.442078323383 | (37.731077247812, -122.442078323383) | 9 | 7 | 4 | 63 | 40 | |||
| 2836 | 219119 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Brompton Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002030.49307 | 2095074.13161 | 37.7327894760326 | -122.435352122012 | (37.7327894760326, -122.435352122012) | 9 | 7 | 5 | 63 | 40 | |||
| 3595 | 219121 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Brompton Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002025.50342 | 2095049.38545 | 37.7327212453836 | -122.435367602937 | (37.7327212453836, -122.435367602937) | 9 | 7 | 5 | 63 | 40 | |||
| 3744 | 39401 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
| 5509 | 226294 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 410 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003702.40419 | 2096529.69179 | 37.7368809219105 | -122.429675682206 | (37.7368809219105, -122.429675682206) | 2 | 7 | 5 | 63 | 7 | |||
| 8720 | 67850 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 485 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1993 12:00:00 AM | Permit Number 31520 | 6002735.666769 | 2098756.82734478 | 37.7429413329054 | -122.433177202226 | (37.7429413329054, -122.433177202226) | 2 | 7 | 5 | 63 | 22 | ||
| 12736 | 219124 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 70 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6001597.50006 | 2094955.90851 | 37.7324402629898 | -122.436840624998 | (37.7324402629898, -122.436840624998) | 9 | 7 | 5 | 63 | 40 | |||
| 13365 | 225615 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 53 Wilder St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002593.03805 | 2095538.61045 | 37.73409676026 | -122.43344044482 | (37.73409676026, -122.43344044482) | 2 | 7 | 5 | 63 | 7 | |||
| 13610 | 247805 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 488 30th St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6003450.91279 | 2098365.25645 | 37.7419067175277 | -122.430676143802 | (37.7419067175277, -122.430676143802) | 2 | 7 | 5 | 63 | 22 | |||
| 15669 | 226292 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 537 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1991 12:00:00 AM | 3 | Width 2ft | Permit Number 29820 | 6003335.67331 | 2095877.19361 | 37.7350685379825 | -122.430897079359 | (37.7350685379825, -122.430897079359) | 2 | 7 | 5 | 63 | 7 | |
| 16234 | 226133 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 454 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002986.00239 | 2098632.64023 | 37.74261454154 | -122.432302743977 | (37.74261454154, -122.432302743977) | 2 | 7 | 5 | 63 | 22 | |||
| 17318 | 39391 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
| 18383 | 226290 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 428 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003776.37855 | 2096273.85299 | 37.7361826352278 | -122.429401681261 | (37.7361826352278, -122.429401681261) | 2 | 7 | 5 | 63 | 7 | |||
| 18617 | 27422 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3X3 | 6004589.1156 | 2099049.54321 | 37.7438500301684 | -122.426789326068 | (37.7438500301684, -122.426789326068) | 2 | 7 | 5 | 63 | 22 | |||
| 20683 | 226152 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 335 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6004330.10643 | 2100124.74068 | 37.7467876269666 | -122.427761513008 | (37.7467876269666, -122.427761513008) | 2 | 7 | 5 | 63 | 22 | |||
| 21059 | 30335 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 601 29th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/1956 12:00:00 AM | 2 | Permit Number 24 | 6002625.81177 | 2098862.65496 | 37.743225678518 | -122.433564611513 | (37.743225678518, -122.433564611513) | 2 | 7 | 5 | 63 | 7 | ||
| 22386 | 247804 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 488 30th St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6003501.31638 | 2098369.19661 | 37.7419203917212 | -122.430502145662 | (37.7419203917212, -122.430502145662) | 2 | 7 | 5 | 63 | 22 | |||
| 24058 | 34407 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 151 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38155 | 6004576.44969274 | 2097521.36031941 | 37.7396532725762 | -122.426724317666 | (37.7396532725762, -122.426724317666) | 2 | 7 | 5 | 63 | 7 | ||
| 24932 | 4191 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3859 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004825.90537 | 2100443.74238 | 37.7476915661309 | -122.426069792902 | (37.7476915661309, -122.426069792902) | 2 | 4 | 5 | 63 | 22 | |||
| 26417 | 66310 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 136 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29425 | 6001332.72327258 | 2095407.42415394 | 37.7336649686266 | -122.43778834571 | (37.7336649686266, -122.43778834571) | 9 | 7 | 5 | 63 | 40 | ||
| 27395 | 226259 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1507 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002035.74564 | 2099652.61089 | 37.7453612149571 | -122.435661406069 | (37.7453612149571, -122.435661406069) | 2 | 7 | 5 | 63 | 22 | |||
| 28883 | 34868 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 448 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2007 12:00:00 AM | 3x3 | Permit Number 49951 | 6003547.62609569 | 2096418.61112327 | 37.7365671542892 | -122.430202896046 | (37.7365671542892, -122.430202896046) | 2 | 7 | 5 | 63 | 7 | ||
| 29447 | 5700 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1574 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/30/1999 12:00:00 AM | 6 | 3X3 | 6005230.11909 | 2099176.77076 | 37.7442355893055 | -122.42458193203 | (37.7442355893055, -122.42458193203) | 2 | 7 | 5 | 63 | 22 | ||
| 29930 | 39397 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
| 30851 | 228335 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 61 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004305.62503 | 2097893.91637 | 37.7406609109864 | -122.427687250574 | (37.7406609109864, -122.427687250574) | 2 | 7 | 5 | 63 | 7 | |||
| 31567 | 226115 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 318 29th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6004548.44652 | 2099013.28366 | 37.7437481702562 | -122.426927368409 | (37.7437481702562, -122.426927368409) | 2 | 7 | 5 | 63 | 22 | |||
| 31685 | 226123 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 312 29th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004355.16899 | 2099002.5391 | 37.7437077376349 | -122.427594910873 | (37.7437077376349, -122.427594910873) | 2 | 7 | 5 | 63 | 22 | |||
| 33871 | 226127 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 444 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003666.50944 | 2098964.92336 | 37.743565476581 | -122.429973446837 | (37.743565476581, -122.429973446837) | 2 | 7 | 5 | 63 | 22 | |||
| 34467 | 226301 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 237 Miguel St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004214.52371 | 2096736.4573 | 37.7374776382742 | -122.427919787382 | (37.7374776382742, -122.427919787382) | 2 | 7 | 5 | 63 | 7 | |||
| 35104 | 119889 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 312 29th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6004404 | 2099018 | 37.7437529516404 | -122.427427166112 | (37.7437529516404, -122.427427166112) | 2 | 7 | 5 | 63 | 22 | |||
| 36391 | 228339 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 527 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003202.64576 | 2098317.85279 | 37.7417624896535 | -122.431531186829 | (37.7417624896535, -122.431531186829) | 2 | 7 | 5 | 63 | 7 | |||
| 36467 | 219120 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Brompton Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002027.68527 | 2095060.20973 | 37.7327510902846 | -122.435360833759 | (37.7327510902846, -122.435360833759) | 9 | 7 | 5 | 63 | 40 | |||
| 37589 | 30334 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 601 29th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/1956 12:00:00 AM | 4 | Permit Number 24 | 6002605.63749 | 2098861.8554 | 37.7432223384343 | -122.433634311668 | (37.7432223384343, -122.433634311668) | 2 | 7 | 5 | 63 | 7 | ||
| 39018 | 219127 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 137 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001368.15711 | 2095390.11838 | 37.7336194657632 | -122.437664601839 | (37.7336194657632, -122.437664601839) | 9 | 7 | 5 | 63 | 40 | |||
| 41278 | 66312 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 143 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29427 | 6001377.41574875 | 2095374.46813255 | 37.7335770202313 | -122.437631471673 | (37.7335770202313, -122.437631471673) | 9 | 7 | 5 | 63 | 40 | ||
| 41500 | 226116 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 318 29th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6004526.78894 | 2099012.09332 | 37.7437436772314 | -122.427002170425 | (37.7437436772314, -122.427002170425) | 2 | 7 | 5 | 63 | 22 | |||
| 42091 | 219138 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 10 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002033.17044 | 2094872.15307 | 37.7322350413038 | -122.435328423075 | (37.7322350413038, -122.435328423075) | 9 | 7 | 4 | 63 | 40 | |||
| 42158 | 43568 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 601 29TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2000 12:00:00 AM | Permit Number 43230 | 6002630.6 | 2098839.9 | 37.7431634703749 | -122.43354642925 | (37.7431634703749, -122.43354642925) | 2 | 7 | 5 | 63 | 7 | |||
| 43014 | 226155 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 226 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004888.5325 | 2100201.66833 | 37.74703042592 | -122.425836003353 | (37.74703042592, -122.425836003353) | 2 | 7 | 5 | 63 | 22 | |||
| 46725 | 219131 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 9 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001965.03109 | 2094900.87748 | 37.7323100420584 | -122.435566050051 | (37.7323100420584, -122.435566050051) | 9 | 7 | 4 | 63 | 40 | |||
| 46850 | 219122 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Brompton Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002020.04993 | 2095030.436 | 37.7326689048259 | -122.435385101949 | (37.7326689048259, -122.435385101949) | 9 | 7 | 5 | 63 | 40 | |||
| 47031 | 226137 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1405 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6003946.10356 | 2100057.68883 | 37.7465817883148 | -122.429084577601 | (37.7465817883148, -122.429084577601) | 2 | 7 | 5 | 63 | 22 | |||
| 47544 | 46348 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1507 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/2002 12:00:00 AM | Permit Number 44593 | 6002034.30683113 | 2099698.46160484 | 37.7454870285073 | -122.435669660946 | (37.7454870285073, -122.435669660946) | 2 | 7 | 5 | 63 | 22 | |||
| 47676 | 226300 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 237 Miguel St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004226.85436 | 2096722.26162 | 37.7374393577311 | -122.427876143295 | (37.7374393577311, -122.427876143295) | 2 | 7 | 5 | 63 | 7 | |||
| 48021 | 46347 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1507 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/2002 12:00:00 AM | Permit Number 44593 | 6002034.30683113 | 2099698.46160484 | 37.7454870285073 | -122.435669660946 | (37.7454870285073, -122.435669660946) | 2 | 7 | 5 | 63 | 22 | |||
| 48860 | 31103 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 420 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34833 | 5999457.19750616 | 2094476.41110403 | 37.7310017996631 | -122.444205686044 | (37.7310017996631, -122.444205686044) | 9 | 7 | 4 | 63 | 40 | ||
| 48984 | 226135 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1477 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6003970.65831 | 2099661.65914 | 37.7454957724184 | -122.428971439298 | (37.7454957724184, -122.428971439298) | 2 | 7 | 5 | 63 | 22 | |||
| 51190 | 226298 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 595 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002933.74863 | 2095882.33376 | 37.7350598703022 | -122.432287042711 | (37.7350598703022, -122.432287042711) | 2 | 7 | 5 | 63 | 7 | |||
| 53124 | 226151 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 371 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004135.1252 | 2100114.7332 | 37.7467491170836 | -122.428435026076 | (37.7467491170836, -122.428435026076) | 2 | 7 | 5 | 63 | 22 | |||
| 53229 | 64416 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 18 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50677 | 6003642.17980217 | 2098229.65792649 | 37.7415452293262 | -122.430005134049 | (37.7415452293262, -122.430005134049) | 2 | 7 | 5 | 63 | 7 | ||
| 54657 | 60664 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 249 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20298 | 6004405.0967778 | 2096932.39684696 | 37.7380264232829 | -122.427274839887 | (37.7380264232829, -122.427274839887) | 2 | 7 | 5 | 63 | 7 | ||
| 55544 | 226131 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 485 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002839.72641 | 2098580.41414 | 37.7424628456797 | -122.4328047932 | (37.7424628456797, -122.4328047932) | 2 | 7 | 5 | 63 | 22 | |||
| 57027 | 219128 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 132 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001338.63173 | 2095424.72317 | 37.7337128036929 | -122.437769157037 | (37.7337128036929, -122.437769157037) | 9 | 7 | 5 | 63 | 40 | |||
| 57683 | 226278 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 615 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002481.58949 | 2100031.65227 | 37.7464272875011 | -122.434146844309 | (37.7464272875011, -122.434146844309) | 2 | 7 | 5 | 63 | 22 | |||
| 57975 | 27419 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3X3 | 6004586.23606 | 2099113.60086 | 37.7440257549822 | -122.426803843839 | (37.7440257549822, -122.426803843839) | 2 | 7 | 5 | 63 | 22 | |||
| 58386 | 226128 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 359 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6003584.37502 | 2099202.86276 | 37.7442141512667 | -122.430274419341 | (37.7442141512667, -122.430274419341) | 2 | 7 | 5 | 63 | 22 | |||
| 58917 | 31098 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 106 Baden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1995 12:00:00 AM | 3x3 | Permit Number 34828 | 6000773.52308358 | 2094378.43446276 | 37.7308077879844 | -122.439647916066 | (37.7308077879844, -122.439647916066) | 9 | 7 | 4 | 63 | 40 | ||
| 62867 | 49464 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1598REVISED Dolores St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2004 12:00:00 AM | Permit Number 46392 | 6005257.3535793 | 2099024.34927744 | 37.7438186126757 | -122.424476921386 | (37.7438186126757, -122.424476921386) | 2 | 7 | 5 | 63 | 22 | |||
| 64418 | 31097 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 106 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 7 | 3x3 | Permit Number 34828 | 6000767.82803 | 2094431.09703 | 37.730952063077 | -122.439671378748 | (37.730952063077, -122.439671378748) | 9 | 7 | 4 | 63 | 40 |
| 64832 | 246427 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 464 Duncan St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6003499.77628 | 2099836.70737 | 37.74594974928 | -122.430612163326 | (37.74594974928, -122.430612163326) | 2 | 7 | 5 | 63 | 22 | |||
| 65538 | 225619 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 51 Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002034.44576 | 2095916.26865 | 37.7351020152473 | -122.435398676334 | (37.7351020152473, -122.435398676334) | 2 | 7 | 5 | 63 | 7 | |||
| 66334 | 219125 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 149 Hamerton Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 6001356.75125 | 2095315.06653 | 37.7334127421955 | -122.437698661869 | (37.7334127421955, -122.437698661869) | 9 | 7 | 5 | 63 | 40 | |||
| 67995 | 64306 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1567 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/10/1988 12:00:00 AM | Permit Number 25117 | 6003997.14327648 | 2099150.8552368 | 37.7440947219453 | -122.428843449225 | (37.7440947219453, -122.428843449225) | 2 | 7 | 5 | 63 | 22 | ||
| 68015 | 225614 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 53 Wilder St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002564.50559 | 2095546.11614 | 37.7341157503395 | -122.433539626564 | (37.7341157503395, -122.433539626564) | 2 | 7 | 5 | 63 | 7 | |||
| 68239 | 38532 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2473 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/1998 12:00:00 AM | Permit Number 40514 | 6002133.61382428 | 2097290.82388735 | 37.7388818577796 | -122.435154099858 | (37.7388818577796, -122.435154099858) | 2 | 7 | 5 | 63 | 7 | |||
| 68378 | 226118 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 318 29th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6004484.56829 | 2099009.69049 | 37.7437346921153 | -122.427147988298 | (37.7437346921153, -122.427147988298) | 2 | 7 | 5 | 63 | 22 | |||
| 68424 | 5714 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1632 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/05/2012 12:00:00 AM | 3 | 4X4 | 6005246.5883 | 2098847.74349 | 37.7433330854531 | -122.424501585686 | (37.7433330854531, -122.424501585686) | 2 | 7 | 5 | 63 | 22 | ||
| 68804 | 226119 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 318 29th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6004463.48042 | 2099009.57947 | 37.7437331947341 | -122.427220897231 | (37.7437331947341, -122.427220897231) | 2 | 7 | 5 | 63 | 22 | |||
| 70021 | 119894 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 300X 29th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6004302 | 2098976 | 37.7436318598049 | -122.427776865938 | (37.7436318598049, -122.427776865938) | 2 | 7 | 5 | 63 | 22 | |||
| 70700 | 228342 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 225 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004124.16137 | 2097587.45021 | 37.739809158568 | -122.428292845936 | (37.739809158568, -122.428292845936) | 2 | 7 | 5 | 63 | 7 | |||
| 71450 | 226260 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1507 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002035.30873 | 2099665.07166 | 37.7453954044834 | -122.435663808151 | (37.7453954044834, -122.435663808151) | 2 | 7 | 5 | 63 | 22 | |||
| 71987 | 226129 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 468 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2016 12:00:00 AM | 9 | Width 3ft | 6002897.69632 | 2099218.59818 | 37.7442184383445 | -122.432649927259 | (37.7442184383445, -122.432649927259) | 2 | 7 | 5 | 63 | 22 | ||
| 72017 | 242841 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3820 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781070 | 6005022.59932 | 2100499.88784 | 37.7478568435312 | -122.425393630421 | (37.7478568435312, -122.425393630421) | 2 | 4 | 5 | 63 | 22 | |
| 72483 | 225618 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 10 Lippard Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002076.31903 | 2096053.65466 | 37.7354816235692 | -122.435263729452 | (37.7354816235692, -122.435263729452) | 2 | 7 | 5 | 63 | 7 | |||
| 72512 | 94675 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 595 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53811 | 6002917 | 2095871 | 37.735027800708 | -122.432344139463 | (37.735027800708, -122.432344139463) | 2 | 7 | 5 | 63 | 7 | |
| 73097 | 226303 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 53 Wilder St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002497.61716 | 2095567.9464 | 37.7341718959041 | -122.433772440342 | (37.7341718959041, -122.433772440342) | 2 | 7 | 5 | 63 | 7 | |||
| 73694 | 226258 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 752 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6001674.65272 | 2099731.86693 | 37.7455583166542 | -122.436915677038 | (37.7455583166542, -122.436915677038) | 2 | 7 | 5 | 63 | 22 | |||
| 73904 | 59630 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 236 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/1981 12:00:00 AM | 15 | 4x4 | Permit Number 19038 | 6004970.88725465 | 2100208.28442938 | 37.7470532458687 | -122.42555169825 | (37.7470532458687, -122.42555169825) | 2 | 7 | 5 | 63 | 22 | |
| 73944 | 119903 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 300X 29th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6004302 | 2098976 | 37.7436318598049 | -122.427776865938 | (37.7436318598049, -122.427776865938) | 2 | 7 | 5 | 63 | 22 | |||
| 73980 | 228333 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1860 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004567.46714 | 2097876.94226 | 37.7406291118418 | -122.426780691669 | (37.7406291118418, -122.426780691669) | 2 | 7 | 5 | 63 | 7 | |||
| 74509 | 82014 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1407 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2008 12:00:00 AM | 3x3 | Permit Number 50371 | 6003944.41648268 | 2100082.53235866 | 37.7466499073837 | -122.429092182393 | (37.7466499073837, -122.429092182393) | 2 | 7 | 5 | 63 | 22 | ||
| 74894 | 228337 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1768 Sanchez St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 6003964.05943 | 2097961.58291 | 37.740827380874 | -122.428873076831 | (37.740827380874, -122.428873076831) | 2 | 7 | 5 | 63 | 7 | |||
| 75114 | 119883 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 312 29th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6004404 | 2099018 | 37.7437529516404 | -122.427427166112 | (37.7437529516404, -122.427427166112) | 2 | 7 | 5 | 63 | 22 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );