Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSpecies, qAddress, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24155 | 24155 | 249927 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 12 | Back Yard : Yard 13 | Tree 1 | Private 1 | 31 | Width 0ft | 6011132.35015 | 2120388.99651 | 37.8028110368738 | -122.40566696715099 | (37.8028110368738, -122.405666967151) | |||
24822 | 24822 | 250192 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Alta St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011786.88966 | 2119947.0785 | 37.8016342173021 | -122.403370805543 | (37.8016342173021, -122.403370805543) | |||
24893 | 24893 | 249803 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 0ft | 6010797.8681 | 2121034.56269 | 37.8045648929076 | -122.406869977661 | (37.8045648929076, -122.406869977661) | |||
25938 | 25938 | 249996 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 41 Darrell Pl | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011497.53106 | 2120284.14207 | 37.8025435461134 | -122.40439586268101 | (37.8025435461134, -122.404395862681) | |||
27098 | 27098 | 249881 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 230 Greenwich St | 17 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | Width 0ft | 6011514.20842 | 2120460.74576 | 37.803029388647104 | -122.404350588107 | (37.8030293886471, -122.404350588107) | |||
28833 | 28833 | 249969 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 213 Filbert St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 28 | Width 0ft | 6011730.79134 | 2120085.86253 | 37.802012151107704 | -122.403574702535 | (37.8020121511077, -122.403574702535) | |||
29592 | 29592 | 249968 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 213 Filbert St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Width 0ft | 6011722.66122 | 2120088.35569 | 37.8020185425825 | -122.403603012281 | (37.8020185425825, -122.403603012281) | |||
33977 | 33977 | 249894 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 30 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | Width 0ft | 6011403.76038 | 2120447.63681 | 37.802987222140395 | -122.40473187458599 | (37.8029872221404, -122.404731874586) | |||
34978 | 34978 | 249883 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 230 Greenwich St | 19 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | Width 0ft | 6011507.08304 | 2120427.1107900003 | 37.802936637067496 | -122.40437287690901 | (37.8029366370675, -122.404372876909) | |||
36138 | 36138 | 249778 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 119 Pfeiffer St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 0ft | 6010409.80858 | 2121137.7854400002 | 37.804826595643 | -122.408220184708 | (37.804826595643, -122.408220184708) | |||
37934 | 37934 | 249882 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 18 | Back Yard : Yard 13 | Tree 1 | Private 1 | 27 | Width 0ft | 6011509.072430001 | 2120419.3733099997 | 37.8029155030083 | -122.40436544761499 | (37.8029155030083, -122.404365447615) | |||
40928 | 40928 | 250002 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 21 Darrell Pl | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011523.15034 | 2120119.58855 | 37.8020931539352 | -122.40429561796499 | (37.8020931539352, -122.404295617965) | |||
41112 | 41112 | 249802 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6010800.51699 | 2121027.19165 | 37.804544802067795 | -122.40686029106399 | (37.8045448020678, -122.406860291064) | |||
43839 | 43839 | 250000 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 39 Darrell Pl | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011508.04195 | 2120196.77393 | 37.802304241897204 | -122.404353336441 | (37.8023042418972, -122.404353336441) | |||
46680 | 46680 | 249916 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | Width 0ft | 6011201.85513 | 2120410.11068 | 37.8028728976405 | -122.40542793096901 | (37.8028728976405, -122.405427930969) | |||
46915 | 46915 | 249805 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | Width 0ft | 6010790.25874 | 2121038.89871 | 37.8045763727666 | -122.40689661648099 | (37.8045763727666, -122.406896616481) | |||
47640 | 47640 | 249876 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 230 Greenwich St | 12 | Back Yard : Yard 13 | Tree 1 | Private 1 | 29 | Width 0ft | 6011590.626680001 | 2120460.04582 | 37.8030317367952 | -122.40408609031 | (37.8030317367952, -122.40408609031) | |||
47761 | 47761 | 250191 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Alta St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Width 0ft | 6011795.08799 | 2119945.2148 | 37.8016295579248 | -122.40334230423099 | (37.8016295579248, -122.403342304231) | |||
51446 | 51446 | 249918 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | Width 0ft | 6011195.29362 | 2120394.33345 | 37.8028292103611 | -122.405449525493 | (37.8028292103611, -122.405449525493) | |||
51583 | 51583 | 249891 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 27 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 0ft | 6011455.072819999 | 2120426.06234 | 37.8029308517393 | -122.404552786308 | (37.8029308517393, -122.404552786308) | |||
51644 | 51644 | 249877 | Undocumented 2 | Magnolia x soulangiana :: Saucer Magnolia 92 | 230 Greenwich St | 13 | Back Yard : Yard 13 | Tree 1 | Private 1 | 39 | Width 0ft | 6011569.83125 | 2120441.49442 | 37.802979637259 | -122.404156747344 | (37.802979637259, -122.404156747344) | |||
52205 | 52205 | 249810 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 258 Chestnut St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 0ft | 6010696.08755 | 2121019.21593 | 37.804517058874396 | -122.407221117962 | (37.8045170588744, -122.407221117962) | |||
53839 | 53839 | 249807 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 258 Chestnut St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 0ft | 6010752.11734 | 2121021.55825 | 37.8045266258517 | -122.407027386026 | (37.8045266258517, -122.407027386026) | |||
54971 | 54971 | 249878 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 230 Greenwich St | 14 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | Width 0ft | 6011550.21069 | 2120457.44752 | 37.803022344253705 | -122.40422576851299 | (37.8030223442537, -122.404225768513) | |||
56133 | 56133 | 249888 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 230 Greenwich St | 24 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 0ft | 6011477.22379 | 2120439.43792 | 37.80296881573079 | -122.404477074154 | (37.8029688157308, -122.404477074154) | |||
57451 | 57451 | 249779 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 119 Pfeiffer St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | Width 0ft | 6010421.07006 | 2121139.1053400002 | 37.804830850333204 | -122.408181306135 | (37.8048308503332, -122.408181306135) | |||
59239 | 59239 | 249804 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6010798.41124 | 2121026.88639 | 37.8045438460731 | -122.406867556714 | (37.8045438460731, -122.406867556714) | |||
60877 | 60877 | 250194 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 18 Alta St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 0ft | 6011773.11718 | 2119954.14642 | 37.8016528548612 | -122.403418962409 | (37.8016528548612, -122.403418962409) | |||
61728 | 61728 | 249895 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 31 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | Width 0ft | 6011395.76102 | 2120447.38073 | 37.8029860719045 | -122.404759538639 | (37.8029860719045, -122.404759538639) | |||
67699 | 67699 | 249892 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 230 Greenwich St | 28 | Back Yard : Yard 13 | Tree 1 | Private 1 | 36 | Width 0ft | 6011427.28959 | 2120425.37078 | 37.80292740013321 | -122.404648882458 | (37.8029274001332, -122.404648882458) | |||
70496 | 70496 | 249782 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 115 Pfeiffer St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 0ft | 6010481.39254 | 2121146.06325 | 37.804853332490296 | -122.40797304381701 | (37.8048533324903, -122.407973043817) | |||
74282 | 74282 | 249879 | Undocumented 2 | Salix spp :: Willow 218 | 230 Greenwich St | 15 | Back Yard : Yard 13 | Tree 1 | Private 1 | 31 | Width 0ft | 6011548.40111 | 2120431.82846 | 37.8029518994613 | -122.404230226458 | (37.8029518994613, -122.404230226458) | |||
74458 | 74458 | 249919 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | Width 0ft | 6011190.2403 | 2120395.87946 | 37.8028331727783 | -122.405467121607 | (37.8028331727783, -122.405467121607) | |||
74522 | 74522 | 249896 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 32 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | Width 0ft | 6011386.30387 | 2120437.51769 | 37.8029584618196 | -122.404791570676 | (37.8029584618196, -122.404791570676) | |||
76467 | 76467 | 249921 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 0ft | 6011183.71747 | 2120405.40754 | 37.8028589698347 | -122.40549036550101 | (37.8028589698347, -122.405490365501) | |||
76843 | 76843 | 249887 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 230 Greenwich St | 23 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011491.952269999 | 2120439.55706 | 37.802969965942104 | -122.40442611408399 | (37.8029699659421, -122.404426114084) | |||
76949 | 76949 | 249781 | Undocumented 2 | Schinus molle :: California Pepper 138 | 119 Pfeiffer St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6010443.51385 | 2121141.6092 | 37.804838981984794 | -122.408103813361 | (37.8048389819848, -122.408103813361) | |||
129840 | 129840 | 249783 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 115 Pfeiffer St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 0ft | 6010478.38783 | 2121144.55662 | 37.804849027432105 | -122.407983335672 | (37.8048490274321, -122.407983335672) | |||
130010 | 130010 | 249997 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 39 Darrell Pl | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | Width 0ft | 6011507.582230001 | 2120247.7373900004 | 37.802444149427 | -122.40435851653 | (37.802444149427, -122.40435851653) | |||
131807 | 131807 | 249873 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 26 | Width 0ft | 6011670.78297 | 2120474.23594 | 37.8030751776447 | -122.403809705266 | (37.8030751776447, -122.403809705266) | |||
132547 | 132547 | 249917 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 0ft | 6011197.83082 | 2120409.77535 | 37.802871751897 | -122.405441833595 | (37.802871751897, -122.405441833595) | |||
133072 | 133072 | 249886 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 230 Greenwich St | 22 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 0ft | 6011494.30214 | 2120434.10693 | 37.8029551325349 | -122.404417598416 | (37.8029551325349, -122.404417598416) | |||
133186 | 133186 | 249880 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 230 Greenwich St | 16 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Width 0ft | 6011523.78476 | 2120446.01272 | 37.8029894704488 | -122.404316411196 | (37.8029894704488, -122.404316411196) | |||
133552 | 133552 | 249874 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 230 Greenwich St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 21 | Width 0ft | 6011664.0982800005 | 2120483.35155 | 37.803099833442296 | -122.403833479743 | (37.8030998334423, -122.403833479743) | |||
135843 | 135843 | 250193 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Alta St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 35 | Width 0ft | 6011782.399230001 | 2119949.71509 | 37.8016412059365 | -122.403386530161 | (37.8016412059365, -122.403386530161) | |||
147898 | 147898 | 249995 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 41 Darrell Pl | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 0ft | 6011498.48414 | 2120303.0710299998 | 37.802595573674104 | -122.404393897677 | (37.8025955736741, -122.404393897677) | |||
156630 | 156630 | 249923 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 33 | Width 0ft | 6011163.06331 | 2120405.05222 | 37.8028568393309 | -122.40556181483801 | (37.8028568393309, -122.405561814838) | |||
156801 | 156801 | 249808 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 258 Chestnut St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | Width 0ft | 6010714.23144 | 2121016.75548 | 37.80451131849129 | -122.40715815553101 | (37.8045113184913, -122.407158155531) | |||
156890 | 156890 | 249999 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 39 Darrell Pl | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 121 | Width 0ft | 6011509.9435 | 2120224.2158 | 37.8023796968334 | -122.404348688764 | (37.8023796968334, -122.404348688764) | |||
158045 | 158045 | 249890 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 230 Greenwich St | 26 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Width 0ft | 6011458.55673 | 2120431.8571900004 | 37.8029469576839 | -122.40454113827101 | (37.8029469576839, -122.404541138271) | |||
159363 | 159363 | 249970 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 213 Filbert St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 31 | Width 0ft | 6011737.037830001 | 2120086.51138 | 37.802014281606205 | -122.403553132272 | (37.8020142816062, -122.403553132272) | |||
160585 | 160585 | 249998 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 39 Darrell Pl | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | Width 0ft | 6011504.54206 | 2120237.90093 | 37.8024169710215 | -122.40436834431699 | (37.8024169710215, -122.404368344317) | |||
164095 | 164095 | 249920 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 358 Greenwich St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 35 | Width 0ft | 6011181.16541 | 2120413.994 | 37.8028824034529 | -122.405499802075 | (37.8028824034529, -122.405499802075) | |||
169417 | 169417 | 249809 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 258 Chestnut St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 0ft | 6010708.4562800005 | 2121025.2354099997 | 37.804534279087704 | -122.407178739215 | (37.8045342790877, -122.407178739215) | |||
170870 | 170870 | 249922 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | Width 0ft | 6011172.25119 | 2120397.10621 | 37.802835535282604 | -122.405529459923 | (37.8028355352826, -122.405529459923) | |||
171235 | 171235 | 249889 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 230 Greenwich St | 25 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | Width 0ft | 6011472.47528 | 2120454.19881 | 37.8030090801563 | -122.404494546207 | (37.8030090801563, -122.404494546207) | |||
171246 | 171246 | 249875 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 19 | Width 0ft | 6011656.00691 | 2120465.5569700003 | 37.803050521838706 | -122.40386022737499 | (37.8030505218387, -122.403860227375) | |||
171499 | 171499 | 249885 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 230 Greenwich St | 21 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011498.61175 | 2120434.8744 | 37.8029574806516 | -122.404402738904 | (37.8029574806516, -122.404402738904) | |||
173534 | 173534 | 249884 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 230 Greenwich St | 20 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 0ft | 6011503.3679 | 2120436.4879799997 | 37.8029621769312 | -122.404386393712 | (37.8029621769312, -122.404386393712) | |||
176393 | 176393 | 249926 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | Width 0ft | 6011142.49576 | 2120408.96257 | 37.8028664261111 | -122.405633265077 | (37.8028664261111, -122.405633265077) | |||
176394 | 176394 | 249925 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | Width 0ft | 6011155.36985 | 2120409.86411 | 37.802869621408796 | -122.40558877741002 | (37.8028696214088, -122.40558877741) | |||
179054 | 179054 | 249777 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 119 Pfeiffer St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 0ft | 6010400.427069999 | 2121136.58311 | 37.8048227690275 | -122.40825256571001 | (37.8048227690275, -122.40825256571) | |||
179841 | 179841 | 249924 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | Width 0ft | 6011171.36702 | 2120411.09017 | 37.802873882370896 | -122.405533505089 | (37.8028738823709, -122.405533505089) | |||
180980 | 180980 | 249806 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | Width 0ft | 6010784.31321 | 2121039.01987 | 37.804576372755605 | -122.406917200191 | (37.8045763727556, -122.406917200191) | |||
183681 | 183681 | 250308 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 10 Redfield Aly | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 0ft | 6008483.77451 | 2119506.40025 | 37.8002391853351 | -122.41476992380801 | (37.8002391853351, -122.414769923808) | |||
185525 | 185525 | 249893 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 29 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | Width 0ft | 6011394.800530001 | 2120441.53452 | 37.8029699659579 | -122.404762450627 | (37.8029699659579, -122.404762450627) | |||
188029 | 188029 | 249872 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 230 Greenwich St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011683.12279 | 2120489.80597 | 37.8031186185004 | -122.403768099014 | (37.8031186185004, -122.403768099014) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");