trees
3,247 rows where qSpecies_id = 22 sorted by qSiteInfo 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7494 | 243413 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 77 Belgrave Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/12/2019 12:00:00 AM | 3 | 6x6 | Permit Number 781419 | 5998151.68157 | 2104894.95588 | 37.7595340204918 | -122.449469463666 | (37.7595340204918, -122.449469463666) | 15 | 5 | 11 | 28862 | 12 | |
16371 | 260999 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 77 Belgrave Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/12/2019 12:00:00 AM | 3 | 6x6 | Permit Number 781419 | 5998149.61527 | 2104897.27011 | 37.7595402565853 | -122.449476776674 | (37.7595402565853, -122.449476776674) | 15 | 5 | 11 | 28862 | 12 | |
21076 | 226269 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 601 Grand View Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 4ft | 6000052.32454 | 2101592.71128 | 37.7505754059276 | -122.442659008402 | (37.7505754059276, -122.442659008402) | 2 | 4 | 5 | 28862 | 22 | |||
21460 | 219112 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 130 Brentwood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5995677.34458 | 2095602.53866 | 37.7338775046316 | -122.457354631219 | (37.7338775046316, -122.457354631219) | 9 | 7 | 4 | 59 | 40 | |||
21681 | 192451 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2310 19th St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6010858.43231 | 2105104.61317 | 37.7608283895517 | -122.405537754389 | (37.7608283895517, -122.405537754389) | 10 | 3 | 8 | 28856 | 29 | |||
34825 | 129006 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 10 Fallon Pl | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6008915.40705 | 2118578.41421 | 37.7977154080083 | -122.413210643283 | (37.7977154080083, -122.413210643283) | 3 | 1 | 10 | 308 | 21 | ||||
37224 | 190381 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2350 20th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 8ft | 6011079.30934 | 2104645.54641 | 37.7595802429642 | -122.404741515334 | (37.7595802429642, -122.404741515334) | 10 | 3 | 8 | 28856 | 29 | |||
37809 | 228255 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 470 Liberty St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6003278.43337 | 2103915.98823 | 37.7571379513705 | -122.431668728243 | (37.7571379513705, -122.431668728243) | 2 | 4 | 5 | 28862 | 3 | |||
41174 | 129013 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 150 Francisco St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6010602.08919 | 2121361.05101 | 37.8054503923804 | -122.407570525278 | (37.8054503923804, -122.407570525278) | 3 | 1 | 10 | 308 | 23 | ||||
44172 | 124187 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 40 Almaden Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5995896.10311 | 2112493.62876 | 37.7802687106807 | -122.45782018279 | (37.7802687106807, -122.45782018279) | 11 | 6 | 2 | 54 | 16 | ||||
48248 | 190519 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 299 Bryant St | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6015412.94784 | 2114035.02216 | 37.785602934875 | -122.390409563945 | (37.785602934875, -122.390409563945) | 6 | 2 | 9 | 28855 | 6 | |||
48594 | 192472 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 654 Minnesota St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6015145.36132 | 2105441.65157 | 37.7619925996904 | -122.39073459873 | (37.7619925996904, -122.39073459873) | 10 | 3 | 8 | 28856 | 29 | |||
50106 | 228243 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 396 Cumberland St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6003155.66776 | 2104492.39069 | 37.758713655324 | -122.432134460153 | (37.758713655324, -122.432134460153) | 2 | 4 | 5 | 28862 | 3 | |||
51106 | 219114 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 409 Bella Vista Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5997404.49541 | 2096329.01275 | 37.7359712783432 | -122.451435758472 | (37.7359712783432, -122.451435758472) | 9 | 7 | 4 | 59 | 40 | |||
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 | |||
59637 | 190365 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1401 25th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6014443.68802 | 2101979.23692 | 37.7524465992337 | -122.392919179687 | (37.7524465992337, -122.392919179687) | 10 | 3 | 8 | 28856 | 1 | ||||
63913 | 192448 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2310 19th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 6010888.50248 | 2105103.3176 | 37.7608265135647 | -122.40543366323 | (37.7608265135647, -122.40543366323) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
70855 | 128906 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 586 Spruce St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 5997146.09273 | 2113991.53957 | 37.7844533108166 | -122.453604104844 | (37.7844533108166, -122.453604104844) | 15 | 6 | 1 | 54 | 31 | |||
89721 | 192459 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 651 Indiana St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6014938.71006 | 2105394.68115 | 37.7618521615646 | -122.391446047021 | (37.7618521615646, -122.391446047021) | 10 | 3 | 8 | 28856 | 29 | |||
98806 | 192450 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2310 19th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6010867.63579 | 2105104.33666 | 37.7608281449347 | -122.405505903996 | (37.7608281449347, -122.405505903996) | 10 | 3 | 8 | 28856 | 29 | |||
114858 | 219113 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 409 Bella Vista Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5997408.05803 | 2096319.97327 | 37.7359466621108 | -122.451422789356 | (37.7359466621108, -122.451422789356) | 9 | 7 | 4 | 59 | 40 | |||
116874 | 190518 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 299 Bryant St | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6015402.02385 | 2114023.64667 | 37.785571094386 | -122.390446562985 | (37.785571094386, -122.390446562985) | 6 | 2 | 9 | 28856 | 6 | |||
119252 | 192473 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 654 Minnesota St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6015149.47337 | 2105409.76647 | 37.7619052782381 | -122.390718148338 | (37.7619052782381, -122.390718148338) | 10 | 3 | 8 | 28856 | 29 | |||
122459 | 192460 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 651 Indiana St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 6014934.12052 | 2105449.30544 | 37.7620018933059 | -122.391465739479 | (37.7620018933059, -122.391465739479) | 10 | 3 | 8 | 28856 | 29 | |||
124005 | 228343 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 50 Everson St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6003603.71357 | 2097148.2169 | 37.7385736618306 | -122.430061009332 | (37.7385736618306, -122.430061009332) | 2 | 7 | 5 | 63 | 7 | |||
131154 | 219142 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 255 Staples Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5998385.58971 | 2093771.83772 | 37.7290060129005 | -122.447859693369 | (37.7290060129005, -122.447859693369) | 9 | 7 | 4 | 28861 | 40 | ||||
144659 | 253624 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 735 Teresita Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5998960 | 2095994 | 37.7351403627024 | -122.446033688862 | (37.7351403627024, -122.446033688862) | 9 | 7 | 4 | 63 | 40 | ||||
156408 | 190382 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2350 20th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6011068.2259 | 2104645.22046 | 37.7595787284893 | -122.404779824648 | (37.7595787284893, -122.404779824648) | 10 | 3 | 8 | 28856 | 29 | |||
160778 | 215785 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 16 Agua Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | Width 2ft | Permit Number 775074 | 5997502.62133 | 2098608.67839 | 37.7422363073547 | -122.451260857411 | (37.7422363073547, -122.451260857411) | 9 | 7 | 4 | 59 | 40 | |
172031 | 192449 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2310 19th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6010874.27982 | 2105104.21282 | 37.760828176397 | -122.405482916403 | (37.760828176397, -122.405482916403) | 10 | 3 | 8 | 28856 | 29 | |||
180837 | 219115 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 409 Bella Vista Way | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5997400.88581 | 2096335.81192 | 37.7359897405315 | -122.451448728489 | (37.7359897405315, -122.451448728489) | 9 | 7 | 4 | 59 | 40 | |||
182248 | 129012 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 150 Francisco St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6010624.52904 | 2121364.46761 | 37.8054610295673 | -122.407493109815 | (37.8054610295673, -122.407493109815) | 3 | 1 | 10 | 308 | 23 | ||||
185816 | 192474 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 654 Minnesota St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 6015149.97171 | 2105400.79096 | 37.7618806610754 | -122.390715797509 | (37.7618806610754, -122.390715797509) | 10 | 3 | 8 | 28856 | 29 | |||
185969 | 228254 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 470 Liberty St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003313.06662 | 2103916.08492 | 37.7571401799037 | -122.431548960114 | (37.7571401799037, -122.431548960114) | 2 | 4 | 5 | 28862 | 3 | |||
194274 | 176549 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 65 Ocean Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Permit Number 785586 | 6001075.93443 | 2091730.69509 | 37.7235549090091 | -122.438412809004 | (37.7235549090091, -122.438412809004) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |
9108 | 116642 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 270 Brannan St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1 | 3x3 | 6015144.15756 | 2112956.70855 | 37.7826272167081 | -122.391264104249 | (37.7826272167081, -122.391264104249) | 6 | 2 | 9 | 28856 | 6 | |||
17276 | 72565 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 270 Brannan St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 4x4 | Permit Number 770847 | 6015158 | 2112983 | 37.7827001752808 | -122.391218053322 | (37.7827001752808, -122.391218053322) | 6 | 2 | 9 | 28856 | 6 | ||
34172 | 116641 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 270 Brannan St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1 | 4x4 | 6015158 | 2112983 | 37.7827001752808 | -122.391218053322 | (37.7827001752808, -122.391218053322) | 6 | 2 | 9 | 28856 | 6 | |||
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 | |||
54776 | 109969 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 1x DAVIS ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 18 | 3x3 | Permit Number 774526 | 6013431.7 | 2116562.3 | 37.7924321476874 | -122.397441457592 | (37.7924321476874, -122.397441457592) | 4 | 2 | 10 | 28860 | 6 | |
144153 | 109970 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 1x DAVIS ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 3x3 | Permit Number 774526 | 6013431.7 | 2116562.3 | 37.7924321476874 | -122.397441457592 | (37.7924321476874, -122.397441457592) | 4 | 2 | 10 | 28860 | 6 | ||
177060 | 116640 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 270 Brannan St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1 | 4x4 | 6015158 | 2112983 | 37.7827001752808 | -122.391218053322 | (37.7827001752808, -122.391218053322) | 6 | 2 | 9 | 28856 | 6 | |||
180111 | 256895 | Private 9 | Ginkgo biloba :: Maidenhair Tree 22 | 701 Congo St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x12 | Permit Number 768867 | 6000183.68977 | 2096091.89275 | 37.7354789553486 | -122.441809987085 | (37.7354789553486, -122.441809987085) | 9 | 7 | 4 | 63 | 40 | |||
1566 | 124023 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Funston Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5991830.31416 | 2113050.03169 | 37.781562022994 | -122.471926053077 | (37.781562022994, -122.471926053077) | 11 | 6 | 2 | 54 | 11 | |||
3076 | 228280 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
3160 | 228282 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
3306 | 228286 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
6383 | 228279 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
7100 | 228281 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
8602 | 228283 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
10725 | 228284 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
10740 | 228285 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
15540 | 124027 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 201 Funston Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5991798.47727 | 2113998.77869 | 37.7841651786362 | -122.47210536759 | (37.7841651786362, -122.47210536759) | 11 | 6 | 2 | 54 | 11 | |||
17303 | 201604 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 570 Innes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6021044.33252 | 2093135.00772 | 37.7285264880895 | -122.369481698744 | (37.7285264880895, -122.369481698744) | 10 | 3 | 8 | 58 | 1 | |||
17644 | 128974 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 McAllister St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008318.90919 | 2112394.69245 | 37.7807029103535 | -122.414836823479 | (37.7807029103535, -122.414836823479) | 7 | 10 | 9 | 28852 | 36 | |||
20722 | 140879 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 137 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5996520.7008 | 2113467.9498 | 37.7829798014331 | -122.455729872689 | (37.7829798014331, -122.455729872689) | 11 | 6 | 1 | 54 | 31 | |||
29266 | 192461 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 847 22nd St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 6015322.83777 | 2103901.69032 | 37.7577740418449 | -122.390013191359 | (37.7577740418449, -122.390013191359) | 10 | 3 | 8 | 28856 | 29 | |||
36499 | 128982 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 McAllister St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008559.94601 | 2112424.43606 | 37.7807981197758 | -122.41400506301 | (37.7807981197758, -122.41400506301) | 7 | 10 | 9 | 28852 | 36 | |||
38485 | 226283 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 869 Alvarado St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6000808.63592 | 2102566.76257 | 37.7532930006939 | -122.440113469271 | (37.7532930006939, -122.440113469271) | 2 | 4 | 5 | 28862 | 22 | |||
45718 | 123261 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 699 07th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 2ft | 5993774.08619 | 2110834.55923 | 37.7755912137397 | -122.465040629039 | (37.7755912137397, -122.465040629039) | 11 | 6 | 2 | 54 | 11 | |||
46556 | 182716 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1707 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5988092.0603 | 2103661.619 | 37.7555670168906 | -122.484169748346 | (37.7555670168906, -122.484169748346) | 1 | 8 | 3 | 56 | 35 | |||
53994 | 192462 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 833 22nd St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 6015373.65288 | 2103902.76148 | 37.7577798011236 | -122.38983752498 | (37.7577798011236, -122.38983752498) | 10 | 3 | 8 | 28856 | 29 | |||
55268 | 120447 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 22nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5988944.82314 | 2114949.71234 | 37.7866106225502 | -122.482047561852 | (37.7866106225502, -122.482047561852) | 11 | 6 | 1 | 55 | 33 | |||
56523 | 128980 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 McAllister St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008492.62721 | 2112417.90621 | 37.7807764092316 | -122.414237490093 | (37.7807764092316, -122.414237490093) | 7 | 10 | 9 | 28852 | 36 | |||
57349 | 128973 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 McAllister St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008290.76156 | 2112391.46976 | 37.7806924800019 | -122.414933971833 | (37.7806924800019, -122.414933971833) | 7 | 10 | 9 | 28852 | 36 | |||
63291 | 140878 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 137 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5996520.3624 | 2113480.4714 | 37.7830141630021 | -122.455731948822 | (37.7830141630021, -122.455731948822) | 11 | 6 | 1 | 54 | 31 | |||
63955 | 192478 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1100 Pennsylvania Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014496.88191 | 2101756.58956 | 37.7518382114843 | -122.392719650714 | (37.7518382114843, -122.392719650714) | 10 | 3 | 8 | 28856 | 1 | ||||
67700 | 225624 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 615 Buena Vista Ave West | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5999826.28045 | 2107648.26374 | 37.7671895722601 | -122.443875706619 | (37.7671895722601, -122.443875706619) | 15 | 5 | 5 | 29492 | 9 | |||
68120 | 192477 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1100 Pennsylvania Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014495.49701 | 2101783.51973 | 37.7519120790905 | -122.392726323686 | (37.7519120790905, -122.392726323686) | 10 | 3 | 8 | 28856 | 1 | ||||
71002 | 62853 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 148 Banks St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/12/2008 12:00:00 AM | 3x3 | Permit Number 50260 | 6008633.00401989 | 2097879.43631783 | 37.7408649848181 | -122.412723750897 | (37.7408649848181, -122.412723750897) | 10 | 7 | 7 | 28859 | 2 | ||
72889 | 219028 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1490 16th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 5991185.31027 | 2105281.92134 | 37.7601955518899 | -122.473590620024 | (37.7601955518899, -122.473590620024) | 1 | 8 | 4 | 56 | 12 | |||
76345 | 120471 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 88 West Clay St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5988434.04491 | 2115070.90864 | 37.7869136727274 | -122.483823598526 | (37.7869136727274, -122.483823598526) | 11 | 6 | 1 | 55 | 33 | |||
77000 | 120445 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 65 22nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5988945.83143 | 2114929.73493 | 37.7865558288888 | -122.482042609422 | (37.7865558288888, -122.482042609422) | 11 | 6 | 1 | 55 | 33 | |||
79701 | 190590 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1245 03rd St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6015578.74967 | 2109351.03033 | 37.7727509375275 | -122.389508696885 | (37.7727509375275, -122.389508696885) | 14 | 3 | 9 | 310 | 20 | |||
82849 | 253561 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 530 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 3ft | 5993033.55222 | 2099443.36305 | 37.7442712384442 | -122.466774050278 | (37.7442712384442, -122.466774050278) | 1 | 8 | 4 | 29491 | 40 | ||||
85050 | 198739 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 300 Main St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | 6015183.09065 | 2115200.65141 | 37.7887907329425 | -122.391286320207 | (37.7887907329425, -122.391286320207) | 6 | 2 | 9 | 28855 | 6 | ||||
89794 | 256008 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 300 Main St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6015252.9594 | 2115128.97629 | 37.7885978067978 | -122.391039570534 | (37.7885978067978, -122.391039570534) | 6 | 2 | 9 | 28855 | 6 | |||||
90803 | 219057 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2043 Monterey Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5992040.14931 | 2095397.21608 | 37.7331041614161 | -122.469914455893 | (37.7331041614161, -122.469914455893) | 9 | 8 | 4 | 59 | 40 | |||
91935 | 140882 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 132 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5996575.5252 | 2113451.7055 | 37.7829383450276 | -122.455539029498 | (37.7829383450276, -122.455539029498) | 11 | 6 | 1 | 54 | 31 | |||
93319 | 190589 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1245 03rd St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6015580.04197 | 2109334.21151 | 37.7727048284094 | -122.389503051837 | (37.7727048284094, -122.389503051837) | 14 | 3 | 9 | 310 | 20 | |||
93545 | 140880 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 137 COMMONWEALTH AVE | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5996520.3624 | 2113454.7513 | 37.7829435424358 | -122.455730089048 | (37.7829435424358, -122.455730089048) | 11 | 6 | 1 | 54 | 31 | |||
94973 | 121968 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 44 15th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 5991181.38701 | 2114863.262 | 37.7865030798053 | -122.474303361826 | (37.7865030798053, -122.474303361826) | 11 | 6 | 1 | 54 | 33 | ||||
97723 | 250844 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 242 30th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5986530.96095 | 2114207.27352 | 37.7844314123243 | -122.490344186658 | (37.7844314123243, -122.490344186658) | 11 | 6 | 1 | 55 | 33 | |||
98228 | 190454 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 25 Pomona St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6014177.43025 | 2094543.7925 | 37.7320156265221 | -122.393319675671 | (37.7320156265221, -122.393319675671) | 10 | 3 | 8 | 58 | 1 | |||
98925 | 228256 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 746 Sanchez St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 6003678.21446 | 2103782.37119 | 37.7567937232688 | -122.430276599309 | (37.7567937232688, -122.430276599309) | 2 | 4 | 5 | 28862 | 3 | |||
99039 | 120444 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 65 22nd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5988946.42808 | 2114912.85474 | 37.7865095153738 | -122.482039308131 | (37.7865095153738, -122.482039308131) | 11 | 6 | 1 | 55 | 33 | |||
99403 | 219109 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 Linares Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994027.97694 | 2102119.94695 | 37.7516778003047 | -122.463529778385 | (37.7516778003047, -122.463529778385) | 1 | 8 | 4 | 29491 | 40 | |||
102443 | 140883 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 132 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5996574.5099 | 2113471.334 | 37.7829921814191 | -122.45554396116 | (37.7829921814191, -122.45554396116) | 11 | 6 | 1 | 54 | 31 | |||
104587 | 120443 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 77 22nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5988946.9866 | 2114882.90892 | 37.786427325124 | -122.482035181262 | (37.786427325124, -122.482035181262) | 11 | 6 | 1 | 55 | 33 | |||
105211 | 226273 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 462 Clipper St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 6002184.85259 | 2100926.96463 | 37.7488687579899 | -122.43523695393 | (37.7488687579899, -122.43523695393) | 2 | 4 | 5 | 28862 | 22 | |||
107314 | 219105 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1950 08th Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993897.96293 | 2102236.78377 | 37.7519911124041 | -122.463987860646 | (37.7519911124041, -122.463987860646) | 1 | 8 | 4 | 29491 | 12 | |||
107634 | 192475 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1800 04th St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 6015139.80289 | 2106985.00794 | 37.7662300127221 | -122.390861689138 | (37.7662300127221, -122.390861689138) | 14 | 3 | 9 | 310 | 29 | |||
111148 | 219111 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 20 Vasquez Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5995721.23855 | 2100113.92195 | 37.7462671740053 | -122.457529171644 | (37.7462671740053, -122.457529171644) | 1 | 5 | 4 | 59 | 40 | |||
111385 | 120459 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 67 West Clay St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5988568.8662 | 2114996.16494 | 37.7867162951637 | -122.4833516722 | (37.7867162951637, -122.4833516722) | 11 | 6 | 1 | 55 | 33 | |||
114665 | 140888 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 140 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5996575.8636 | 2113422.6012 | 37.7828584517603 | -122.455535754513 | (37.7828584517603, -122.455535754513) | 11 | 6 | 1 | 54 | 31 | |||
115185 | 128978 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 McAllister St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008450.9627 | 2112411.46022 | 37.7807563696584 | -122.41438117208 | (37.7807563696584, -122.41438117208) | 7 | 10 | 9 | 28852 | 36 | |||
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 |
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) );