trees

17 rows where Neighborhoods (old) = 22 and qSpecies_id = 63

✎ 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)
11808 247102 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 20 Front Yard : Yard Tree Private 2     35     6002745.76405 2098754.96889 37.7429368028052 -122.43314215589 (37.7429368028052, -122.43314215589) 2 7 5 63 22
20818 247070 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2401 Castro St 6 Front Yard : Yard Tree Private 2     24     6002744.91385 2098422.48032 37.7420238182333 -122.433121344697 (37.7420238182333, -122.433121344697) 2 7 5 63 22
60884 247108 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 26 Front Yard : Yard Tree Private 2     48     6002704.67605 2098786.321 37.7430205575564 -122.433286466502 (37.7430205575564, -122.433286466502) 2 7 5 63 22
67373 247069 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2401 Castro St 5 Front Yard : Yard Tree Private 2     25     6002737.44051 2098436.60323 37.7420621725331 -122.433148193957 (37.7420621725331, -122.433148193957) 2 7 5 63 22
68284 253182 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 5157 Diamond Heights Blvd 1 Front Yard : Yard Tree Private 2           6000788 2100195 37.7467795353698 -122.440014780391 (37.7467795353698, -122.440014780391) 2 4 5 63 22
86615 253183 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 5159 Diamond Heights Blvd 1 Front Yard : Yard Tree Private 2           6000808 2099903 37.745978911495 -122.439924689335 (37.745978911495, -122.439924689335) 2 4 5 63 22
88434 247104 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 22 Front Yard : Yard Tree Private 2     31     6002734.00484 2098778.85198 37.743001713153 -122.433184522069 (37.743001713153, -122.433184522069) 2 7 5 63 22
92200 247144 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500 27th St 14 Front Yard : Yard Tree Private 2     23     6003151.94767 2100099.93337 37.7466527951889 -122.431833698065 (37.7466527951889, -122.431833698065) 2 7 5 63 22
92432 247072 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2401 Castro St 8 Front Yard : Yard Tree Private 2     22     6002777.34907 2098440.51813 37.7420751857223 -122.433010482565 (37.7420751857223, -122.433010482565) 2 7 5 63 22
94885 247113 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 31 Front Yard : Yard Tree Private 2     5     6002717.05441 2098681.21035 37.7427326503855 -122.433236156629 (37.7427326503855, -122.433236156629) 2 7 5 63 22
101832 247109 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 27 Front Yard : Yard Tree Private 2     55     6002712.35608 2098750.32101 37.7429221456486 -122.433257339272 (37.7429221456486, -122.433257339272) 2 7 5 63 22
101920 247071 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2401 Castro St 7 Front Yard : Yard Tree Private 2     27     6002776.8237 2098415.08611 37.7420053254986 -122.433010482544 (37.7420053254986, -122.433010482544) 2 7 5 63 22
119760 247143 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500 27th St 13 Front Yard : Yard Tree Private 2     26     6003160.52798 2100099.92491 37.7466532583536 -122.431804027655 (37.7466532583536, -122.431804027655) 2 7 5 63 22
128762 247016 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500 Valley St 6 Sidewalk: Property side : Yard Tree Private 2     3     6002574.36339 2099193.51243 37.7441312166966 -122.433766148707 (37.7441312166966, -122.433766148707) 2 7 5 63 22
145279 247112 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 30 Front Yard : Yard Tree Private 2     4     6002722.94518 2098688.33329 37.7427525424969 -122.433216296891 (37.7427525424969, -122.433216296891) 2 7 5 63 22
149206 234518 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1481 Noe St 2 Sidewalk: Curb side : Pot Tree Private 2     5 Width 4ft   6003337.48877 2099628.14838 37.7453678996008 -122.431158447529 (37.7453678996008, -122.431158447529) 2 7 5 63 22
193904 99774 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 4330 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2       8x6   6001764 2100607 37.7479663028981 -122.436669359529 (37.7479663028981, -122.436669359529) 2 4 5 28862 22

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