trees

17 rows where SiteOrder = 2 and qSpecies_id = 118

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

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)
586 178423 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 226 Athens St 2 Sidewalk: Property side : Yard Tree Private 2     5     6004525.81285 2091935.4006 37.7243126139184 -122.426501755257 (37.7243126139184, -122.426501755257) 9 7 6 28861 5
16292 262198 Significant Tree 6 Pittosporum tobira :: Japanese Mockorange 118 801 Sanchez St 2 Back Yard : Yard Tree Private 2       3x3   6003778 2103544 37.7561448640021 -122.429914501498 (37.7561448640021, -122.429914501498) 2 4 5 28862 22
19854 211518 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 312 Hearst Ave 2 Sidewalk: Property side : Yard Tree Private 2     20     5999384.26732 2094401.16336 37.7307910259723 -122.444452411253 (37.7307910259723, -122.444452411253) 9 7 4 59 40
28388 29573 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 400X Junipero Serra Blvd 2 Median : Cutout Tree DPW 1   04/01/2007 12:00:00 AM 3 3X3   5991380.20291 2094265.78979 37.7299593788197 -122.472113603178 (37.7299593788197, -122.472113603178) 9 8 4 64 40
29825 234023 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 1457 Noe St 2 Sidewalk: Property side : Yard Tree Private 2     9 Width 3ft   6003332.6801 2099728.28161 37.7456425696603 -122.431182221081 (37.7456425696603, -122.431182221081) 2 7 5 63 22
41677 119919 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 3801 Anza St 2 Sidewalk: Property side : Yard Tree Private 2     7 Width 3ft   5986854.35901 2111807.96011 37.7778624645171 -122.489048907202 (37.7778624645171, -122.489048907202) 11 6 2 55 26
49851 194602 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 500 Wisconsin St 2 Sidewalk: Property side : Yard Tree Private 2     6 Width 9ft   6012630.51831 2105140.83146 37.7610267655993 -122.399411398126 (37.7610267655993, -122.399411398126) 10 3 8 28856 29
72085 250004 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 232 Filbert St 2 Side Yard : Yard Tree Private 2     8 Width 0ft   6011504.01109 2120100.18107 37.8020387962268 -122.404360482466 (37.8020387962268, -122.404360482466) 3 1 10 308 23
92864 211522 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 401 Victoria St 2 Sidewalk: Property side : Yard Tree Private 2     6 Width 5ft   5993220.36391 2089918.5928 37.7181293539714 -122.46543632495 (37.7181293539714, -122.46543632495) 9 8 6 64 24
92941 132451 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 1111 Chestnut St 2 Front Yard : Yard Tree Private 2     3     6006416.48841 2120396.60809 37.8025670993539 -122.421986828545 (37.8025670993539, -122.421986828545) 5 9 1 28858 32
110431 132464 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 1080 Vallejo St 2 Sidewalk: Property side : Yard Tree Private 2     12 Width 5ft   6008331.1974 2118642.46572 37.7978584622601 -122.415236711511 (37.7978584622601, -122.415236711511) 5 1 10 308 21
113150 211521 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 210 Vernon St 2 Sidewalk: Property side : Yard Tree Private 2     6 Width 8ft   5992480.41051 2089284.24436 37.7163448831965 -122.467947888604 (37.7163448831965, -122.467947888604) 9 8 6 64 24
120861 109106 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 461X Cherry St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2015 12:00:00 AM 3   Permit Number 774020 5996243.86079 2114742.72809 37.7864641110096 -122.456779845468 (37.7864641110096, -122.456779845468) 11 6 1 54 31
138625 178424 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 421 Harvard St 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 2ft   6006514.98765 2091903.47789 37.7243372112697 -122.419623183572 (37.7243372112697, -122.419623183572) 9 7 7 309 28
146983 132462 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 1275 Greenwich St 2 Sidewalk: Property side : Yard Tree Private 2     10 Width 3ft   6006821.45556 2119757.24178 37.8008343926403 -122.420540025305 (37.8008343926403, -122.420540025305) 5 1 1 28858 32
150281 132460 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 1109 Chestnut St 2 Side Yard : Yard Tree Private 2     7     6006458.07728 2120400.55617 37.8025802852249 -122.421843190623 (37.8025802852249, -122.421843190623) 5 9 1 28858 32
184313 211519 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 1215 Capitol Ave 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   5995031.25644 2091999.92866 37.7239484802273 -122.459327533359 (37.7239484802273, -122.459327533359) 9 8 4 28861 24

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