trees
58 rows where qSpecies_id = 112 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
494 | 126450 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 2401 Broadway | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6002086.73219 | 2117346.55126 | 37.7939472989795 | -122.436751464412 | (37.7939472989795, -122.436751464412) | 13 | 9 | 1 | 29490 | 27 | |||
3305 | 78320 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 830 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6009222.35213 | 2090505.20731 | 37.7206499863841 | -122.41016549564 | (37.7206499863841, -122.41016549564) | 9 | 3 | 7 | 309 | 28 | |||
5630 | 126445 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 2601 Vallejo St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6001071.40482 | 2117563.77475 | 37.7944859829844 | -122.440280173895 | (37.7944859829844, -122.440280173895) | 13 | 9 | 1 | 57 | 27 | |||
6335 | 262305 | Property Tree 8 | Casuarina cunninghamiana :: Horsetail pine 112 | 100 Saint Elmo Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994960 | 2094889 | 37.7318770738882 | -122.459783023889 | (37.7318770738882, -122.459783023889) | 9 | 8 | 4 | 59 | 40 | ||||
14656 | 72595 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 1342 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5988674.2474 | 2106188.616 | 37.7625393471524 | -122.482341528113 | (37.7625393471524, -122.482341528113) | 1 | 8 | 3 | 56 | 35 | |||
14942 | 200139 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 700 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015356.8365 | 2088295.9747 | 37.7149258068198 | -122.388806166206 | (37.7149258068198, -122.388806166206) | 10 | 3 | 8 | 58 | 1 | |||
15087 | 73785 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 1342 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 5988676.4118 | 2106176.1706 | 37.7625053013705 | -122.482333130438 | (37.7625053013705, -122.482333130438) | 1 | 8 | 3 | 56 | 35 | |||
33166 | 188396 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 760 De Haro St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 9ft | 6012087.53124 | 2104906.41164 | 37.760352821738 | -122.401272892241 | (37.760352821738, -122.401272892241) | 10 | 3 | 8 | 28856 | 29 | |||
37761 | 223871 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 310 Liberty St | 17 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6004161.87105 | 2103941.42083 | 37.7572578193179 | -122.428615273583 | (37.7572578193179, -122.428615273583) | 2 | 4 | 5 | 28862 | 3 | |||
40735 | 126442 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 1601 Beach St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6002503.29983 | 2121235.66202 | 37.8046494462659 | -122.435588461158 | (37.8046494462659, -122.435588461158) | 13 | 9 | 1 | 57 | 17 | |||
58622 | 191031 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 601 Wisconsin St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6012727.00633 | 2104624.78835 | 37.7596152022936 | -122.399041463801 | (37.7596152022936, -122.399041463801) | 10 | 3 | 8 | 28856 | 29 | |||
65064 | 248010 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 525 Franconia St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 6ft | 6009913.14391 | 2098013.75729 | 37.7413055683981 | -122.408306955813 | (37.7413055683981, -122.408306955813) | 10 | 7 | 7 | 28859 | 2 | |||
65453 | 222617 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 100 Alemany Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6009476.82637 | 2095975.18511 | 37.7356836481774 | -122.409671740872 | (37.7356836481774, -122.409671740872) | 10 | 7 | 7 | 28859 | 2 | |||
71353 | 204702 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 1701 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5990288.33301 | 2106501.46876 | 37.7634921149022 | -122.47678191195 | (37.7634921149022, -122.47678191195) | 1 | 8 | 3 | 56 | 12 | |||
71356 | 187346 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 2200 Sunset Blvd | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985099.3282 | 2099721.0758 | 37.7445726628756 | -122.494228962515 | (37.7445726628756, -122.494228962515) | 1 | 8 | 3 | 29491 | 35 | |||
76412 | 222618 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 100 Alemany Blvd | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009365.79343 | 2095894.2189 | 37.7354551097631 | -122.410049912076 | (37.7354551097631, -122.410049912076) | 10 | 7 | 7 | 28859 | 2 | |||
76483 | 187347 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 2200 Sunset Blvd | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985050.239 | 2099735.2948 | 37.7446088316551 | -122.49439974859 | (37.7446088316551, -122.49439974859) | 1 | 8 | 3 | 29491 | 35 | |||
78733 | 184436 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 3832 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5981489.6965 | 2100816.3891 | 37.7473681966369 | -122.506791353844 | (37.7473681966369, -122.506791353844) | 1 | 8 | 3 | 29491 | 35 | |||
81360 | 200141 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 700 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015336.2607 | 2088334.3204 | 37.7150299562444 | -122.388879960947 | (37.7150299562444, -122.388879960947) | 10 | 3 | 8 | 58 | 1 | |||
83149 | 248015 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 525 Franconia St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 4ft | 6009932.57505 | 2098116.00254 | 37.7415873997489 | -122.408246979117 | (37.7415873997489, -122.408246979117) | 10 | 7 | 7 | 28859 | 2 | |||
84773 | 184086 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 1600 Sunset Blvd | 87 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984957.3486 | 2104087.5098 | 37.7565533840583 | -122.495041800117 | (37.7565533840583, -122.495041800117) | 1 | 8 | 3 | 56 | 35 | |||
89474 | 126447 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 2656 Broderick St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6000161.29387 | 2117775.76551 | 37.7950161944827 | -122.44344449519 | (37.7950161944827, -122.44344449519) | 13 | 9 | 1 | 57 | 27 | |||
89834 | 223872 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 310 Liberty St | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 6004160.81529 | 2103945.20592 | 37.7572681525309 | -122.428619194619 | (37.7572681525309, -122.428619194619) | 2 | 4 | 5 | 28862 | 3 | |||
92654 | 222622 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 1403 Douglass St | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6001405.60814 | 2099658.97548 | 37.7453428786853 | -122.437840770053 | (37.7453428786853, -122.437840770053) | 2 | 7 | 5 | 63 | 22 | |||
93590 | 223870 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 310 Liberty St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6004165.7339 | 2103945.48087 | 37.7572691858373 | -122.428602203741 | (37.7572691858373, -122.428602203741) | 2 | 4 | 5 | 28862 | 3 | |||
99502 | 200140 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 700 Jamestown Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015344.6781 | 2088315.6151 | 37.7149790616643 | -122.388849561469 | (37.7149790616643, -122.388849561469) | 10 | 3 | 8 | 58 | 1 | |||
103601 | 223873 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 310 Liberty St | 53 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003827.49895 | 2103926.48833 | 37.757197889383 | -122.429770597528 | (37.757197889383, -122.429770597528) | 2 | 4 | 5 | 28862 | 3 | |||
105344 | 126449 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 2401 Broadway | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6002081.41043 | 2117344.80364 | 37.7939421980234 | -122.436769753035 | (37.7939421980234, -122.436769753035) | 13 | 9 | 1 | 29490 | 27 | |||
107127 | 222616 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 100 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009648.80711 | 2096248.24649 | 37.7364430518981 | -122.409096395993 | (37.7364430518981, -122.409096395993) | 10 | 7 | 7 | 28859 | 2 | |||
108097 | 126444 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 2601 Vallejo St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6001059.38792 | 2117563.4406 | 37.7944843813066 | -122.440321729778 | (37.7944843813066, -122.440321729778) | 13 | 9 | 1 | 57 | 27 | |||
116379 | 248019 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 525 Franconia St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6009962.41848 | 2098212.02892 | 37.741852738408 | -122.408150561002 | (37.741852738408, -122.408150561002) | 10 | 7 | 7 | 28859 | 2 | |||
118596 | 126446 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 2656 Broderick St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6000160.0682 | 2117773.16546 | 37.7950089855344 | -122.443448549322 | (37.7950089855344, -122.443448549322) | 13 | 9 | 1 | 57 | 27 | |||
125755 | 204704 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 1701 Irving St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5990371.25776 | 2106504.61857 | 37.7635055732383 | -122.476495334897 | (37.7635055732383, -122.476495334897) | 1 | 8 | 3 | 56 | 12 | |||
127320 | 126440 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 3700 Webster St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6002594.85565 | 2121336.78528 | 37.8049323037346 | -122.435278861456 | (37.8049323037346, -122.435278861456) | 13 | 9 | 1 | 57 | 17 | |||
136065 | 248012 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 525 Franconia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6009917.55831 | 2098055.52867 | 37.7414205107404 | -122.408294637814 | (37.7414205107404, -122.408294637814) | 10 | 7 | 7 | 28859 | 2 | |||
142661 | 126439 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 3700 Webster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6002595.71169 | 2121316.79455 | 37.8048774630812 | -122.43527446824 | (37.8048774630812, -122.43527446824) | 13 | 9 | 1 | 57 | 17 | |||
143720 | 126441 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 1601 Beach St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6002491.85461 | 2121233.39773 | 37.8046425790601 | -122.435627906308 | (37.8046425790601, -122.435627906308) | 13 | 9 | 1 | 57 | 17 | |||
148689 | 200798 | Undocumented 4 | Casuarina cunninghamiana :: Horsetail pine 112 | 700 Jamestown Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015296.9798 | 2088405.4002 | 37.71522295028 | -122.389020693471 | (37.71522295028, -122.389020693471) | 10 | 3 | 8 | 58 | 1 | |||
149831 | 251698 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 700 Jamestown Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6015296.9798 | 2088405.4002 | 37.71522295028 | -122.389020693471 | (37.71522295028, -122.389020693471) | 10 | 3 | 8 | 58 | 1 | ||||
155225 | 204703 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 1701 Irving St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5990335.67224 | 2106502.91932 | 37.7634988436072 | -122.476618288403 | (37.7634988436072, -122.476618288403) | 1 | 8 | 3 | 56 | 12 | |||
156405 | 204700 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 1708 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5990418.27546 | 2106568.79929 | 37.763684523058 | -122.476337405841 | (37.763684523058, -122.476337405841) | 11 | 8 | 3 | 56 | 12 | |||
157352 | 185557 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 2201 Sunset Blvd | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984925.3425 | 2099814.4466 | 37.7448188508638 | -122.494837444262 | (37.7448188508638, -122.494837444262) | 1 | 8 | 3 | 29491 | 35 | |||
157875 | 126443 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 2601 Vallejo St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6001049.1036 | 2117561.90352 | 37.7944795753318 | -122.440357204422 | (37.7944795753318, -122.440357204422) | 13 | 9 | 1 | 57 | 27 | |||
159064 | 200797 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 700 Jamestown Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015309.1382 | 2088387.6302 | 37.7151748312567 | -122.388977428453 | (37.7151748312567, -122.388977428453) | 10 | 3 | 8 | 58 | 1 | |||
165483 | 204699 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 1325 18th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 6ft | 5990483.27142 | 2106360.56489 | 37.7631165364244 | -122.476097397488 | (37.7631165364244, -122.476097397488) | 1 | 8 | 3 | 56 | 12 | |||
167361 | 184077 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 1600 Sunset Blvd | 78 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984949.117 | 2104038.1203 | 37.7564172922771 | -122.495066625722 | (37.7564172922771, -122.495066625722) | 1 | 8 | 3 | 56 | 35 | |||
168272 | 185435 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 2300 Sunset Blvd | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985116.6315 | 2099415.327 | 37.7437341719949 | -122.494146601349 | (37.7437341719949, -122.494146601349) | 1 | 8 | 3 | 29491 | 35 | |||
172960 | 173598 | Significant Tree 6 | Casuarina cunninghamiana :: Horsetail pine 112 | 1771 11th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12 | 3x3 | 5992768 | 2103420 | 37.7551747322674 | -122.467981458634 | (37.7551747322674, -122.467981458634) | 1 | 8 | 4 | 56 | 12 | |||
173877 | 222620 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 2080 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008061.85014 | 2106305.07413 | 37.7639678076815 | -122.41529490396 | (37.7639678076815, -122.41529490396) | 8 | 4 | 7 | 28859 | 19 | |||
175104 | 185561 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 2201 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984873.8699 | 2099777.8321 | 37.7447153042466 | -122.495012724857 | (37.7447153042466, -122.495012724857) | 1 | 8 | 3 | 29491 | 35 | |||
177038 | 187359 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 2200 Sunset Blvd | 44 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985046.8536 | 2099804.0196 | 37.7447973331953 | -122.494416519492 | (37.7447973331953, -122.494416519492) | 1 | 8 | 3 | 29491 | 35 | |||
177218 | 126448 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 2401 Broadway | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6002040.59654 | 2117340.69483 | 37.7939285966777 | -122.436910678583 | (37.7939285966777, -122.436910678583) | 13 | 9 | 1 | 29490 | 27 | |||
179155 | 204701 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 1708 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5990405.41807 | 2106567.82065 | 37.7636810903261 | -122.476381803596 | (37.7636810903261, -122.476381803596) | 11 | 8 | 3 | 56 | 12 | |||
180569 | 222621 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 275 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007804.56184 | 2106235.52037 | 37.7637623656696 | -122.416179863805 | (37.7637623656696, -122.416179863805) | 8 | 4 | 7 | 28859 | 19 | |||
188368 | 248017 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 525 Franconia St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 6ft | 6009948.88401 | 2098163.64009 | 37.7417191153415 | -122.408193947005 | (37.7417191153415, -122.408193947005) | 10 | 7 | 7 | 28859 | 2 | |||
150818 | 40047 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 1748 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1999 12:00:00 AM | 15 | Permit Number 41284 | 6014490.89885 | 2095235.14935 | 37.7339313623407 | -122.392284274492 | (37.7339313623407, -122.392284274492) | 10 | 3 | 8 | 58 | 1 | |
25840 | 82708 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 728 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 14 | 3x3 | Permit Number 52492 | 6015291.25471 | 2088404.66417 | 37.7152206119305 | -122.389040430684 | (37.7152206119305, -122.389040430684) | 10 | 3 | 8 | 58 | 1 | |
162790 | 82707 | Permitted Site 7 | Casuarina cunninghamiana :: Horsetail pine 112 | 728 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 10 | 3x3 | Permit Number 52492 | 6015289.4977 | 2088419.4291 | 37.715261056172 | -122.389047534015 | (37.715261056172, -122.389047534015) | 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) );