trees
40 rows where Supervisor Districts = 6 and qSpecies_id = 47 sorted by XCoord
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||||
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 | ||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );