trees
3,247 rows where qSpecies_id = 22 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
135012 | 128962 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 280 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6007805.76355 | 2112380.63305 | 37.7806354603093 | -122.416611050055 | (37.7806354603093, -122.416611050055) | 7 | 10 | 9 | 28852 | 36 | |||
137420 | 33661 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 483 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | 2 | Permit Number 37749 | 6005107.1966 | 2110751.602 | 37.7760104013227 | -122.425830703288 | (37.7760104013227, -122.425830703288) | 7 | 9 | 11 | 28852 | 10 | |
138038 | 94107 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 311X Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006285.41191 | 2111071.65635 | 37.7769557051769 | -122.4217776786 | (37.7769557051769, -122.4217776786) | 7 | 9 | 11 | 28852 | 10 | |
142732 | 128954 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008488.64785 | 2112470.36476 | 37.7809202243324 | -122.414254969316 | (37.7809202243324, -122.414254969316) | 7 | 10 | 9 | 28852 | 36 | |||
143281 | 119703 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 47 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005657.12364045 | 2109394.65582136 | 37.772315616937 | -122.423831849588 | (37.772315616937, -122.423831849588) | 7 | 9 | 11 | 28852 | 10 | |||||
144003 | 187686 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 388 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2017 12:00:00 AM | 3 | 6005900.60365 | 2111761.43845 | 37.7788279713562 | -122.423157892653 | (37.7788279713562, -122.423157892653) | 7 | 9 | 11 | 28852 | 10 | |||
145779 | 94117 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 200X Linden St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006339.5 | 2111012.4 | 37.7767960515681 | -122.421586361388 | (37.7767960515681, -122.421586361388) | 7 | 9 | 11 | 28852 | 10 | |
148499 | 228322 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 10 Rose St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006240.81173 | 2109884.47213 | 37.7736934684005 | -122.421847615292 | (37.7736934684005, -122.421847615292) | 7 | 9 | 11 | 28852 | 10 | |||
149218 | 128950 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 400 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6007230.35075 | 2112413.98201 | 37.7806946500757 | -122.418604048452 | (37.7806946500757, -122.418604048452) | 7 | 9 | 9 | 28852 | 36 | |||
150041 | 128979 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 McAllister St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008469.91366 | 2112412.28863 | 37.7807597088309 | -122.414315669952 | (37.7807597088309, -122.414315669952) | 7 | 10 | 9 | 28852 | 36 | |||
151370 | 128987 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 Linden St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6006326.1067 | 2110944.98598 | 37.7766101937484 | -122.421627903705 | (37.7766101937484, -122.421627903705) | 7 | 9 | 11 | 28852 | 10 | |||
151476 | 128976 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 McAllister St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008353.03797 | 2112399.2385 | 37.7807173103084 | -122.41471907703 | (37.7807173103084, -122.41471907703) | 7 | 10 | 9 | 28852 | 36 | |||
151590 | 128949 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 400 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6007232.6125 | 2112400.8275 | 37.7806586583063 | -122.41859529086 | (37.7806586583063, -122.41859529086) | 7 | 9 | 9 | 28852 | 36 | |||
157999 | 142810 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 341 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6007661.3337 | 2112479.4889 | 37.7808987707617 | -122.417117710098 | (37.7808987707617, -122.417117710098) | 7 | 9 | 9 | 28852 | 36 | |||
159146 | 128948 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 880 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6005758.95364 | 2112789.64436 | 37.7816431785186 | -122.423721043418 | (37.7816431785186, -122.423721043418) | 7 | 9 | 11 | 28852 | 41 | |||
159484 | 128971 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 388 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2017 12:00:00 AM | 3 | Width 3ft | 6005955.06013 | 2111776.3287 | 37.7788719293368 | -122.422970564553 | (37.7788719293368, -122.422970564553) | 7 | 9 | 11 | 28852 | 10 | ||
159640 | 228323 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 10 Rose St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006226.54275 | 2109882.46757 | 37.7736871596597 | -122.421896831567 | (37.7736871596597, -122.421896831567) | 7 | 9 | 11 | 28852 | 10 | |||
159842 | 98962 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 302x Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | ||||
163127 | 128969 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 380 Fulton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005996.75274 | 2111782.00879 | 37.7788898779939 | -122.422826736873 | (37.7788898779939, -122.422826736873) | 7 | 9 | 11 | 28852 | 10 | |||
164413 | 226111 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 380 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6004762.10493 | 2109870.45399 | 37.7735714762646 | -122.426961695535 | (37.7735714762646, -122.426961695535) | 7 | 9 | 11 | 28852 | 10 | |||
165749 | 128945 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 880 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6005819.68103 | 2112797.22294 | 37.7816674152711 | -122.423511494163 | (37.7816674152711, -122.423511494163) | 7 | 9 | 11 | 28852 | 41 | |||
166114 | 128977 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 McAllister St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008381.16446 | 2112403.1567 | 37.7807296489991 | -122.41462205098 | (37.7807296489991, -122.41462205098) | 7 | 10 | 9 | 28852 | 36 | |||
166253 | 110046 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 288 Eddy St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 2 | 6009043.83179 | 2113590.50747 | 37.7840270384566 | -122.412413507572 | (37.7840270384566, -122.412413507572) | 14 | 10 | 9 | 28852 | 36 | ||||
166629 | 119704 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 47 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005657.12364045 | 2109394.65582136 | 37.772315616937 | -122.423831849588 | (37.772315616937, -122.423831849588) | 7 | 9 | 11 | 28852 | 10 | |||||
177649 | 35469 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 430 Polk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/1998 12:00:00 AM | Permit Number 38886 | 6007237.08907724 | 2112375.34283194 | 37.7805889355944 | -122.418577996505 | (37.7805889355944, -122.418577996505) | 7 | 9 | 9 | 28852 | 36 | |||
179319 | 109789 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 380 FULTON ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 6005937 | 2111766 | 37.7788425501417 | -122.423032307462 | (37.7788425501417, -122.423032307462) | 7 | 9 | 11 | 28852 | 10 | ||
180630 | 128986 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 Linden St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6006340.65697 | 2110948.65096 | 37.7766210773467 | -122.421577830361 | (37.7766210773467, -122.421577830361) | 7 | 9 | 11 | 28852 | 10 | |||
192328 | 128959 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 190 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008244.86904 | 2112441.68801 | 37.7808277884019 | -122.415096292278 | (37.7808277884019, -122.415096292278) | 7 | 10 | 9 | 28852 | 36 | |||
192477 | 128963 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 280 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6007777.87724 | 2112376.8602 | 37.7806235325864 | -122.416707255053 | (37.7806235325864, -122.416707255053) | 7 | 10 | 9 | 28852 | 36 | |||
193646 | 128970 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 380 Fulton St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005984.29851 | 2111779.35952 | 37.7788819010298 | -122.422869632726 | (37.7788819010298, -122.422869632726) | 7 | 9 | 11 | 28852 | 10 | |||
194148 | 228331 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 50 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006613.24139 | 2110474.94524 | 37.7753357617652 | -122.420601244852 | (37.7753357617652, -122.420601244852) | 7 | 9 | 11 | 28852 | 10 | |||
1649 | 92526 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 275 10th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2009 12:00:00 AM | 3x3 | Permit Number 52874 | 6008743 | 2109634 | 37.7731465224788 | -122.413174412357 | (37.7731465224788, -122.413174412357) | 8 | 2 | 9 | 28853 | 34 | ||
2367 | 226104 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 269 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005509.798 | 2107472.48259 | 37.7670294722636 | -122.424204733868 | (37.7670294722636, -122.424204733868) | 8 | 4 | 5 | 28853 | 19 | |||
2416 | 192496 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Kansas St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011473.84765 | 2106919.34293 | 37.765845622699 | -122.403536974176 | (37.765845622699, -122.403536974176) | 8 | 3 | 8 | 28853 | 20 | |||
2637 | 262319 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1616 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011556 | 2107033 | 37.7661622878471 | -122.403260820888 | (37.7661622878471, -122.403260820888) | 8 | 2 | 8 | 28853 | 20 | ||||
5830 | 98280 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 66 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2012 12:00:00 AM | 2 | Permit Number 58649 | 6008148.55904 | 2110896.00071 | 37.776578287595 | -122.415320022909 | (37.776578287595, -122.415320022909) | 8 | 2 | 9 | 28853 | 34 | ||
8103 | 108711 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2000-2038X 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773095 | 6011373.53842 | 2106528.51703 | 37.7647668994048 | -122.40385642054 | (37.7647668994048, -122.40385642054) | 8 | 3 | 8 | 28853 | 20 |
8132 | 19305 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 345 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/1990 12:00:00 AM | 20 | 3X3 | 6010549.63293 | 2110708.85281 | 37.7761990776491 | -122.407000778664 | (37.7761990776491, -122.407000778664) | 14 | 2 | 9 | 28853 | 34 | ||
8996 | 98282 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 66 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2012 12:00:00 AM | 3 | Permit Number 58649 | 6008179.30272 | 2110863.50432 | 37.7764907880679 | -122.415211370411 | (37.7764907880679, -122.415211370411) | 8 | 2 | 9 | 28853 | 34 | ||
9938 | 200875 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1699 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6011598.7362 | 2106957.8779 | 37.7659584061817 | -122.403107719273 | (37.7659584061817, -122.403107719273) | 8 | 3 | 8 | 28853 | 20 | |||
13047 | 70677 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 110 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6010274.94764 | 2110617.18135 | 37.7759319943133 | -122.407944528121 | (37.7759319943133, -122.407944528121) | 8 | 2 | 9 | 28853 | 34 | |||
14185 | 75407 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 194X Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 5x5 | 6010525.12192 | 2111307.03338 | 37.7778401704149 | -122.407127744063 | (37.7778401704149, -122.407127744063) | 14 | 2 | 9 | 28853 | 34 | |||
14850 | 98281 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 66 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2012 12:00:00 AM | 3 | Permit Number 58649 | 6008165.69574 | 2110879.12634 | 37.7765329177037 | -122.415259547114 | (37.7765329177037, -122.415259547114) | 8 | 2 | 9 | 28853 | 34 | ||
15552 | 149669 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1701 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6011308.34689 | 2106942.89259 | 37.765901038939 | -122.404111067171 | (37.765901038939, -122.404111067171) | 8 | 3 | 8 | 28853 | 20 | |||
16077 | 201863 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1220 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6009514.9493 | 2110197.5964 | 37.7747373334401 | -122.410543934579 | (37.7747373334401, -122.410543934579) | 8 | 2 | 9 | 28853 | 34 | |||
16322 | 41156 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 455 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2004 12:00:00 AM | Permit Number 47674 | 6009883.81375688 | 2109165.06157558 | 37.7719229056173 | -122.409195075279 | (37.7719229056173, -122.409195075279) | 14 | 2 | 9 | 28853 | 34 | |||
17186 | 110519 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
17845 | 7420 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1095 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6010426.8513 | 2110979.2324 | 37.7769346055078 | -122.407444582017 | (37.7769346055078, -122.407444582017) | 14 | 2 | 9 | 28853 | 34 | |||
18037 | 7422 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301X 07TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/1991 12:00:00 AM | 8 | 6010388 | 2110913 | 37.7767505721368 | -122.407574310337 | (37.7767505721368, -122.407574310337) | 14 | 2 | 9 | 28853 | 34 | |||
18980 | 48384 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | 5 | Permit Number 45774 | 6011713.07765 | 2106631.21617 | 37.7650678512362 | -122.402689258803 | (37.7650678512362, -122.402689258803) | 8 | 3 | 8 | 28853 | 20 | ||
19265 | 44239 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 317 Harriet St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2001 12:00:00 AM | Permit Number 43677 | 6011781.7513621 | 2110406.95147967 | 37.7754389967998 | -122.402717284978 | (37.7754389967998, -122.402717284978) | 14 | 2 | 9 | 28853 | 34 | |||
19583 | 200954 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1346 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6009074.4307 | 2109779.3172 | 37.7735641303875 | -122.412038217803 | (37.7735641303875, -122.412038217803) | 8 | 2 | 9 | 28853 | 34 | |||
19811 | 226102 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 275 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005512.33391 | 2107434.66841 | 37.7669257867307 | -122.424193272927 | (37.7669257867307, -122.424193272927) | 8 | 4 | 5 | 28853 | 19 | |||
20114 | 192489 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011488.83741 | 2106592.25565 | 37.7649483520018 | -122.403462113682 | (37.7649483520018, -122.403462113682) | 8 | 3 | 8 | 28853 | 20 | |||
20412 | 190617 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 54 Dore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008964.74545 | 2109712.92182 | 37.7733756695717 | -122.412412942829 | (37.7733756695717, -122.412412942829) | 8 | 2 | 9 | 28853 | 34 | |||
21504 | 7423 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301X 07TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6010388 | 2110913 | 37.7767505721368 | -122.407574310337 | (37.7767505721368, -122.407574310337) | 14 | 2 | 9 | 28853 | 34 | |||
22637 | 192482 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1900 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6011685.81518 | 2106547.60662 | 37.7648367560319 | -122.402777672945 | (37.7648367560319, -122.402777672945) | 8 | 3 | 8 | 28853 | 20 | |||
23444 | 48373 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | 5 | Permit Number 45774 | 6011696.05112 | 2106912.09 | 37.7658381169537 | -122.402767904509 | (37.7658381169537, -122.402767904509) | 8 | 3 | 8 | 28853 | 20 | ||
23619 | 226019 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 56 Julian Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006378.4669 | 2107577.84319 | 37.7673677774203 | -122.42120761995 | (37.7673677774203, -122.42120761995) | 8 | 4 | 7 | 28853 | 19 | |||
23879 | 226016 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 64 Rosemont Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005106.72903 | 2107950.62066 | 37.7683195578191 | -122.425632922015 | (37.7683195578191, -122.425632922015) | 8 | 4 | 5 | 28853 | 19 | |||
24477 | 190540 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 592 Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012112.67331 | 2109181.65349 | 37.7720930789747 | -122.401486407477 | (37.7720930789747, -122.401486407477) | 14 | 2 | 9 | 28853 | 34 | |||
25058 | 251361 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010388 | 2110913 | 37.7767505721368 | -122.407574310337 | (37.7767505721368, -122.407574310337) | 14 | 2 | 9 | 28853 | 34 | ||||
25287 | 48366 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 29 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.7654100874921 | -122.402712708416 | (37.7654100874921, -122.402712708416) | 8 | 3 | 8 | 28853 | 20 | |||
25338 | 226022 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 56 Julian Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006383.2381 | 2107521.11548 | 37.767212285543 | -122.421187088414 | (37.767212285543, -122.421187088414) | 8 | 4 | 7 | 28853 | 19 | |||
26123 | 121445 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 8 McLea Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6010116.09698 | 2109300.5107 | 37.7723078280659 | -122.40840114272 | (37.7723078280659, -122.40840114272) | 14 | 2 | 9 | 28853 | 34 | |||
27607 | 91318 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Rhode Island St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745 | 2106547 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | 8 | 3 | 8 | 28853 | 20 | ||
27795 | 192485 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1900 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011601.20285 | 2106542.75873 | 37.7648187201252 | -122.403069985886 | (37.7648187201252, -122.403069985886) | 8 | 3 | 8 | 28853 | 20 | |||
29064 | 108722 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 375 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773094 | 6011765.77732 | 2106711.15345 | 37.765290283257 | -122.402512604068 | (37.765290283257, -122.402512604068) | 8 | 3 | 8 | 28853 | 20 |
29390 | 92527 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 275 10th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2009 12:00:00 AM | 3x3 | Permit Number 52874 | 6008743 | 2109634 | 37.7731465224788 | -122.413174412357 | (37.7731465224788, -122.413174412357) | 8 | 2 | 9 | 28853 | 34 | ||
29437 | 225982 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1498 Stevenson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006324.4752 | 2107949.79731 | 37.7683860312168 | -122.421420788048 | (37.7683860312168, -122.421420788048) | 8 | 4 | 7 | 28853 | 19 | |||
31361 | 226026 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 161 Erie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6006930.14138 | 2108179.50387 | 37.7690508811333 | -122.419342137339 | (37.7690508811333, -122.419342137339) | 8 | 4 | 7 | 28853 | 19 | |||
31726 | 51306 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 87 McLea Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2004 12:00:00 AM | 2 | Permit Number 47673 | 6010064.68289 | 2109219.48748 | 37.7720824777545 | -122.408573272949 | (37.7720824777545, -122.408573272949) | 14 | 2 | 9 | 28853 | 34 | ||
32736 | 30601 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 140 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | Permit Number 34568 | 6007766.12041799 | 2109892.83524287 | 37.7738023323227 | -122.416571913724 | (37.7738023323227, -122.416571913724) | 8 | 2 | 9 | 28853 | 19 | ||
33106 | 226024 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 56 Julian Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006384.40456 | 2107484.67305 | 37.7671122890184 | -122.421180465801 | (37.7671122890184, -122.421180465801) | 8 | 4 | 7 | 28853 | 19 | |||
33632 | 48389 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.7654100874921 | -122.402712708416 | (37.7654100874921, -122.402712708416) | 8 | 3 | 8 | 28853 | 20 | |||
33723 | 7403 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1052 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6010579.4997 | 2111206.152 | 37.7775662166508 | -122.40693251939 | (37.7775662166508, -122.40693251939) | 14 | 2 | 9 | 28853 | 34 | |||
33742 | 48382 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | 6 | Permit Number 45774 | 6011708.87985 | 2106683.73701 | 37.7652118272854 | -122.402707471892 | (37.7652118272854, -122.402707471892) | 8 | 3 | 8 | 28853 | 20 | ||
33842 | 7407 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1069 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6010545.93832 | 2111017.99974 | 37.7770477163815 | -122.407035354746 | (37.7770477163815, -122.407035354746) | 14 | 2 | 9 | 28853 | 34 | |||
33979 | 226001 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 30 Albion St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005770.63032 | 2107061.9113 | 37.7659168651886 | -122.423273365378 | (37.7659168651886, -122.423273365378) | 8 | 4 | 5 | 28853 | 19 | |||
34023 | 48387 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.7654100874921 | -122.402712708416 | (37.7654100874921, -122.402712708416) | 8 | 3 | 8 | 28853 | 20 | |||
34228 | 114296 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301X 07TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010388 | 2110913 | 37.7767505721368 | -122.407574310337 | (37.7767505721368, -122.407574310337) | 14 | 2 | 9 | 28853 | 34 | ||||
35942 | 192486 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1900 17th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011566.74314 | 2106540.99657 | 37.7648119572172 | -122.403189049845 | (37.7648119572172, -122.403189049845) | 8 | 3 | 8 | 28853 | 20 | |||
36687 | 91316 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Rhode Island St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745 | 2106547 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | 8 | 3 | 8 | 28853 | 20 | ||
37510 | 30602 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 140 11th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | Permit Number 34568 | 6007766.12041799 | 2109892.83524287 | 37.7738023323227 | -122.416571913724 | (37.7738023323227, -122.416571913724) | 8 | 2 | 9 | 28853 | 19 | ||
38027 | 200874 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1699 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6011568.3022 | 2106957.8779 | 37.7659567065587 | -122.40321298484 | (37.7659567065587, -122.40321298484) | 8 | 3 | 8 | 28853 | 20 | |||
41075 | 192491 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Kansas St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011485.87278 | 2106649.17474 | 37.7651044734182 | -122.403476372441 | (37.7651044734182, -122.403476372441) | 8 | 3 | 8 | 28853 | 20 | |||
41248 | 7413 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1095 FOLSOM ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6010437 | 2110913 | 37.7767533148188 | -122.407404803947 | (37.7767533148188, -122.407404803947) | 14 | 2 | 9 | 28853 | 34 | |||
42409 | 91313 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Rhode Island St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745 | 2106547 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | 8 | 3 | 8 | 28853 | 20 | ||
43350 | 190564 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1748 Alameda St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | Width 3ft | 6011532.83475 | 2107953.47602 | 37.7686884129717 | -122.403405708214 | (37.7686884129717, -122.403405708214) | 8 | 2 | 8 | 28853 | 20 | ||
43772 | 66761 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 80 Elgin Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2016 12:00:00 AM | 2 | Permit Number 769935 | 6005803.50133393 | 2108610.80958475 | 37.7701716256342 | -122.423269785266 | (37.7701716256342, -122.423269785266) | 8 | 2 | 5 | 28853 | 19 | ||
44151 | 121298 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 98x Elgin Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2016 12:00:00 AM | 3 | 3x3 | 6005790 | 2108524 | 37.7699325053292 | -122.423310314383 | (37.7699325053292, -122.423310314383) | 8 | 2 | 5 | 28853 | 19 | ||
44679 | 108720 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 375 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773094 | 6011766.25551 | 2106680.42507 | 37.7652059367253 | -122.40250878917 | (37.7652059367253, -122.40250878917) | 8 | 3 | 8 | 28853 | 20 |
44959 | 44241 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 317 Harriet St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2001 12:00:00 AM | Permit Number 43677 | 6011781.7513621 | 2110406.95147967 | 37.7754389967998 | -122.402717284978 | (37.7754389967998, -122.402717284978) | 14 | 2 | 9 | 28853 | 34 | |||
45048 | 226103 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 271 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005511.70464 | 2107457.77851 | 37.7669892060228 | -122.424197093228 | (37.7669892060228, -122.424197093228) | 8 | 4 | 5 | 28853 | 19 | |||
45156 | 192435 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 382 07th St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6010717.74453 | 2110532.78766 | 37.7757250495103 | -122.406406823243 | (37.7757250495103, -122.406406823243) | 14 | 2 | 9 | 28853 | 34 | |||
45312 | 190613 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 54 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6008875.97975 | 2109806.71525 | 37.7736282225947 | -122.412726629026 | (37.7736282225947, -122.412726629026) | 8 | 2 | 9 | 28853 | 34 | |||
45725 | 226031 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1335 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006984.84766 | 2107694.11221 | 37.767721191212 | -122.419118476853 | (37.767721191212, -122.419118476853) | 8 | 4 | 7 | 28853 | 19 | |||
46382 | 28511 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 328 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6011089.36896 | 2111375.99749 | 37.7780610903368 | -122.405180664217 | (37.7780610903368, -122.405180664217) | 14 | 2 | 9 | 28853 | 34 | |||
47177 | 192438 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 106 Langton St | 5 | : | Tree | Private 2 | 1 | Width 3ft | 6010203.33587 | 2110729.26042 | 37.7762357277411 | -122.408200159505 | (37.7762357277411, -122.408200159505) | 8 | 2 | 9 | 28853 | 34 | |||
49590 | 7378 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1000X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 45 | 3X3 | 6010884.8623 | 2111505.4176 | 37.7784050126686 | -122.40589724881 | (37.7784050126686, -122.40589724881) | 14 | 2 | 9 | 28853 | 34 |
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) );