trees
58 rows where PlotSize = "Width 2ft" and qSpecies_id = 65 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1806 | 221820 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 368 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 2ft | 6007294.28583 | 2096507.5919 | 37.7370229743371 | -122.417255362169 | (37.7370229743371, -122.417255362169) | 2 | 7 | 7 | 28859 | 2 | |||
2752 | 221825 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 499X Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008302.15962 | 2096532.14097 | 37.7371470321954 | -122.41377241466 | (37.7371470321954, -122.41377241466) | 2 | 7 | 7 | 28859 | 2 | |||
12895 | 221826 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 499X Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008314.44854 | 2096531.09899 | 37.7371448612571 | -122.413729852457 | (37.7371448612571, -122.413729852457) | 2 | 7 | 7 | 28859 | 2 | |||
19306 | 221827 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 499X Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008328.718 | 2096529.81834 | 37.7371421461853 | -122.413680425731 | (37.7371421461853, -122.413680425731) | 2 | 7 | 7 | 28859 | 2 | |||
32001 | 221822 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 129 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007356.42456 | 2097004.67982 | 37.7383913638823 | -122.417075731561 | (37.7383913638823, -122.417075731561) | 2 | 7 | 7 | 28859 | 2 | |||
20543 | 203531 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 355 Granada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 5995610.31086 | 2092357.07195 | 37.7249623857941 | -122.457351672459 | (37.7249623857941, -122.457351672459) | 9 | 7 | 4 | 28861 | 40 | |||
22793 | 221849 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6004448.4556 | 2095570.1665 | 37.7342884984186 | -122.427027930603 | (37.7342884984186, -122.427027930603) | 2 | 7 | 5 | 28861 | 25 | |||
28695 | 221842 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 5 Marsily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 2ft | 6004251.52018 | 2095424.77714 | 37.7338781539609 | -122.427698444448 | (37.7338781539609, -122.427698444448) | 2 | 7 | 5 | 28861 | 25 | |||
29348 | 221851 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6004484.38042 | 2095546.73676 | 37.7342261969882 | -122.426902058798 | (37.7342261969882, -122.426902058798) | 2 | 7 | 5 | 28861 | 25 | |||
36536 | 175211 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 66 Madison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6005436.48818 | 2093200.64124 | 37.7278381272226 | -122.423443582752 | (37.7278381272226, -122.423443582752) | 9 | 7 | 6 | 28861 | 5 | |||
38029 | 203546 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 431 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 2ft | 5997874.7531 | 2094083.70134 | 37.7298331050033 | -122.449648149961 | (37.7298331050033, -122.449648149961) | 9 | 7 | 4 | 28861 | 40 | |||
38326 | 221845 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6004371.42755 | 2095618.1193 | 37.7344158100226 | -122.427297656166 | (37.7344158100226, -122.427297656166) | 2 | 7 | 5 | 28861 | 25 | |||
55860 | 175179 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 450 Italy Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6001771.83891 | 2089201.36797 | 37.7166495024579 | -122.43582630935 | (37.7166495024579, -122.43582630935) | 9 | 7 | 6 | 28861 | 5 | |||
66471 | 221841 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 5 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 6004259.60988 | 2095362.69857 | 37.7337081577855 | -122.42766605444 | (37.7337081577855, -122.42766605444) | 2 | 7 | 5 | 28861 | 25 | |||
69139 | 221840 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 98 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 2ft | 6004312.44121 | 2095336.44977 | 37.7336390727743 | -122.427481531566 | (37.7336390727743, -122.427481531566) | 2 | 7 | 5 | 28861 | 25 | |||
71152 | 221844 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 127 Saint Marys Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6004153.19016 | 2095736.31086 | 37.7347279926082 | -122.428060594226 | (37.7347279926082, -122.428060594226) | 2 | 7 | 5 | 28861 | 25 | |||
80067 | 221843 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 124 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 2ft | 6004594.79724 | 2095953.61848 | 37.7353496453739 | -122.426549275423 | (37.7353496453739, -122.426549275423) | 2 | 7 | 5 | 28861 | 2 | |||
93508 | 203530 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 355 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5995608.47907 | 2092372.56646 | 37.7250048247995 | -122.457359125149 | (37.7250048247995, -122.457359125149) | 9 | 7 | 4 | 28861 | 40 | |||
95747 | 221850 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6004464.56621 | 2095558.73638 | 37.7342580248697 | -122.426971417216 | (37.7342580248697, -122.426971417216) | 2 | 7 | 5 | 28861 | 25 | |||
119492 | 203554 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5994942.92929 | 2088379.09284 | 37.7140014477918 | -122.459370769157 | (37.7140014477918, -122.459370769157) | 9 | 8 | 6 | 28861 | 24 | |||
127453 | 203538 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 313 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5999326.9827 | 2094355.31618 | 37.7306618716326 | -122.444647158563 | (37.7306618716326, -122.444647158563) | 9 | 7 | 4 | 28861 | 40 | |||
151528 | 175210 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 66 Madison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 6005427.44885 | 2093231.28592 | 37.7279217605751 | -122.423477009653 | (37.7279217605751, -122.423477009653) | 9 | 7 | 6 | 28861 | 5 | |||
159787 | 203555 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Farallones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5994968.99544 | 2088379.28856 | 37.7140034838548 | -122.459280689461 | (37.7140034838548, -122.459280689461) | 9 | 8 | 6 | 28861 | 24 | |||
160387 | 203556 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Farallones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5994991.30881 | 2088378.07982 | 37.7140014477822 | -122.45920347906 | (37.7140014477822, -122.45920347906) | 9 | 8 | 6 | 28861 | 24 | |||
166822 | 221848 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6004429.19741 | 2095585.11426 | 37.7343284525969 | -122.427095576708 | (37.7343284525969, -122.427095576708) | 2 | 7 | 5 | 28861 | 25 | |||
167184 | 221846 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6004388.2708 | 2095606.1808 | 37.7343839821397 | -122.427238573395 | (37.7343839821397, -122.427238573395) | 2 | 7 | 5 | 28861 | 25 | |||
168312 | 175182 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 647 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002406.62971 | 2090005.70634 | 37.718894076269 | -122.433689610108 | (37.718894076269, -122.433689610108) | 9 | 7 | 6 | 28861 | 5 | |||
172356 | 175209 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 9 Athens St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6005385.77988 | 2093250.96165 | 37.7279734338052 | -122.423622458831 | (37.7279734338052, -122.423622458831) | 9 | 7 | 6 | 28861 | 5 | |||
177042 | 221839 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 98 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6004329.20117 | 2095336.95284 | 37.7336414020218 | -122.42742362331 | (37.7336414020218, -122.42742362331) | 2 | 7 | 5 | 28861 | 25 | |||
183128 | 175208 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 9 Athens St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6005371.81589 | 2093231.88981 | 37.727920278496 | -122.423669377345 | (37.727920278496, -122.423669377345) | 9 | 7 | 6 | 28861 | 5 | |||
186585 | 175207 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 9 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6005359.84242 | 2093211.49837 | 37.7278636122004 | -122.423709320725 | (37.7278636122004, -122.423709320725) | 9 | 7 | 6 | 28861 | 5 | |||
192333 | 221847 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004411.28278 | 2095593.12873 | 37.7343494454616 | -122.427158084072 | (37.7343494454616, -122.427158084072) | 2 | 7 | 5 | 28861 | 25 | |||
125012 | 221854 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4418 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6000475.00831 | 2102295.38218 | 37.7525288566262 | -122.441247749083 | (37.7525288566262, -122.441247749083) | 2 | 4 | 5 | 28862 | 22 | |||
59779 | 221868 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 30 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5997080.14125 | 2106419.81481 | 37.7636595407827 | -122.45328544896 | (37.7636595407827, -122.45328544896) | 15 | 5 | 11 | 29492 | 12 | |||
117834 | 221786 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 65 Scott St | 1 | : | Tree | Private 2 | 20 | Width 2ft | 6002363.3837 | 2108638.99661 | 37.7700542727214 | -122.435171122647 | (37.7700542727214, -122.435171122647) | 15 | 5 | 5 | 29492 | 9 | |||
124027 | 124414 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 111 Cherry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 5996072.31903 | 2115814.16927 | 37.7893961490256 | -122.457450879091 | (37.7893961490256, -122.457450879091) | 11 | 6 | 1 | 54 | 31 | |||
146558 | 117937 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 852 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5982958.99767 | 2109991.00517 | 37.7726455076262 | -122.502389596139 | (37.7726455076262, -122.502389596139) | 11 | 6 | 2 | 55 | 26 | |||
76975 | 203510 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1366 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5993979.28828 | 2106206.5915 | 37.7628958661671 | -122.46399477014 | (37.7628958661671, -122.46399477014) | 1 | 5 | 11 | 56 | 12 | |||
101049 | 203522 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 62 Aloha Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5991862.2088 | 2104389.33207 | 37.7577839146257 | -122.471184538744 | (37.7577839146257, -122.471184538744) | 1 | 8 | 4 | 56 | 12 | |||
101822 | 203519 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1531 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5994271.83336 | 2105139.6012 | 37.7599830430151 | -122.462905551751 | (37.7599830430151, -122.462905551751) | 1 | 5 | 4 | 56 | 12 | |||
137299 | 203520 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1537 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5994273.74981 | 2105115.42997 | 37.7599167854573 | -122.462897170087 | (37.7599167854573, -122.462897170087) | 1 | 5 | 4 | 56 | 12 | |||
151328 | 203513 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 112 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5993653.12973 | 2102595.20165 | 37.7529611229783 | -122.464860549271 | (37.7529611229783, -122.464860549271) | 1 | 8 | 4 | 56 | 12 | |||
20470 | 203539 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 350 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5999078.20964 | 2094394.83884 | 37.7307561925253 | -122.445510042754 | (37.7307561925253, -122.445510042754) | 9 | 7 | 4 | 59 | 40 | |||
29613 | 218232 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 371 Wawona St | 1 | : | Tree | Private 2 | 33 | Width 2ft | 5991901.5455 | 2097060.86466 | 37.7376641082099 | -122.47051476505 | (37.7376641082099, -122.47051476505) | 1 | 8 | 4 | 59 | 40 | |||
39358 | 203544 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 522 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 2ft | 5997938.28847 | 2094411.07212 | 37.730735622335 | -122.449452080662 | (37.730735622335, -122.449452080662) | 9 | 7 | 4 | 59 | 40 | |||
90909 | 203532 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 935 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5996459.44919 | 2098104.63925 | 37.7407925546419 | -122.454831394377 | (37.7407925546419, -122.454831394377) | 9 | 7 | 4 | 59 | 40 | |||
98589 | 203535 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 68 Rosewood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5994859.58645 | 2095502.43187 | 37.7335556327814 | -122.460174598491 | (37.7335556327814, -122.460174598491) | 9 | 8 | 4 | 59 | 40 | |||
102836 | 203534 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 149 Casitas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5995350.02472 | 2096965.99603 | 37.7376024192215 | -122.45858493525 | (37.7376024192215, -122.45858493525) | 9 | 7 | 4 | 59 | 40 | |||
150799 | 203533 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 149 Casitas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5995336.83178 | 2096965.96659 | 37.737601580145 | -122.458630547087 | (37.737601580145, -122.458630547087) | 9 | 7 | 4 | 59 | 40 | |||
23185 | 241540 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 191 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | Width 2ft | Permit Number 780010 | 6004426.52656 | 2097222.39048 | 37.7388238918993 | -122.427221397276 | (37.7388238918993, -122.427221397276) | 2 | 7 | 5 | 63 | 7 | |
35034 | 221861 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 246 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6004637.65749 | 2096950.59035 | 37.7380895280136 | -122.426472056954 | (37.7380895280136, -122.426472056954) | 2 | 7 | 5 | 63 | 7 | |||
43199 | 221866 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 53 Wilder St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6002528.4957 | 2095557.08411 | 37.734143822686 | -122.433664907521 | (37.734143822686, -122.433664907521) | 2 | 7 | 5 | 63 | 7 | |||
72457 | 221800 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 170 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 2ft | 6004805.17774 | 2099321.48503 | 37.7446089338676 | -122.42606158838 | (37.7446089338676, -122.42606158838) | 2 | 7 | 5 | 63 | 22 | |||
76757 | 203585 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 122 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5999428.77785 | 2093578.76175 | 37.7285354426355 | -122.444239456297 | (37.7285354426355, -122.444239456297) | 9 | 7 | 4 | 63 | 40 | |||
130490 | 221857 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 679 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002187.97645 | 2099712.96384 | 37.7455355755051 | -122.435139333412 | (37.7455355755051, -122.435139333412) | 2 | 7 | 5 | 63 | 22 | |||
136628 | 221862 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 252 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004616.62035 | 2096933.09811 | 37.7380403090218 | -122.426543547661 | (37.7380403090218, -122.426543547661) | 2 | 7 | 5 | 63 | 7 | |||
153032 | 243747 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 217 Whitney St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | Width 2ft | Permit Number 780010 | 6004399.27823 | 2097187.62567 | 37.7387268946327 | -122.427313133507 | (37.7387268946327, -122.427313133507) | 2 | 7 | 5 | 63 | 7 | |
161078 | 221858 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 677 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6002223.92198 | 2099714.60458 | 37.7455421216803 | -122.435015156842 | (37.7455421216803, -122.435015156842) | 2 | 7 | 5 | 63 | 22 |
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) );