trees

120 rows where Neighborhoods (old) = 27 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)
156517 138119 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1700 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 6x7   6004323.0329 2114669.3641 37.786723258345 -122.42882269508 (37.786723258345, -122.42882269508) 13 9 11 29490 27
158536 138588 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1732 BAKER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6000056.8342 2114968.7073 37.7873027909955 -122.443604192363 (37.7873027909955, -122.443604192363) 13 6 1 29490 27
162803 18018 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2718 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6000772 2114884 37.7871109684575 -122.441123796433 (37.7871109684575, -122.441123796433) 13 6 1 29490 27
165725 253907 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2807 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/05/2018 12:00:00 AM 3 3X3   6000402 2114746 37.7867109741586 -122.442394000297 (37.7867109741586, -122.442394000297) 13 6 1 29490 27
167816 138091 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1890 Sutter St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/09/1990 12:00:00 AM 15 Width 0ft   6003632 2114586 37.7864552256154 -122.431207550794 (37.7864552256154, -122.431207550794) 13 9 11 29490 27
167935 18023 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2729 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6000744.2415 2114813.5523 37.7869159561343 -122.441214778061 (37.7869159561343, -122.441214778061) 13 6 1 29490 27
168368 112635 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1715 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6000531.3846 2114698.9549 37.7865891741887 -122.441942983766 (37.7865891741887, -122.441942983766) 13 6 1 29490 27
170781 21586 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1500 Sutter St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X2   6005346.0976 2114810.866 37.7871696385608 -122.425293204645 (37.7871696385608, -122.425293204645) 13 9 11 28858 27
174010 21712 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1900 Sutter St 4 Sidewalk: Curb side : Cutout Tree Private 2     18 6x8   6003372.5799 2114537.2521 37.7863066717407 -122.432101596345 (37.7863066717407, -122.432101596345) 13 9 11 29490 27
177855 18050 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2832 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6000363.8297 2114817.6224 37.7869054550264 -122.442531204238 (37.7869054550264, -122.442531204238) 13 6 1 29490 27
180014 138587 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1732 BAKER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6000059.0615 2114952.3738 37.7872580704829 -122.443595312613 (37.7872580704829, -122.443595312613) 13 6 1 29490 27
181651 59592 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1610 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/25/1981 12:00:00 AM 13   Permit Number 18989 6000112.8301 2114568.7427 37.7862077855538 -122.443381719167 (37.7862077855538, -122.443381719167) 13 6 1 29490 27
181998 138373 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1801 Steiner St 2 Sidewalk: Curb side : Cutout Tree DPW 1     11 Width 0ft   6002557.3186 2114515.2232 37.7861999309178 -122.434920611081 (37.7861999309178, -122.434920611081) 13 9 11 29490 27
182991 21588 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1500 Sutter St 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X2   6005294.0011 2114805.6563 37.7871523906748 -122.425473076473 (37.7871523906748, -122.425473076473) 13 9 11 28858 27
183591 138360 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2060 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree DPW 1     14 Width 0ft   6002847.7164 2114462.1983 37.7860708218731 -122.433912120385 (37.7860708218731, -122.433912120385) 13 9 11 29490 27
184520 113774 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1716 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     22 3x3   6000066.4859 2114892.9793 37.7870954120643 -122.443565357608 (37.7870954120643, -122.443565357608) 13 6 1 29490 27
186282 138371 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 2060 SUTTER ST 13 Sidewalk: Curb side : Cutout Tree DPW 1     17 Width 0ft   6002611.3346 2114434.447 37.7859812067704 -122.434727951803 (37.7859812067704, -122.434727951803) 13 9 11 29490 27
190419 113773 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1718 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 4x6   6000060.5464 2114943.4646 37.7872336928249 -122.443589534945 (37.7872336928249, -122.443589534945) 13 6 1 29490 27
190740 21590 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1500 Sutter St 6 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X2   6005256.9547 2114799.289 37.7871328144412 -122.425600795702 (37.7871328144412, -122.425600795702) 13 9 11 28858 27
193191 138110 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 1600 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree DPW 1     10 Width 0ft   6004839.6037 2114746.6136 37.7869645899648 -122.427040986298 (37.7869645899648, -122.427040986298) 13 9 11 28858 27

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