trees
3,247 rows where qSpecies_id = 22 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
480 | 225991 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 99 Laussat St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6004313.0789 | 2109253.93974 | 37.7718532783246 | -122.428470991768 | (37.7718532783246, -122.428470991768) | 7 | 9 | 11 | 28852 | 10 | |||
1258 | 190419 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 15 | : | Tree | Private 2 | 05/01/2017 12:00:00 AM | 3 | Width 3ft | 6017844.32202 | 2096957.74462 | 37.7388469037738 | -122.380810054756 | (37.7388469037738, -122.380810054756) | 10 | 3 | 8 | 58 | 1 | ||
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 | |||
12711 | 190451 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1498 Evans Ave | 8 | : | Tree | Private 2 | 3 | Width 3ft | 6016356.86171 | 2098066.94132 | 37.7418103263734 | -122.386030346736 | (37.7418103263734, -122.386030346736) | 10 | 3 | 8 | 58 | 1 | |||
12946 | 192425 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 187 Clara St | 6 | : | Tree | Private 2 | 1 | Width 2ft | 6011952.39777 | 2111919.37561 | 37.7796012912124 | -122.402233334018 | (37.7796012912124, -122.402233334018) | 6 | 2 | 9 | 28856 | 34 | |||
13460 | 190428 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 26 | : | Tree | Private 2 | 1 | Width 3ft | 6017641.63274 | 2097108.43991 | 37.7392494942632 | -122.381521343831 | (37.7392494942632, -122.381521343831) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
16071 | 202049 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 Exeter St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6012555.81447 | 2090941.8893 | 37.7220353110641 | -122.398673311925 | (37.7220353110641, -122.398673311925) | 10 | 3 | 8 | 58 | 1 | |||
16968 | 190389 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 707 Wisconsin St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6012743.00891 | 2104201.32754 | 37.7584533636396 | -122.398956396938 | (37.7584533636396, -122.398956396938) | 10 | 3 | 8 | 28856 | 29 | |||
17344 | 192428 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 480 Bryant St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6014110.58587 | 2112833.82618 | 37.7822323954538 | -122.39483123728 | (37.7822323954538, -122.39483123728) | 6 | 2 | 9 | 28856 | 6 | |||
18496 | 190429 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 27 | : | Tree | Private 2 | 2 | Width 3ft | 6017626.76379 | 2097120.54655 | 37.7392819157251 | -122.381573596257 | (37.7392819157251, -122.381573596257) | 10 | 3 | 8 | 58 | 1 | |||
18777 | 190425 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 23 | : | Tree | Private 2 | 1 | Width 3ft | 6017693.17965 | 2097070.35958 | 37.7391477791404 | -122.381340468613 | (37.7391477791404, -122.381340468613) | 10 | 3 | 8 | 58 | 1 | |||
21479 | 190434 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 33 | : | Tree | Private 2 | 2 | Width 3ft | 6017509.45239 | 2097206.48557 | 37.7395114092301 | -122.381985187163 | (37.7395114092301, -122.381985187163) | 10 | 3 | 8 | 58 | 1 | |||
21513 | 190444 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 Evans Ave | 7 | : | Tree | Private 2 | 1 | Width 3ft | 6017091.55638 | 2097401.29734 | 37.7400232358798 | -122.383443661803 | (37.7400232358798, -122.383443661803) | 10 | 3 | 8 | 58 | 1 | |||
22319 | 190397 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 8 | : | Tree | Private 2 | 4 | Width 3ft | 6012152.10777 | 2100910.47094 | 37.7493844454379 | -122.400768815931 | (37.7493844454379, -122.400768815931) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
22697 | 247223 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 161 Divisadero St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6001877.39877 | 2108558.68003 | 37.7698061344742 | -122.436846384277 | (37.7698061344742, -122.436846384277) | 15 | 5 | 5 | 29492 | 9 | |||
26254 | 190423 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 21 | : | Tree | Private 2 | 2 | Width 3ft | 6017743.92086 | 2097032.31488 | 37.7390461170957 | -122.381162382138 | (37.7390461170957, -122.381162382138) | 10 | 3 | 8 | 58 | 1 | |||
27161 | 190450 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1498 Evans Ave | 7 | : | Tree | Private 2 | 2 | Width 3ft | 6016372.9615 | 2098053.57634 | 37.7417745198736 | -122.385973747016 | (37.7417745198736, -122.385973747016) | 10 | 3 | 8 | 58 | 1 | |||
31889 | 190432 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 31 | : | Tree | Private 2 | 2 | Width 3ft | 6017540.84506 | 2097183.62792 | 37.7394503803184 | -122.381875054415 | (37.7394503803184, -122.381875054415) | 10 | 3 | 8 | 58 | 1 | |||
32269 | 190407 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 13 | : | Tree | Private 2 | 4 | Width 3ft | 6012292.25603 | 2100918.21603 | 37.7494135277217 | -122.40028472079 | (37.7494135277217, -122.40028472079) | 10 | 3 | 8 | 58 | 1 | |||
33763 | 247222 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 187 Divisadero St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6001857.53471 | 2108690.91436 | 37.7701680882111 | -122.436924561446 | (37.7701680882111, -122.436924561446) | 15 | 5 | 5 | 29492 | 9 | |||
35020 | 190391 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 571 Texas St | 2 | : | Tree | Private 2 | 1 | Width 6ft | 6013851.28196 | 2104449.17868 | 37.7591956029218 | -122.395140827087 | (37.7591956029218, -122.395140827087) | 10 | 3 | 8 | 28856 | 29 | |||
35040 | 190386 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 767 Rhode Island St | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6011868.88552 | 2104842.63412 | 37.7601655019667 | -122.402024606762 | (37.7601655019667, -122.402024606762) | 10 | 3 | 8 | 28856 | 29 | |||
35908 | 190418 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 13 | : | Tree | Private 2 | 4 | Width 3ft | 6017880.91866 | 2096930.70901 | 37.7387746891043 | -122.380681640547 | (37.7387746891043, -122.380681640547) | 10 | 3 | 8 | 58 | 1 | |||
36807 | 190421 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 17 | : | Tree | Private 2 | 3 | Width 3ft | 6017813.9736 | 2096980.81901 | 37.7389085864479 | -122.380916590229 | (37.7389085864479, -122.380916590229) | 10 | 3 | 8 | 58 | 1 | |||
38115 | 190455 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1751 Newhall St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6013882.7499 | 2094972.5307 | 37.7331764776989 | -122.394368465039 | (37.7331764776989, -122.394368465039) | 10 | 3 | 8 | 58 | 1 | |||
42229 | 225994 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 47 Octavia St | 2 | : | Tree | Private 2 | 3 | Width 4ft | 6005633.11959 | 2109553.55666 | 37.7727505652198 | -122.423926183265 | (37.7727505652198, -122.423926183265) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
45429 | 192433 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950 Harrison St | 8 | : | Tree | Private 2 | 6 | Width 3ft | 6011659.35399 | 2111367.95244 | 37.7780708492141 | -122.403208304326 | (37.7780708492141, -122.403208304326) | 14 | 2 | 9 | 28856 | 34 | |||
45974 | 202047 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 Exeter St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6012547.51313 | 2090916.47332 | 37.7219650614168 | -122.398700225048 | (37.7219650614168, -122.398700225048) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
52523 | 192434 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 382 07th St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6010729.70482 | 2110519.81747 | 37.7756901054455 | -122.406364535314 | (37.7756901054455, -122.406364535314) | 14 | 2 | 9 | 28853 | 34 | |||
52962 | 190402 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 10 | : | Tree | Private 2 | 1 | Width 3ft | 6012204.22169 | 2100912.2871 | 37.7493923387987 | -122.400588731202 | (37.7493923387987, -122.400588731202) | 10 | 3 | 8 | 58 | 1 | |||
57041 | 190437 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 41 | : | Tree | Private 2 | 3 | Width 3ft | 6017375.25118 | 2097308.04531 | 37.7397828596878 | -122.382456265548 | (37.7397828596878, -122.382456265548) | 10 | 3 | 8 | 58 | 1 | |||
60369 | 250996 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 453 44th Ave | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5982195.03644 | 2112765.40351 | 37.780218274692 | -122.505237834779 | (37.780218274692, -122.505237834779) | 11 | 6 | 2 | 55 | 26 | |||
60824 | 202050 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 Exeter St | 4 | : | Tree | Private 2 | 1 | Width 3ft | 6012561.58184 | 2090957.53646 | 37.7220785963245 | -122.398654472931 | (37.7220785963245, -122.398654472931) | 10 | 3 | 8 | 58 | 1 | |||
61394 | 192431 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 340 06th St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6011135.53343 | 2111313.58749 | 37.7778923077093 | -122.405016568457 | (37.7778923077093, -122.405016568457) | 14 | 2 | 9 | 28853 | 34 | |||
61577 | 225995 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 47 Octavia St | 3 | : | Tree | Private 2 | 3 | Width 4ft | 6005634.6441 | 2109541.93365 | 37.7727187373036 | -122.423920083153 | (37.7727187373036, -122.423920083153) | 7 | 9 | 11 | 28852 | 10 | |||
61912 | 190385 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 767 Rhode Island St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6011869.58694 | 2104827.57055 | 37.7601241798951 | -122.402021121884 | (37.7601241798951, -122.402021121884) | 10 | 3 | 8 | 28856 | 29 | |||
63741 | 190404 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 11 | : | Tree | Private 2 | 1 | Width 3ft | 6012224.99422 | 2100912.98992 | 37.7493954270713 | -122.400516948208 | (37.7493954270713, -122.400516948208) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
66084 | 225990 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2 Pearl St | 2 | : | Tree | Private 2 | 7 | Width 2ft | 6005601.08836 | 2108893.10222 | 37.7709353079426 | -122.42399000814 | (37.7709353079426, -122.42399000814) | 8 | 2 | 5 | 28853 | 19 | |||
70312 | 190443 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1355 Evans Ave | 4 | : | Tree | Private 2 | 4 | Width 3ft | 6016894.71914 | 2097547.52452 | 37.7404138654177 | -122.384134431075 | (37.7404138654177, -122.384134431075) | 10 | 3 | 8 | 58 | 1 | |||
71050 | 190435 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 35 | : | Tree | Private 2 | 1 | Width 3ft | 6017477.19545 | 2097232.60183 | 37.7395813377956 | -122.382098535015 | (37.7395813377956, -122.382098535015) | 10 | 3 | 8 | 58 | 1 | |||
72028 | 192443 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 12 McLea Ct | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6009970.15581 | 2109159.47449 | 37.7719124015539 | -122.408896016247 | (37.7719124015539, -122.408896016247) | 14 | 2 | 9 | 28853 | 34 | |||
72202 | 190416 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1881 Oakdale Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6013555.65434 | 2096549.25202 | 37.7374876405431 | -122.395609762377 | (37.7374876405431, -122.395609762377) | 10 | 3 | 8 | 58 | 1 | |||
74137 | 190395 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 7 | : | Tree | Private 2 | 5 | Width 3ft | 6012031.32912 | 2100905.98791 | 37.7493653986954 | -122.401186158933 | (37.7493653986954, -122.401186158933) | 10 | 3 | 8 | 58 | 1 | |||
77243 | 190441 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1355 Evans Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6016833.46344 | 2097593.14442 | 37.7405357415266 | -122.384349407722 | (37.7405357415266, -122.384349407722) | 10 | 3 | 8 | 58 | 1 | |||
78449 | 225988 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 51 Elgin Park | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6005833.50158 | 2108775.5715 | 37.7706257154391 | -122.423177727884 | (37.7706257154391, -122.423177727884) | 8 | 2 | 5 | 28853 | 19 | |||
80760 | 225987 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 79 Elgin Park | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6005841.38866 | 2108630.33046 | 37.7702273634261 | -122.423140120925 | (37.7702273634261, -122.423140120925) | 8 | 2 | 5 | 28853 | 19 | |||
81038 | 246990 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 78 Clipper St | 1 | : | Tree | Private 2 | 1 | Width 4ft | 6004670.61163 | 2101066.74727 | 37.7493934152835 | -122.426651147943 | (37.7493934152835, -122.426651147943) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
85473 | 219076 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 105 Majestic Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997099.54595 | 2089348.6148 | 37.7167872911766 | -122.451986630097 | (37.7167872911766, -122.451986630097) | 9 | 8 | 6 | 28861 | 24 | |||
85529 | 192429 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 271 Clara St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011461.32034 | 2111421.96775 | 37.7782081010676 | -122.403897179615 | (37.7782081010676, -122.403897179615) | 14 | 2 | 9 | 28856 | 34 | |||
87374 | 190417 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 9 | : | Tree | Private 2 | 2 | Width 3ft | 6017947.81444 | 2096878.13487 | 37.7386340225323 | -122.380446690882 | (37.7386340225323, -122.380446690882) | 10 | 3 | 8 | 58 | 1 | |||
87544 | 250770 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 247 32nd Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5985863.4711 | 2114256.40781 | 37.7845273142332 | -122.492657058592 | (37.7845273142332, -122.492657058592) | 11 | 6 | 1 | 55 | 33 | |||
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 | |||
92492 | 190387 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 700 Rhode Island St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6011798.73597 | 2105084.69836 | 37.7608262410664 | -122.402284241925 | (37.7608262410664, -122.402284241925) | 10 | 3 | 8 | 28856 | 29 | |||
92574 | 190440 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1350 Evans Ave | 7 | : | Tree | DPW 1 | 03/30/2004 12:00:00 AM | 4 | Width 3ft | 6016842.64833 | 2097703.08966 | 37.7408381367768 | -122.384325304974 | (37.7408381367768, -122.384325304974) | 10 | 3 | 8 | 58 | 1 | ||
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 | |||
94479 | 225992 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 73 Webster St | 2 | : | Tree | Private 2 | 1 | Width 4ft | 6004280.10203 | 2108876.58802 | 37.770815296119 | -122.428558158527 | (37.770815296119, -122.428558158527) | 7 | 9 | 11 | 29492 | 10 | |||
94781 | 225996 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 47 Octavia St | 4 | : | Tree | Private 2 | 1 | Width 4ft | 6005638.67194 | 2109514.80428 | 37.7726444739859 | -122.423904220905 | (37.7726444739859, -122.423904220905) | 7 | 9 | 11 | 28852 | 10 | |||
99290 | 225993 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 47 Octavia St | 1 | : | Tree | Private 2 | 3 | Width 4ft | 6005632.01245 | 2109568.33209 | 37.7727910724834 | -122.423931063861 | (37.7727910724834, -122.423931063861) | 7 | 9 | 11 | 28852 | 10 | |||
100766 | 247221 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 187 Divisadero St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6001849.33008 | 2108668.89946 | 37.7701071744218 | -122.436951364836 | (37.7701071744218, -122.436951364836) | 15 | 5 | 5 | 29492 | 9 | |||
103780 | 190449 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1498 Evans Ave | 3 | : | Tree | Private 2 | 2 | Width 4ft | 6016446.96027 | 2097998.11216 | 37.7416263215051 | -122.385714016492 | (37.7416263215051, -122.385714016492) | 10 | 3 | 8 | 58 | 1 | |||
106208 | 190415 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1799 Indiana St | 2 | : | Tree | Private 2 | 1 | Width 5ft | 6015204.21504 | 2100274.26045 | 37.7478073070623 | -122.390170025934 | (37.7478073070623, -122.390170025934) | 3 | 8 | 58 | 1 | ||||
109614 | 190427 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 25 | : | Tree | Private 2 | 3 | Width 3ft | 6017659.5138 | 2097095.80959 | 37.7392158011555 | -122.381458640414 | (37.7392158011555, -122.381458640414) | 10 | 3 | 8 | 58 | 1 | |||
110790 | 219074 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 250 Tara St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 5997774.99858 | 2090348.20126 | 37.7195705903952 | -122.449723925911 | (37.7195705903952, -122.449723925911) | 9 | 8 | 6 | 28861 | 24 | |||
113576 | 246481 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 330 Duncan St | 1 | : | Tree | Private 2 | 10 | Width 5ft | 6004176.06205 | 2099871.25195 | 37.7460828903302 | -122.428276120363 | (37.7460828903302, -122.428276120363) | 2 | 7 | 5 | 63 | 22 | |||
118085 | 225998 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 700 Duboce Ave | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6002353.91965 | 2108316.37553 | 37.769167897316 | -122.435180779574 | (37.769167897316, -122.435180779574) | 15 | 5 | 5 | 29492 | 9 | |||
118517 | 192426 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 356 05th St | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6011912.12832 | 2111911.11842 | 37.7795763710036 | -122.402372063443 | (37.7795763710036, -122.402372063443) | 6 | 2 | 9 | 28856 | 34 | |||
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 | |||
120720 | 246476 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 320 Duncan St | 1 | : | Tree | Private 2 | 16 | Width 3ft | 6004295.79003 | 2099877.9312 | 37.7461080038827 | -122.427862592303 | (37.7461080038827, -122.427862592303) | 2 | 7 | 5 | 63 | 22 | |||
122442 | 190405 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 12 | : | Tree | Private 2 | 4 | Width 3ft | 6012259.88232 | 2100916.21266 | 37.749406221625 | -122.400396529894 | (37.749406221625, -122.400396529894) | 10 | 3 | 8 | 58 | 1 | |||
125115 | 202048 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 Exeter St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6012550.84641 | 2090927.25992 | 37.7219948649522 | -122.398689459255 | (37.7219948649522, -122.398689459255) | 10 | 3 | 8 | 58 | 1 | |||
126303 | 190456 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1709 Revere Ave | 5 | : | Tree | Private 2 | 3 | Width 5ft | 6014599.96347 | 2094732.12435 | 37.7325562135041 | -122.391872039683 | (37.7325562135041, -122.391872039683) | 10 | 3 | 8 | 58 | 1 | |||
130630 | 192436 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 335 07th St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6010406.44162 | 2110853.4234 | 37.7765880209486 | -122.407506313667 | (37.7765880209486, -122.407506313667) | 14 | 2 | 9 | 28853 | 34 | |||
132455 | 190457 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 38 Bridgeview Dr | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6013965.07757 | 2095502.46045 | 37.7346361322527 | -122.394120920368 | (37.7346361322527, -122.394120920368) | 10 | 3 | 8 | 58 | 1 | |||
134184 | 190446 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1201 Evans Ave | 4 | : | Tree | Private 2 | 4 | Width 3ft | 6017708.20702 | 2096943.20124 | 37.7387994573363 | -122.381279670829 | (37.7387994573363, -122.381279670829) | 10 | 3 | 8 | 58 | 1 | |||
135583 | 190388 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 700 Rhode Island St | 2 | : | Tree | Private 2 | 2 | Width 3ft | 6011799.90498 | 2105067.41512 | 37.7607788503881 | -122.402278983608 | (37.7607788503881, -122.402278983608) | 10 | 3 | 8 | 28856 | 29 | |||
142045 | 190431 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 29 | : | Tree | Private 2 | 2 | Width 3ft | 6017575.22197 | 2097158.85814 | 37.7393842657625 | -122.381754470602 | (37.7393842657625, -122.381754470602) | 10 | 3 | 8 | 58 | 1 | |||
142163 | 192432 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950 Harrison St | 7 | : | Tree | Private 2 | 7 | Width 3ft | 6011668.99845 | 2111377.71615 | 37.7780981967176 | -122.403175627468 | (37.7780981967176, -122.403175627468) | 14 | 2 | 9 | 28856 | 34 | |||
142354 | 190412 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 15 | : | Tree | Private 2 | 4 | Width 3ft | 6012337.1891 | 2100920.23068 | 37.7494215649704 | -122.400129481597 | (37.7494215649704, -122.400129481597) | 10 | 3 | 8 | 58 | 1 | |||
143701 | 190430 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 28 | : | Tree | Private 2 | 3 | Width 3ft | 6017590.10949 | 2097147.67735 | 37.7393543876054 | -122.381702218193 | (37.7393543876054, -122.381702218193) | 10 | 3 | 8 | 58 | 1 | |||
145018 | 225989 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2 Pearl St | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6005599.73755 | 2108949.27442 | 37.7710894670405 | -122.423998675803 | (37.7710894670405, -122.423998675803) | 8 | 2 | 5 | 28853 | 19 | |||
146358 | 190393 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 6 | : | Tree | Private 2 | 4 | Width 3ft | 6012003.95277 | 2100904.28978 | 37.7493592086764 | -122.401280708234 | (37.7493592086764, -122.401280708234) | 10 | 3 | 8 | 58 | 1 | |||
146931 | 219075 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 56 Majestic Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997267.3367 | 2089660.30758 | 37.7176527366739 | -122.451429131349 | (37.7176527366739, -122.451429131349) | 9 | 8 | 6 | 28861 | 24 | |||
151776 | 190453 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1501 Evans Ave | 5 | : | Tree | Private 2 | 1 | Width 3ft | 6016075.66534 | 2098156.64839 | 37.7420410771473 | -122.387008895444 | (37.7420410771473, -122.387008895444) | 10 | 3 | 8 | 58 | 1 | |||
152307 | 190409 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 14 | : | Tree | Private 2 | 4 | Width 3ft | 6012317.26543 | 2100919.43782 | 37.7494182770353 | -122.400198322911 | (37.7494182770353, -122.400198322911) | 10 | 3 | 8 | 58 | 1 | |||
154680 | 219073 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 250 Tara St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5997792.80656 | 2090380.48595 | 37.7196602554868 | -122.449664695695 | (37.7196602554868, -122.449664695695) | 9 | 8 | 6 | 28861 | 24 | |||
154747 | 190411 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 15 | : | Tree | Private 2 | 4 | Width 3ft | 6012337.1891 | 2100920.23068 | 37.7494215649704 | -122.400129481597 | (37.7494215649704, -122.400129481597) | 10 | 3 | 8 | 58 | 1 | |||
158599 | 192444 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 12 McLea Ct | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6009959.06964 | 2109149.63533 | 37.7718847645088 | -122.408933669953 | (37.7718847645088, -122.408933669953) | 14 | 2 | 9 | 28853 | 34 | |||
162801 | 192442 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 10 McLea Ct | 6 | : | Tree | Private 2 | 2 | Width 3ft | 6010037.84763 | 2109199.90386 | 37.7720272027263 | -122.408664716903 | (37.7720272027263, -122.408664716903) | 14 | 2 | 9 | 28853 | 34 | |||
163620 | 225997 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 700 Duboce Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6002375.20249 | 2108318.05124 | 37.7691737069397 | -122.435107283376 | (37.7691737069397, -122.435107283376) | 15 | 5 | 5 | 29492 | 9 | |||
164377 | 190442 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1355 Evans Ave | 3 | : | Tree | Private 2 | 4 | Width 3ft | 6016877.61035 | 2097560.61603 | 37.7404488661282 | -122.384194498593 | (37.7404488661282, -122.384194498593) | 10 | 3 | 8 | 58 | 1 | |||
170848 | 201603 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 565 Innes Ave | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6021043.02716 | 2093075.23068 | 37.7283622799705 | -122.369482082752 | (37.7283622799705, -122.369482082752) | 10 | 3 | 8 | 58 | 1 | |||
171390 | 190436 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 40 | : | Tree | Private 2 | 2 | Width 3ft | 6017392.19785 | 2097295.20205 | 37.7397485307771 | -122.382396777202 | (37.7397485307771, -122.382396777202) | 10 | 3 | 8 | 58 | 1 | |||
173086 | 190452 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1501 Evans Ave | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6016023.90854 | 2098196.63219 | 37.7421479984362 | -122.387190643943 | (37.7421479984362, -122.387190643943) | 10 | 3 | 8 | 58 | 1 |
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) );