trees
3,247 rows where qSpecies_id = 22 sorted by PlotSize 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 167128 | 226002 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 169 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 9ft | 6005477.49545 | 2100188.99105 | 37.7470288826965 | -122.423798516405 | (37.7470288826965, -122.423798516405) | 2 | 7 | 5 | 28859 | 22 | |||
| 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 | |||
| 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 | |||
| 87514 | 226270 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 4491 24th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 26 | Width 8ft | 6000072.43582 | 2101640.71207 | 37.7507083509117 | -122.442592908247 | (37.7507083509117, -122.442592908247) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 171965 | 226004 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 94 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 7ft | 6006211.97543 | 2099539.93145 | 37.7452881477378 | -122.421212661561 | (37.7452881477378, -122.421212661561) | 2 | 7 | 5 | 28859 | 2 | |||
| 12208 | 190492 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 541 Delancey St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6015312.24709 | 2113599.76666 | 37.7844022356283 | -122.390727534552 | (37.7844022356283, -122.390727534552) | 6 | 2 | 9 | 28856 | 6 | |||
| 14813 | 190494 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 541 Delancey St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6015224.29962 | 2113700.39003 | 37.7846736447102 | -122.391038840285 | (37.7846736447102, -122.391038840285) | 6 | 2 | 9 | 28856 | 6 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 73011 | 190493 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 541 Delancey St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6015305.91458 | 2113614.18637 | 37.784441477541 | -122.390750451073 | (37.784441477541, -122.390750451073) | 6 | 2 | 9 | 28856 | 6 | |||
| 74785 | 190490 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 543 Delancey St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6015415.34325 | 2113497.18941 | 37.7841263011177 | -122.390363685055 | (37.7841263011177, -122.390363685055) | 6 | 2 | 9 | 28856 | 6 | |||
| 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 | |||
| 77075 | 190491 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 541 Delancey St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6015329.13045 | 2113592.35808 | 37.7843828300441 | -122.390668605586 | (37.7843828300441, -122.390668605586) | 6 | 2 | 9 | 28856 | 6 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 108719 | 190488 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 543 Delancey St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6015434.43193 | 2113480.36737 | 37.7840811704488 | -122.390296468815 | (37.7840811704488, -122.390296468815) | 6 | 2 | 9 | 28856 | 6 | |||
| 110216 | 190497 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 538 Delancey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6015173.48225 | 2113768.99692 | 37.7848592036193 | -122.391219450233 | (37.7848592036193, -122.391219450233) | 6 | 2 | 9 | 28856 | 6 | |||
| 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 | |||
| 113517 | 190485 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 543 Delancey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6015539.69218 | 2113369.9861 | 37.7837839265342 | -122.38992459017 | (37.7837839265342, -122.38992459017) | 6 | 2 | 9 | 28856 | 6 | |||
| 121701 | 226139 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1406 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 6003891.63424 | 2100016.96395 | 37.7464668837446 | -122.429270023205 | (37.7464668837446, -122.429270023205) | 2 | 7 | 5 | 63 | 22 | |||
| 123296 | 120472 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 88 West Clay St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5988447.19453 | 2115067.03638 | 37.786903806069 | -122.483777820382 | (37.786903806069, -122.483777820382) | 11 | 6 | 1 | 55 | 33 | |||
| 125332 | 190486 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 543 Delancey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6015531.29876 | 2113374.48851 | 37.7837958236503 | -122.389953943122 | (37.7837958236503, -122.389953943122) | 6 | 2 | 9 | 28856 | 6 | |||
| 130183 | 190495 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 541 Delancey St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015210.04745 | 2113708.94131 | 37.7846963337125 | -122.391088746357 | (37.7846963337125, -122.391088746357) | 6 | 2 | 9 | 28856 | 6 | |||
| 144781 | 120458 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 67 West Clay St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5988579.7702 | 2114992.84531 | 37.7867078149969 | -122.483313703981 | (37.7867078149969, -122.483313703981) | 11 | 6 | 1 | 55 | 33 | |||
| 149358 | 120442 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 77 22nd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5988947.55811 | 2114864.8414 | 37.7863777500738 | -122.482031879947 | (37.7863777500738, -122.482031879947) | 11 | 6 | 1 | 55 | 33 | |||
| 150408 | 120460 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 67 West Clay St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5988559.61165 | 2114998.49915 | 37.7867221656327 | -122.483383861528 | (37.7867221656327, -122.483383861528) | 11 | 6 | 1 | 55 | 33 | |||
| 151774 | 120473 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 88 West Clay St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5988459.1629 | 2115064.18747 | 37.7868966804599 | -122.483736204114 | (37.7868966804599, -122.483736204114) | 11 | 6 | 1 | 55 | 33 | |||
| 153260 | 190487 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 543 Delancey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6015525.84147 | 2113384.34733 | 37.7838225910846 | -122.389973512379 | (37.7838225910846, -122.389973512379) | 6 | 2 | 9 | 28856 | 6 | |||
| 156788 | 176525 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 555 Lisbon St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6001927.74225 | 2090254.03018 | 37.7195487332566 | -122.435362686337 | (37.7195487332566, -122.435362686337) | 9 | 7 | 6 | 28861 | 5 | |||
| 169506 | 190498 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 538 Delancey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6015168.4177 | 2113757.9053 | 37.7848284674924 | -122.391236196486 | (37.7848284674924, -122.391236196486) | 6 | 2 | 9 | 28856 | 6 | |||
| 171362 | 190496 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 541 Delancey St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6015207.26145 | 2113719.36295 | 37.7847247945658 | -122.391099113758 | (37.7847247945658, -122.391099113758) | 6 | 2 | 9 | 28856 | 6 | |||
| 174512 | 226003 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 101 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 6005787.68664 | 2100206.63449 | 37.7470948335555 | -122.422727154059 | (37.7470948335555, -122.422727154059) | 2 | 7 | 5 | 28859 | 22 | |||
| 176885 | 120474 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 88 West Clay St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5988469.71157 | 2115060.56996 | 37.7868873618402 | -122.483699443255 | (37.7868873618402, -122.483699443255) | 11 | 6 | 1 | 55 | 33 | |||
| 178345 | 190489 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 543 Delancey St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6015419.98604 | 2113488.70595 | 37.7841032649961 | -122.390347029604 | (37.7841032649961, -122.390347029604) | 6 | 2 | 9 | 28856 | 6 | |||
| 182302 | 120446 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 22nd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5988945.57573 | 2114940.19348 | 37.7865845302304 | -122.482044260519 | (37.7865845302304, -122.482044260519) | 11 | 6 | 1 | 55 | 33 | |||
| 3134 | 190600 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015217.08572 | 2107526.40267 | 37.7677208521577 | -122.390632216307 | (37.7677208521577, -122.390632216307) | 14 | 3 | 9 | 310 | 20 | |||
| 24134 | 225646 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 224 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6006759.76899 | 2097838.59099 | 37.7406475155723 | -122.419197816838 | (37.7406475155723, -122.419197816838) | 2 | 7 | 7 | 28859 | 2 | |||
| 31128 | 128943 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 999 Geary St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6007076.9364 | 2114307.93952 | 37.7858863580241 | -122.41926917535 | (37.7858863580241, -122.41926917535) | 13 | 9 | 9 | 28858 | 36 | |||
| 31938 | 225761 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 566 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6003615.33526 | 2104949.13531 | 37.7599938177664 | -122.430577311017 | (37.7599938177664, -122.430577311017) | 2 | 4 | 5 | 28862 | 3 | |||
| 32595 | 190599 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 526 Nelson Rising Ln | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015261.35764 | 2108269.67472 | 37.7697641703179 | -122.390531026393 | (37.7697641703179, -122.390531026393) | 14 | 3 | 9 | 310 | 20 | |||
| 33551 | 190594 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 526 Nelson Rising Ln | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015350.67018 | 2108276.18439 | 37.7697869987055 | -122.390222549028 | (37.7697869987055, -122.390222549028) | 14 | 3 | 9 | 310 | 20 | |||
| 33616 | 190566 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 550 South St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016411.49198 | 2107989.98551 | 37.7690599417774 | -122.386533201771 | (37.7690599417774, -122.386533201771) | 14 | 3 | 9 | 310 | 20 | |||
| 34180 | 190463 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 560 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6012913.646 | 2115176.95857 | 37.7885994678435 | -122.399136665124 | (37.7885994678435, -122.399136665124) | 12 | 2 | 9 | 28855 | 6 | |||
| 40688 | 225763 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 590 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6003622.09056 | 2104863.22767 | 37.7597583186054 | -122.430547817747 | (37.7597583186054, -122.430547817747) | 2 | 4 | 5 | 28862 | 3 | |||
| 45771 | 190461 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 560 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6012948.59757 | 2115205.37552 | 37.788679441854 | -122.399017732508 | (37.788679441854, -122.399017732508) | 12 | 2 | 9 | 28855 | 6 | |||
| 46443 | 225742 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1111 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6003207.58869 | 2101761.35624 | 37.7512178267583 | -122.431759901518 | (37.7512178267583, -122.431759901518) | 2 | 4 | 5 | 28862 | 22 | |||
| 47248 | 128931 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2101 Washington St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6004999.26308 | 2116762.74652 | 37.7925094116358 | -122.42663222262 | (37.7925094116358, -122.42663222262) | 13 | 9 | 1 | 28858 | 27 | |||
| 52917 | 190571 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 550 South St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6016244.2177 | 2107979.82534 | 37.7690227827156 | -122.387111089925 | (37.7690227827156, -122.387111089925) | 14 | 3 | 9 | 310 | 20 | |||
| 57101 | 190580 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 450 South St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6015878.80294 | 2107959.2807 | 37.7689461298947 | -122.388373613948 | (37.7689461298947, -122.388373613948) | 14 | 3 | 9 | 310 | 20 | |||
| 57584 | 190602 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015271.57365 | 2107530.7974 | 37.7677359418886 | -122.390444054766 | (37.7677359418886, -122.390444054766) | 14 | 3 | 9 | 310 | 20 | |||
| 57611 | 190598 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 526 Nelson Rising Ln | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015283.47377 | 2108274.89643 | 37.7697797348675 | -122.390454891574 | (37.7697797348675, -122.390454891574) | 14 | 3 | 9 | 310 | 20 | |||
| 63280 | 248135 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 115 Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6010354.08492 | 2099463.53811 | 37.7453110336961 | -122.406884485526 | (37.7453110336961, -122.406884485526) | 2 | 7 | 7 | 28859 | 2 | |||
| 63527 | 190608 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015462.45363 | 2107535.18496 | 37.7677585760219 | -122.389784125064 | (37.7677585760219, -122.389784125064) | 14 | 3 | 9 | 310 | 20 | |||
| 64896 | 190577 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 450 South St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6016001.60495 | 2107966.29221 | 37.7689721859532 | -122.387949335392 | (37.7689721859532, -122.387949335392) | 14 | 3 | 9 | 310 | 20 | |||
| 65581 | 190604 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015329.13458 | 2107531.20473 | 37.7677402532417 | -122.390244985313 | (37.7677402532417, -122.390244985313) | 14 | 3 | 9 | 310 | 20 | |||
| 67855 | 190603 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015296.80797 | 2107531.07269 | 37.7677380975679 | -122.390356790834 | (37.7677380975679, -122.390356790834) | 14 | 3 | 9 | 310 | 20 | |||
| 70309 | 190544 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 888 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6012334.18585 | 2108753.30483 | 37.7709292878733 | -122.400690075812 | (37.7709292878733, -122.400690075812) | 14 | 2 | 8 | 28856 | 20 | |||
| 70480 | 129016 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1500 Sansome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6011815.54331 | 2120971.51121 | 37.8044486600418 | -122.403343759329 | (37.8044486600418, -122.403343759329) | 3 | 1 | 10 | 28860 | 6 | |||
| 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 | |||
| 75979 | 190606 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015393.80416 | 2107532.25368 | 37.76774672026 | -122.390021372499 | (37.76774672026, -122.390021372499) | 14 | 3 | 9 | 310 | 20 | |||
| 76238 | 190550 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 888 07th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6012436.95281 | 2108645.13993 | 37.7706380226612 | -122.400327001491 | (37.7706380226612, -122.400327001491) | 14 | 2 | 8 | 28856 | 20 | |||
| 77023 | 190578 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 450 South St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015978.37212 | 2107965.30085 | 37.7689681767714 | -122.388029627781 | (37.7689681767714, -122.388029627781) | 14 | 3 | 9 | 310 | 20 | |||
| 77768 | 225741 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1111 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6003207.88317 | 2101742.77982 | 37.7511668369783 | -122.431757556977 | (37.7511668369783, -122.431757556977) | 2 | 4 | 5 | 28862 | 22 | |||
| 77907 | 190597 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 526 Nelson Rising Ln | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015311.55248 | 2108274.70714 | 37.7697807726996 | -122.390357754025 | (37.7697807726996, -122.390357754025) | 14 | 3 | 9 | 310 | 20 | |||
| 78345 | 190460 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 5 Anthony St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6012767.43065 | 2115195.29722 | 37.7886416721168 | -122.399643839601 | (37.7886416721168, -122.399643839601) | 12 | 2 | 9 | 28855 | 6 | |||
| 78848 | 123537 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 21 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 5994224.72449 | 2115479.15004 | 37.7883699808955 | -122.463818970533 | (37.7883699808955, -122.463818970533) | 11 | 6 | 1 | 54 | 11 | |||
| 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 | |||
| 81059 | 225743 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1111 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6003206.55355 | 2101776.90911 | 37.7512604725972 | -122.431764591488 | (37.7512604725972, -122.431764591488) | 2 | 4 | 5 | 28862 | 22 | |||
| 82056 | 226060 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 164 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6005261.59596 | 2104022.79121 | 37.7575434188179 | -122.424817781013 | (37.7575434188179, -122.424817781013) | 2 | 4 | 5 | 28859 | 19 | |||
| 83114 | 192498 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 588 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6014359.46306 | 2104360.22767 | 37.7589796100279 | -122.393377054207 | (37.7589796100279, -122.393377054207) | 10 | 3 | 8 | 28856 | 29 | |||
| 83596 | 128912 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2451 Steiner St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6002274.04301 | 2116265.77897 | 37.7909904207088 | -122.436025978634 | (37.7909904207088, -122.436025978634) | 13 | 9 | 1 | 29490 | 27 | |||
| 87806 | 190568 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 550 South St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016318.75266 | 2107983.43695 | 37.7690368265244 | -122.386853527668 | (37.7690368265244, -122.386853527668) | 14 | 3 | 9 | 310 | 20 | |||
| 91593 | 190574 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 550 South St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6016169.13913 | 2107975.39199 | 37.769006451918 | -122.387370475084 | (37.769006451918, -122.387370475084) | 14 | 3 | 9 | 310 | 20 | |||
| 92804 | 190591 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 526 Nelson Rising Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015405.78137 | 2108280.36173 | 37.7698015254385 | -122.390032211124 | (37.7698015254385, -122.390032211124) | 14 | 3 | 9 | 310 | 20 | |||
| 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 | |||
| 93648 | 190549 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 888 07th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6012420.73101 | 2108662.95487 | 37.7706860338703 | -122.400384364769 | (37.7706860338703, -122.400384364769) | 14 | 2 | 8 | 28856 | 20 | |||
| 93900 | 190459 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 5 Anthony St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6012789.14548 | 2115174.16236 | 37.7885848511652 | -122.399567224573 | (37.7885848511652, -122.399567224573) | 12 | 2 | 9 | 28855 | 6 | |||
| 99126 | 190573 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 550 South St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016194.38649 | 2107976.86529 | 37.7690118955188 | -122.387283248044 | (37.7690118955188, -122.387283248044) | 14 | 3 | 9 | 310 | 20 | |||
| 99223 | 190576 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 450 South St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6016023.93976 | 2107967.06556 | 37.7689755467242 | -122.387872134002 | (37.7689755467242, -122.387872134002) | 14 | 3 | 9 | 310 | 20 | |||
| 99749 | 190583 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 448 South St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015780.1959 | 2107952.51143 | 37.7689220784184 | -122.388714219602 | (37.7689220784184, -122.388714219602) | 14 | 3 | 9 | 310 | 20 | |||
| 101853 | 190585 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 448 South St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015704.36743 | 2107948.44562 | 37.768906711711 | -122.388976223597 | (37.768906711711, -122.388976223597) | 14 | 3 | 9 | 310 | 20 | |||
| 102297 | 190582 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 450 South St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015829.41164 | 2107957.60094 | 37.7689387806299 | -122.38854433945 | (37.7689387806299, -122.38854433945) | 14 | 3 | 9 | 310 | 20 | |||
| 102689 | 190547 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 888 07th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6012386.15818 | 2108699.40492 | 37.7707841894616 | -122.400506514263 | (37.7707841894616, -122.400506514263) | 14 | 2 | 8 | 28856 | 20 | |||
| 104329 | 190464 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 560 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6012895.81714 | 2115160.20532 | 37.7885524737596 | -122.399197174227 | (37.7885524737596, -122.399197174227) | 12 | 2 | 9 | 28855 | 6 | |||
| 105386 | 123538 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 23 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 5994225.48914 | 2115464.05716 | 37.7883285840326 | -122.463815229058 | (37.7883285840326, -122.463815229058) | 11 | 6 | 1 | 54 | 11 | |||
| 106158 | 190570 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 550 South St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016269.16007 | 2107982.62643 | 37.7690318550592 | -122.387025010418 | (37.7690318550592, -122.387025010418) | 14 | 3 | 9 | 310 | 20 | |||
| 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 | ||||
| 108871 | 190462 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 560 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6012926.55482 | 2115189.00779 | 37.7886332715545 | -122.39909284835 | (37.7886332715545, -122.39909284835) | 12 | 2 | 9 | 28855 | 6 | |||
| 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 | |||
| 119051 | 123591 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 26 05th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 5ft | 5994270.79581 | 2115427.05215 | 37.7882295890949 | -122.463655789773 | (37.7882295890949, -122.463655789773) | 11 | 6 | 1 | 54 | 11 | |||
| 123031 | 190605 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015358.34087 | 2107532.97001 | 37.7677467202638 | -122.390144086798 | (37.7677467202638, -122.390144086798) | 14 | 3 | 9 | 310 | 20 | |||
| 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 | |||
| 127302 | 225645 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 217 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6006795.14405 | 2097846.76508 | 37.7406719519528 | -122.419076082802 | (37.7406719519528, -122.419076082802) | 2 | 7 | 7 | 28859 | 2 |
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) );