3,247 rows where qSpecies_id = 22 sorted by qSiteInfo descending

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);