trees

35 rows where Fire Prevention Districts = 5 and qSpecies_id = 54

✎ View and edit SQL

This data as json, CSV (advanced)

Fire Prevention 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)
4593 4724 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1050 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     30 4x4   6008259.9153 2120954.1415 37.8042017393393 -122.415647128831 (37.8042017393393, -122.415647128831) 5 1 10 308 23
6549 142706 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 567 BAY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6008189.6261 2121340.372 37.8052582795068 -122.415917737693 (37.8052582795068, -122.415917737693) 5 1 10 308 23
7836 72023 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 655 Stockton St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     6010509.9754 2116460.1743 37.7919886256319 -122.407543551006 (37.7919886256319, -122.407543551006) 5 1 10 28857 21
30141 143475 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 655 STOCKTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6010503.0699 2116501.51 37.7921017369748 -122.407570359871 (37.7921017369748, -122.407570359871) 5 1 10 28857 21
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
32385 143482 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 601 Stockton St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6010529.9358 2116279.9602 37.7914949183295 -122.407461776619 (37.7914949183295, -122.407461776619) 5 1 10 28857 21
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
48457 4725 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1050 Columbus Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     30 4x4   6008238.1211 2120976.4945 37.8042618899237 -122.415724133248 (37.8042618899237, -122.415724133248) 5 1 10 308 23
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
55085 143481 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 626 PINE ST 2 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6010890.3641 2116278.8196 37.7915119538645 -122.40621461367 (37.7915119538645, -122.40621461367) 5 1 10 28857 6
60133 4721 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1040 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     15 5x5   6008335.3567 2120887.0824 37.8040218523597 -122.415381307054 (37.8040218523597, -122.415381307054) 5 1 10 308 23
81395 4723 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1050 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     36 5x5   6008295.1213 2120922.8472 37.8041177920118 -122.415523078458 (37.8041177920118, -122.415523078458) 5 1 10 308 23
82332 4722 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1040 Columbus Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     22 4x4   6008317.4743 2120903.2884 37.8040653448727 -122.415444338519 (37.8040653448727, -122.415444338519) 5 1 10 308 23
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
89354 143480 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 626 PINE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6010907.473 2116280.5305 37.7915176085666 -122.406155537422 (37.7915176085666, -122.406155537422) 5 1 10 28857 6
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
139954 4720 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1040 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     24 5x5   6008353.7979 2120870.8765 37.8039783914932 -122.415316341899 (37.8039783914932, -122.415316341899) 5 1 10 308 23
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
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)
);