trees

26 rows where Neighborhoods (old) = 32 and qSpecies_id = 54

✎ View and edit SQL

This data as json, CSV (advanced)

Neighborhoods (old) ✖

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)
25242 142827 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1714 POLK ST 1 Sidewalk: Curb side : Pot Tree Private 2     5 Width 0ft   6006619.3625 2116773.8493 37.7926313555217 -122.421027406021 (37.7926313555217, -122.421027406021) 13 9 10 28858 32
31104 142596 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 365 COLUMBUS AVE 7 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6008359.2007 2120780.7848 37.8037313259866 -122.415291263605 (37.8037313259866, -122.415291263605) 5 1 10 308 32
46849 99233 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1111 Columbus Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008063.2168 2121048.832 37.8044506767497 -122.416334531861 (37.8044506767497, -122.416334531861) 5 1 10 308 32
47497 142605 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 700 CHESTNUT ST 5 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6008282.9909 2120710.7963 37.8035348717489 -122.415550034395 (37.8035348717489, -122.415550034395) 5 1 10 308 32
50942 142593 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 365 COLUMBUS AVE 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6008314.0969 2120822.0003 37.8038419583694 -122.415450267897 (37.8038419583694, -122.415450267897) 5 1 10 308 32
81789 98493 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1703 Polk St 1 Sidewalk: Curb side : Pot Tree Private 2     5     6006578.8967 2116733.3834 37.7925179651008 -122.421164544764 (37.7925179651008, -122.421164544764) 13 9 10 28858 32
88548 99210 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1111 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6007993.4855 2121112.3432 37.8046211410646 -122.416580345595 (37.8046211410646, -122.416580345595) 5 1 10 308 32
94505 142595 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 365 COLUMBUS AVE 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6008339.7594 2120798.6708 37.8037793437918 -122.415359808453 (37.8037793437918, -122.415359808453) 5 1 10 308 32
96661 99228 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1111 Columbus Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     12 2x2   6008013.4555 2121093.6827 37.8045710271276 -122.416509914664 (37.8045710271276, -122.416509914664) 5 1 10 308 32
108538 142592 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 365 COLUMBUS AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6008300.8769 2120835.2204 37.803877514381 -122.415496953155 (37.803877514381, -122.415496953155) 5 1 10 308 32
109841 99229 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1111 Columbus Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     12 2x2   6008022.9494 2121084.5162 37.8045463921415 -122.416476410342 (37.8045463921415, -122.416476410342) 5 1 10 308 32
109992 142604 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 700 CHESTNUT ST 4 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6008306.3204 2120712.3516 37.8035404535195 -122.415469411535 (37.8035404535195, -122.415469411535) 5 1 10 308 32
111305 142591 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 365 COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6008291.5451 2120841.4416 37.8038940717069 -122.41552968724 (37.8038940717069, -122.41552968724) 5 1 10 308 32
114293 142599 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 365 COLUMBUS AVE 10 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6008384.0855 2120756.6777 37.8036665324855 -122.415203440632 (37.8036665324855, -122.415203440632) 5 1 10 308 32
120153 142993 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 365 COLUMBUS AVE 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6008349.8689 2120789.339 37.8037542892016 -122.415324162836 (37.8037542892016, -122.415324162836) 5 1 10 308 32
127703 142597 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 365 COLUMBUS AVE 8 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6008368.5325 2120773.0083 37.8037104981311 -122.41525841948 (37.8037104981311, -122.41525841948) 5 1 10 308 32
139018 142594 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 365 COLUMBUS AVE 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6008329.6499 2120808.0026 37.8038043983711 -122.415395454094 (37.8038043983711, -122.415395454094) 5 1 10 308 32
147046 99232 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1111 Columbus Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008054.705 2121057.3439 37.8044735696368 -122.416364591045 (37.8044735696368, -122.416364591045) 5 1 10 308 32
150356 28073 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1075 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6008262.9463 2120869.8064 37.8039703467655 -122.415630664984 (37.8039703467655, -122.415630664984) 5 1 10 308 32
153905 142598 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 365 COLUMBUS AVE 9 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6008376.309 2120765.2318 37.8036895828586 -122.415230957587 (37.8036895828586, -122.415230957587) 5 1 10 308 32
156904 4726 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1075 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     9     6008251.3021 2120879.612 37.8039966159278 -122.415671655323 (37.8039966159278, -122.415671655323) 5 1 10 308 32
159684 142820 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1754 POLK ST 2 Sidewalk: Curb side : Pot Tree Private 2     1 Width 0ft   6006598.3556 2116937.7026 37.7930800716409 -122.421111730561 (37.7930800716409, -122.421111730561) 13 9 10 28858 32
168911 142600 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 365 COLUMBUS AVE 11 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6008394.1949 2120748.9012 37.803645748305 -122.415167905628 (37.803645748305, -122.415167905628) 5 1 10 308 32
172700 99231 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1111 Columbus Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     12 2x2   6008046.5206 2121063.2366 37.8044892892651 -122.416393331612 (37.8044892892651, -122.416393331612) 5 1 10 308 32
176662 99230 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1111 Columbus Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     12 2x2   6008035.3898 2121073.3853 37.8045165290969 -122.416432570152 (37.8045165290969, -122.416432570152) 5 1 10 308 32
192594 99227 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1111 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 2x2   6008003.9616 2121103.5041 37.8045974602939 -122.416543465428 (37.8045974602939, -122.416543465428) 5 1 10 308 32

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