58 rows where qSpecies_id = 112

View and edit SQL

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
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
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
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
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
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
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

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);