trees

25 rows where qSiteInfo = "Sidewalk: Property side : Yard" and qSpecies_id = 47 sorted by Location

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: qSiteInfo

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)
50732 253463 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 98X Marston Ave 2 Sidewalk: Property side : Yard Tree Private 2   09/12/2017 12:00:00 AM 3 3x3   5998793 2093251 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362) 9 7 4 28861 40
70915 253464 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 98X Marston Ave 3 Sidewalk: Property side : Yard Tree Private 2   09/12/2017 12:00:00 AM 3 3x3   5998793 2093251 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362) 9 7 4 28861 40
150375 253465 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 98X Marston Ave 4 Sidewalk: Property side : Yard Tree Private 2   09/12/2017 12:00:00 AM 3 3x3   5998793 2093251 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362) 9 7 4 28861 40
159025 253462 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 98X Marston Ave 1 Sidewalk: Property side : Yard Tree Private 2   09/12/2017 12:00:00 AM 3 3x3   5998793 2093251 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362) 9 7 4 28861 40
117562 217831 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2 Cranleigh Dr 21 Sidewalk: Property side : Yard Tree Private 2     22     5991381.66969 2095739.82508 37.734006793868 -122.472215938837 (37.734006793868, -122.472215938837) 1 8 4 64 40
27854 185961 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2001 Sunset Blvd 20 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984861.3455 2101337.8929 37.7489980727428 -122.495171051634 (37.7489980727428, -122.495171051634) 1 8 3 29491 35
173649 186041 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1900 Sunset Blvd 36 Sidewalk: Property side : Yard Tree Private 2     13 Width 0ft   5984992.0482 2102149.6578 37.7512346080754 -122.494778929254 (37.7512346080754, -122.494778929254) 1 8 3 29491 35
165804 186059 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1901 Sunset Blvd 5 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984803.9529 2102180.8195 37.7513091577006 -122.495431671777 (37.7513091577006, -122.495431671777) 1 8 3 29491 35
160576 186058 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1901 Sunset Blvd 4 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984794.5256 2102183.7824 37.7513167410032 -122.495464490464 (37.7513167410032, -122.495464490464) 1 8 3 29491 35
136029 186000 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1883 47th Ave 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5981612.0444 2102288.7145 37.7514179925848 -122.506477461595 (37.7514179925848, -122.506477461595) 1 8 3 56 35
174148 186310 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1800 Sunset Blvd 48 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984966.7705 2102775.9332 37.7529527085207 -122.494912513249 (37.7529527085207, -122.494912513249) 1 8 3 56 35
49589 186745 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 11 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984852.3804 2106661.5394 37.763614805479 -122.495594661337 (37.763614805479, -122.495594661337) 1 8 3 56 35
136020 186747 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 13 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984869.1172 2106666.6331 37.7636297714118 -122.495537150576 (37.7636297714118, -122.495537150576) 1 8 3 56 35
127928 186748 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 14 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5984868.1469 2106676.3356 37.7636563549354 -122.495541222153 (37.7636563549354, -122.495541222153) 1 8 3 56 35
149988 186750 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 16 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984851.1676 2106678.2761 37.7636606887382 -122.495600090514 (37.7636606887382, -122.495600090514) 1 8 3 56 35
192203 186749 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 15 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5984860.385 2106678.2761 37.7636612284897 -122.495568210877 (37.7636612284897, -122.495568210877) 1 8 3 56 35
138219 186752 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 18 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984851.1676 2106688.9488 37.7636899929755 -122.495600877764 (37.7636899929755, -122.495600877764) 1 8 3 56 35
157835 186754 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 20 Sidewalk: Property side : Yard Tree Private 2     9 Width 0ft   5984863.7808 2106693.8 37.763704051609 -122.495557611102 (37.763704051609, -122.495557611102) 1 8 3 56 35
17241 186756 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 22 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984857.4742 2106702.5322 37.7637276584797 -122.495580067458 (37.7637276584797, -122.495580067458) 1 8 3 56 35
55330 186759 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 25 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5984850.1974 2106711.7495 37.7637525404811 -122.495605915184 (37.7637525404811, -122.495605915184) 1 8 3 56 35
185713 186760 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 26 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5984860.8701 2106711.7495 37.7637531654529 -122.495569002148 (37.7637531654529, -122.495569002148) 1 8 3 56 35
133352 186762 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1200 Sunset Blvd 28 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5984853.5932 2106716.1156 37.7637647274179 -122.495594492387 (37.7637647274179, -122.495594492387) 1 8 3 56 35
155046 129469 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1085 Vallejo St 4 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6008359.28826 2118585.88506 37.7977046844857 -122.415135501808 (37.7977046844857, -122.415135501808) 5 1 10 308 21
80079 129470 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 45 MacOndray Ln 2 Sidewalk: Property side : Yard Tree Private 2     10     6008463.14234 2119145.61201 37.7992473914164 -122.414815771241 (37.7992473914164, -122.414815771241) 5 1 10 308 32
14177 129468 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1151 Lombard St 5 Sidewalk: Property side : Yard Tree Private 2     11     6006718.96895 2120094.36111 37.8017542606157 -122.420918621021 (37.8017542606157, -122.420918621021) 5 1 1 28858 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)
);