40 rows where Supervisor Districts = 6 and qSpecies_id = 47 sorted by Location

View and edit SQL

These facets timed out: Supervisor 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)
148733 24276 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 350X Winding Way 14 Median : Cutout Tree DPW 1     6 8   6000825.35085 2086800.6303 37.7100038012068 -122.438925891137 (37.7100038012068, -122.438925891137) 9 7 6 28861 5
177935 121420 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1155x Prague St 1 Median : Cutout Tree DPW 1       3x3   6000780 2086820 37.7100544057225 -122.439084019343 (37.7100544057225, -122.439084019343) 9 7 6 28861 5
47089 12917 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2935X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     45 3x3   5996989.32715 2087489.72289 37.7116768903089 -122.452233546915 (37.7116768903089, -122.452233546915) 9 7 6 28861 25
101273 12918 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2935X Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     45 3x3   5996989.32715 2087489.72289 37.7116768903089 -122.452233546915 (37.7116768903089, -122.452233546915) 9 7 6 28861 25
71469 176984 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2935x Alemany Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     28 Width 3ft   5996985 2087493 37.71168564061 -122.45224873895 (37.71168564061, -122.45224873895) 9 7 6 28861 25
181786 176983 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2935x Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     22 Width 3ft   5996985 2087493 37.71168564061 -122.45224873895 (37.71168564061, -122.45224873895) 9 7 6 28861 25
186347 207117 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 41 Ralston St 9 Back Yard : Yard Tree Private 2     19     5992170.67066 2088214.06867 37.7133885481037 -122.468940655584 (37.7133885481037, -122.468940655584) 9 8 6 64 24
177625 207115 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 47 Ralston St 8 Back Yard : Yard Tree Private 2     8     5992168.43399 2088239.25639 37.7134575782774 -122.468950218099 (37.7134575782774, -122.468950218099) 9 8 6 64 24
16464 207116 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 47 Ralston St 9 Back Yard : Yard Tree Private 2     8     5992178.8337 2088240.41516 37.7134613608383 -122.468914357628 (37.7134613608383, -122.468914357628) 9 8 6 64 24
94127 119281 Undocumented 4 Leptospermum laevigatum :: Australian Tea Tree 47 59x Ralston St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992077 2088275 37.7135504383964 -122.469268843393 (37.7135504383964, -122.469268843393) 9 8 6 64 24
19861 207114 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 53 Ralston St 2 Back Yard : Yard Tree Private 2     23     5992175.21623 2088282.16276 37.7135757806697 -122.468929896991 (37.7135757806697, -122.468929896991) 9 8 6 64 24
131273 207113 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 53 Ralston St 1 Back Yard : Yard Tree Private 2     5     5992170.39113 2088282.95309 37.7135776719473 -122.468946631596 (37.7135776719473, -122.468946631596) 9 8 6 64 24
174244 207112 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 59 Ralston St 4 Back Yard : Yard Tree Private 2     12     5992171.74672 2088295.87352 37.7136132266511 -122.468942885919 (37.7136132266511, -122.468942885919) 9 8 6 64 24
142860 207111 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 59 Ralston St 2 Back Yard : Yard Tree Private 2     11     5992171.5605 2088305.6585 37.713640083085 -122.468944241206 (37.713640083085, -122.468944241206) 9 8 6 64 24
63319 207110 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 59 Ralston St 1 Back Yard : Yard Tree Private 2     7     5992170.63195 2088310.84387 37.7136542672107 -122.468947827707 (37.7136542672107, -122.468947827707) 9 8 6 64 24
64604 207109 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 75 Ralston St 2 Back Yard : Yard Tree Private 2     14     5992170.77084 2088338.0326 37.7137289289241 -122.468949325066 (37.7137289289241, -122.468949325066) 9 8 6 64 24
187087 207108 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 89 Ralston St 3 Back Yard : Yard Tree Private 2     13     5992168.92954 2088415.82729 37.7139424279717 -122.468961347182 (37.7139424279717, -122.468961347182) 9 8 6 64 24
36093 207107 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 89 Ralston St 2 Back Yard : Yard Tree Private 2     11     5992169.55859 2088419.40871 37.7139522980308 -122.468959433443 (37.7139522980308, -122.468959433443) 9 8 6 64 24
75879 176985 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2571 Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 2ft   5998574.33272 2088565.20963 37.7147206041402 -122.446832699994 (37.7147206041402, -122.446832699994) 9 7 6 28861 25
161455 40483 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 165 Margaret Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1999 12:00:00 AM     Permit Number 41562 5996732.70371963 2089259.1130924 37.7165205210888 -122.453248158457 (37.7165205210888, -122.453248158457) 9 8 6 28861 24
29184 176980 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2315 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 2ft   5999548.76247 2089280.82364 37.7167411370713 -122.443516055124 (37.7167411370713, -122.443516055124) 9 7 6 28861 25
95742 176981 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2315 Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 1ft   5999571.4621 2089300.92693 37.7167976306892 -122.443439037193 (37.7167976306892, -122.443439037193) 9 7 6 28861 25
177777 16566 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2305X Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     16 3X3   5999574.07501 2089304.05837 37.7168063779221 -122.443430230482 (37.7168063779221, -122.443430230482) 9 7 6 28861 25
174502 16565 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2305X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   5999593.35864 2089327.05238 37.7168706139428 -122.443365227339 (37.7168706139428, -122.443365227339) 9 7 6 28861 25
132662 176986 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 745 France Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6002864.08823 2089338.03726 37.7170867510327 -122.432060704959 (37.7170867510327, -122.432060704959) 9 7 6 28861 5
29255 176982 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2157 Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   5999995.5387 2089705.60981 37.7179329735202 -122.442002247903 (37.7179329735202, -122.442002247903) 9 7 6 28861 25
54666 31185 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 720 Shields St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34883 5992147.8527206 2089880.99524616 37.7179642061069 -122.469140766842 (37.7179642061069, -122.469140766842) 9 8 6 64 24
99445 9277 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 2161X Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6000049.09202 2089751.67924 37.7180625213905 -122.441820442737 (37.7180625213905, -122.441820442737) 9 7 6 28861 25
81378 50428 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 11 Lee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/2003 12:00:00 AM     Permit Number 47081 5996479.47890892 2089951.8399169 37.7184080697361 -122.454173429085 (37.7184080697361, -122.454173429085) 9 8 6 28861 24
113634 47351 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 246 Monticello St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/2002 12:00:00 AM     Permit Number 45277 5991716.56988019 2090163.16086716 37.7187140338834 -122.470652049529 (37.7187140338834, -122.470652049529) 9 8 6 64 24
123096 45360 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 458 Victoria St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM     Permit Number 46747 5993277.37926203 2090218.01876098 37.7189547935486 -122.46526098645 (37.7189547935486, -122.46526098645) 9 8 6 64 24
137534 50423 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 75 Granada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/2003 12:00:00 AM     Permit Number 47076 5995600.08487961 2090390.5729412 37.7195622602365 -122.457244829317 (37.7195622602365, -122.457244829317) 9 8 6 28861 24
139898 105256 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 162 Prague St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/08/2014 12:00:00 AM   3x3 Permit Number 771043 6004383.3 2090213.9 37.7195776934466 -122.42687185684 (37.7195776934466, -122.42687185684) 9 7 6 28861 5
109823 52980 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 531 Arch St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/2006 12:00:00 AM     Permit Number 49067 5992711.66457877 2090721.03501475 37.7203033137371 -122.467252978798 (37.7203033137371, -122.467252978798) 9 8 6 64 24
145902 31168 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 570 Ramsell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34869 5993027.58275469 2090995.29108117 37.7210745862886 -122.466180882741 (37.7210745862886, -122.466180882741) 9 8 6 64 24
37655 207106 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 100 Tara St 2 : Tree Private 2     20 Width 0ft   5998100.60654 2090923.0946 37.7211677377768 -122.448639805789 (37.7211677377768, -122.448639805789) 9 8 6 28861 24
67862 37850 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 211 Edinburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/1998 12:00:00 AM     Permit Number 40141 6003943.02561838 2092441.0681197 37.7256681018117 -122.428552395212 (37.7256681018117, -122.428552395212) 9 7 6 28861 5
105561 973 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1599 Alemany Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1     22 0   6001917.27172 2093023.46154 37.72715237348 -122.435596901293 (37.72715237348, -122.435596901293) 9 7 6 28861 25
48894 976 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1599 Alemany Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1     25 3X4   6001942.44101 2093088.00211 37.7273310167784 -122.435514506557 (37.7273310167784, -122.435514506557) 9 7 6 28861 25
56036 909 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1217 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     45 3X3   6003163.68633 2094174.89484 37.7303846655151 -122.431370220756 (37.7303846655151, -122.431370220756) 9 7 6 28861 25

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