trees
47 rows where Supervisor Districts = 2 and qSpecies_id = 54
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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
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) );