trees

47 rows where Supervisor Districts = 2 and qSpecies_id = 54

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor Districts ✖

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)
13226 141684 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2350 TURK BLVD 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5998631.8104 2111816.1017 37.7785651829019 -122.448307345965 (37.7785651829019, -122.448307345965) 15 6 2 54 16
16609 141535 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2901 TURK BLVD 6 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5996788.0463 2111499.0832 37.777589151551 -122.454662685268 (37.777589151551, -122.454662685268) 15 6 2 54 16
19779 140264 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2100X Grove St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   5997701.9343 2110276.144 37.7742836533846 -122.451413027686 (37.7742836533846, -122.451413027686) 15 5 2 29492 16
21051 141109 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 154 WOOD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5998503.1758 2112860.4826 37.7814254265925 -122.448827586566 (37.7814254265925, -122.448827586566) 15 6 2 54 16
25823 140682 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 21366 GROVE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5997596.5061 2110261.2804 37.7742368042101 -122.451776648803 (37.7742368042101, -122.451776648803) 15 5 2 29492 16
26924 142123 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 15 HEMWAY TER 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   5998622.5379 2110844.3781 37.7758965505953 -122.448269431558 (37.7758965505953, -122.448269431558) 15 6 2 29492 16
33127 141688 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2350 TURK BLVD 7 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5998531.7594 2111801.3756 37.7785190283548 -122.448652398208 (37.7785190283548, -122.448652398208) 15 6 2 54 16
41596 141533 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2901 TURK BLVD 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5996746.9 2111493.597 37.7775717277647 -122.454804626881 (37.7775717277647, -122.454804626881) 15 6 2 54 16
46831 140683 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 21288 GROVE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   5997608.0859 2110262.8359 37.7742417384078 -122.451736704617 (37.7742417384078, -122.451736704617) 15 5 2 29492 16
49221 141496 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2901 TURK BLVD 20 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5997041.2335 2111532.8232 37.7776963116019 -122.453789267371 (37.7776963116019, -122.453789267371) 15 6 2 54 16
51226 141659 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 16 LOYOLA TER 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5998449.6222 2110830.3835 37.7758482379963 -122.448866580658 (37.7758482379963, -122.448866580658) 15 6 2 29492 16
53828 141681 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2340 TURK BLVD 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5998731.3741 2111830.7737 37.77861116004 -122.447963975147 (37.77861116004, -122.447963975147) 15 6 2 54 16
56007 141531 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2901 TURK BLVD 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5996721.1149 2111488.1108 37.7775551849979 -122.454893429194 (37.7775551849979, -122.454893429194) 15 6 2 54 16
56244 28068 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 3445 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   5996452.8473 2112841.7002 37.78125639187 -122.455919329089 (37.78125639187, -122.455919329089) 11 6 2 54 16
58266 141680 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2340 TURK BLVD 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5998758.0111 2111834.2387 37.7786221965848 -122.447872077437 (37.7786221965848, -122.447872077437) 15 6 2 54 16
59245 141686 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2350 TURK BLVD 5 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5998577.2371 2111809.6049 37.7785442242281 -122.448495667047 (37.7785442242281, -122.448495667047) 15 6 2 54 16
59705 141685 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2350 TURK BLVD 4 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5998607.1225 2111811.7705 37.7785518790932 -122.448392438493 (37.7785518790932, -122.448392438493) 15 6 2 54 16
60248 53539 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 322 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/11/1969 12:00:00 AM     Permit Number 776401 5995280.52661988 2113383.63166464 37.7826770367733 -122.460014224406 (37.7826770367733, -122.460014224406) 11 6 2 54 11
65008 141488 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2901 TURK BLVD 12 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5996896.3984 2111514.1702 37.7776367906711 -122.454288950996 (37.7776367906711, -122.454288950996) 15 6 2 54 16
72300 251046 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 5625 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5989523.2215 2112593.8297 37.7801756529596 -122.479874006145 (37.7801756529596, -122.479874006145) 11 6 2 55 26
74673 141682 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2350 TURK BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5998677.6671 2111822.1113 37.7785843052603 -122.448149143618 (37.7785843052603, -122.448149143618) 15 6 2 54 16
75631 141679 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2340 TURK BLVD 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5998783.9983 2111836.4043 37.778629628102 -122.44778233403 (37.778629628102, -122.44778233403) 15 6 2 54 16
79150 141683 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2350 TURK BLVD 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5998655.4155 2111819.7833 37.778576641114 -122.448225952422 (37.778576641114, -122.448225952422) 15 6 2 54 16
82175 64038 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 16 Loyola Ter 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/1988 12:00:00 AM 10   Permit Number 25745 5998453.4174 2110814.7286 37.7758054707119 -122.44885232426 (37.7758054707119, -122.44885232426) 15 6 2 29492 16
83182 141692 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 392 EWING TER 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5998708.9601 2112320.4172 37.7799543130642 -122.44807677808 (37.7799543130642, -122.44807677808) 15 6 2 54 16
86447 141678 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2340 TURK BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5998817.5652 2111841.8183 37.7786464120147 -122.447666603511 (37.7786464120147, -122.447666603511) 15 6 2 54 16
86985 141695 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 392 EWING TER 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5998748.3741 2112341.6402 37.7800148388988 -122.447941956435 (37.7800148388988, -122.447941956435) 15 6 2 54 16
90734 141660 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 16 LOYOLA TER 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5998448.6735 2110841.7689 37.7758794451161 -122.448870682731 (37.7758794451161, -122.448870682731) 15 6 2 29492 16
92829 9075 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 5612 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   5989561.9341 2112697.6008 37.7804628284507 -122.479747678424 (37.7804628284507, -122.479747678424) 11 6 2 55 26
107570 141696 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 392 EWING TER 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5998768.2977 2112343.8058 37.7800219238864 -122.447873187985 (37.7800219238864, -122.447873187985) 15 6 2 54 16
110225 61148 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2237 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/28/1983 12:00:00 AM 7   Permit Number 21005 5997050.2982 2110479.7459 37.7748053558267 -122.453681848705 (37.7748053558267, -122.453681848705) 15 5 2 29492 16
116510 141694 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 392 EWING TER 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5998733.648 2112339.0414 37.780006861514 -122.44799271326 (37.780006861514, -122.44799271326) 15 6 2 54 16
127244 107346 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 247 Collins St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   5998163.7387 2112864.5437 37.7814171604492 -122.450002161775 (37.7814171604492, -122.450002161775) 15 6 2 54 16
136338 141689 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2350 TURK BLVD 8 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5998480.6511 2111795.7451 37.778500645915 -122.448828794796 (37.778500645915, -122.448828794796) 15 6 2 54 16
137279 141490 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2901 TURK BLVD 14 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5996921.6348 2111517.4619 37.7776472759958 -122.454201888036 (37.7776472759958, -122.454201888036) 15 6 2 54 16
140116 64012 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 10 Loyola Ter 1 Sidewalk: Curb side : Cutout Tree Private 2   10/08/1987 12:00:00 AM 10   Permit Number 24766 5998456.7381 2110792.4322 37.7757444404433 -122.44883923079 (37.7757444404433, -122.44883923079) 15 6 2 29492 16
143879 64376 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 69 Beaumont Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/1988 12:00:00 AM 11   Permit Number 25215 5996673.1599 2112554.0417 37.7804791997483 -122.455136367138 (37.7804791997483, -122.455136367138) 11 6 2 54 16
148222 141693 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 392 EWING TER 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5998717.1894 2112334.7102 37.7799940283513 -122.448049338774 (37.7799940283513, -122.448049338774) 15 6 2 54 16
150274 251080 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 5616 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5989535.588 2112697.0631 37.7804598215152 -122.47983878159 (37.7804598215152, -122.47983878159) 11 6 2 55 26
150650 141486 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2901 TURK BLVD 10 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5996862.6584 2111508.4097 37.77761903893 -122.454405252217 (37.77761903893, -122.454405252217) 15 6 2 54 16
150946 142150 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 20 Stanyan Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5996389.5624 2112799.0591 37.7811356783284 -122.456135178495 (37.7811356783284, -122.456135178495) 11 6 2 54 16
151344 9008 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 5255 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   5990650.4547 2112633.3493 37.7803495870008 -122.475977319009 (37.7803495870008, -122.475977319009) 11 6 2 54 26
157652 28067 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 3445 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   5996427.4656 2112840.3465 37.7812512181791 -122.456007038851 (37.7812512181791, -122.456007038851) 11 6 2 54 16
158612 141687 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2350 TURK BLVD 6 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5998550.3836 2111804.4075 37.778528418096 -122.448588188719 (37.778528418096, -122.448588188719) 15 6 2 54 16
167541 251079 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 5616 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5989547.9545 2112698.1385 37.7804634926969 -122.479796079248 (37.7804634926969, -122.479796079248) 11 6 2 55 26
181049 9074 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 5612 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   5989576.4513 2112697.6008 37.780463671789 -122.479697457165 (37.780463671789, -122.479697457165) 11 6 2 55 26
192913 142130 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 24 HEMWAY TER 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5998647.6806 2110905.5745 37.7760660175212 -122.448186864357 (37.7760660175212, -122.448186864357) 15 6 2 29492 16

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