36 rows where Zip Codes = 28859 and qSpecies_id = 47 sorted by YCoord

View and edit SQL

Zip Codes

  • 28859 · 36
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)
139775 51442 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 775 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/19/2004 12:00:00 AM     Permit Number 47761 6007380.25742092 2095203.71769531 37.7334476580973 -122.416865768693 (37.7334476580973, -122.416865768693) 2 7 7 28859 2
187678 48774 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 629 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/20/2004 12:00:00 AM     Permit Number 47773 6007825.24973386 2095718.75627166 37.7348868619711 -122.415363748684 (37.7348868619711, -122.415363748684) 2 7 7 28859 2
104777 47604 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 645 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/2002 12:00:00 AM     Permit Number 45440 6008713.69382569 2095849.48701302 37.7352957148385 -122.412301312985 (37.7352957148385, -122.412301312985) 10 7 7 28859 2
129532 52497 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 371 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2005 12:00:00 AM     Permit Number 48606 6007135.79724675 2096038.97616324 37.7357273409345 -122.417770123047 (37.7357273409345, -122.417770123047) 2 7 7 28859 2
102941 227682 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 500 Gates St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6008186.7931 2096476.12564 37.7369867469298 -122.41416732858 (37.7369867469298, -122.41416732858) 2 7 7 28859 2
71117 52492 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 390ON GATES Tompkins Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2005 12:00:00 AM     Permit Number 48601 6008184.68107457 2096494.82661811 37.7370379770988 -122.414175953506 (37.7370379770988, -122.414175953506) 2 7 7 28859 2
32588 63441 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 299 Nevada St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/1997 12:00:00 AM     Permit Number 24028 6008993.82853707 2096920.83270323 37.738253113659 -122.411408443517 (37.738253113659, -122.411408443517) 10 7 7 28859 2
137873 227692 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 75 Holly Park Cir 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006684.36987 2096973.81613 37.7382687898828 -122.419397184857 (37.7382687898828, -122.419397184857) 2 7 7 28859 2
141197 227672 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1000 San Jose Ave 62 Front Yard : Yard Tree Private 2     15     6005095.2123 2097053.48648 37.7383979127325 -122.424897379118 (37.7383979127325, -122.424897379118) 2 7 5 28859 7
84866 227691 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 309 Bocana St 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   6006868.92044 2097195.64462 37.7388882743696 -122.418774826116 (37.7388882743696, -122.418774826116) 2 7 7 28859 2
155190 227690 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 307 Bocana St 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   6006885.1558 2097215.40267 37.7389434396991 -122.418720092463 (37.7389434396991, -122.418720092463) 2 7 7 28859 2
32735 40449 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 255 Ellsworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/2003 12:00:00 AM     Permit Number 47061 6008102.60669454 2097399.44811028 37.7395172589666 -122.414523716357 (37.7395172589666, -122.414523716357) 2 7 7 28859 2
42446 52384 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 36TA MARINA Gladys St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/2005 12:00:00 AM     Permit Number 48509 6005730.58900637 2097520.8738626 37.7397171218166 -122.422733759035 (37.7397171218166, -122.422733759035) 2 7 7 28859 2
47837 227688 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 269 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6007769.10714 2097866.49845 37.7407809344798 -122.41570987722 (37.7407809344798, -122.41570987722) 2 7 7 28859 2
25754 47111 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 189 Bonview St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/2002 12:00:00 AM 6 3x3 Permit Number 45095 6007076.38254046 2097931.15674799 37.7409195061747 -122.418109646545 (37.7409195061747, -122.418109646545) 2 7 7 28859 2
107721 23670 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 317 Virginia Ave 1 Median : Cutout Tree DPW 1     3 12   6006937.9415449 2098264.8464559 37.7418279505329 -122.41861198258 (37.7418279505329, -122.41861198258) 2 7 7 28859 2
36450 247870 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 394 Mayflower St 2 Side Yard : Yard Tree Private 2     10     6009721.06953 2098395.0417 37.7423417348977 -122.408997980481 (37.7423417348977, -122.408997980481) 10 7 7 28859 2
80406 247869 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 394 Mayflower St 1 Side Yard : Yard Tree Private 2     9     6009720.84865 2098403.35069 37.7423645372013 -122.408999330354 (37.7423645372013, -122.408999330354) 10 7 7 28859 2
154236 247871 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 394 Mayflower St 3 Side Yard : Yard Tree Private 2     18     6009746.3542 2098404.30325 37.7423685814537 -122.408911206692 (37.7423685814537, -122.408911206692) 10 7 7 28859 2
175565 248189 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 216 Esmeralda Ave 8 Side Yard : Yard Tree Private 2     11     6007400.67054 2098728.2959 37.7431265201804 -122.417044843446 (37.7431265201804, -122.417044843446) 2 7 7 28859 2
21600 105136 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 175X ESMERALDA AVE 2 unknown : Yard Tree DPW 1           6007213 2098808 37.7433348108676 -122.417699407763 (37.7433348108676, -122.417699407763) 2 7 7 28859 2
82654 116655 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 199x Esmeralda Ave 9 Unaccepted Street : Yard Tree DPW 1           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452) 2 7 7 28859 2
87869 116654 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 199x Esmeralda Ave 9 Unaccepted Street : Yard Tree DPW 1           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452) 2 7 7 28859 2
78182 113478 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 100x ESMERALDA AVE 5 Unaccepted Street : Yard Tree DPW 1     8     6006917 2098966 37.7437519821991 -122.418734104398 (37.7437519821991, -122.418734104398) 2 7 7 28859 2
88904 116681 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 100 Esmeralda Ave 20 Unaccepted Street : Yard Tree DPW 1           6006917.38983 2098966.37493 37.7437530336215 -122.41873278304 (37.7437530336215, -122.41873278304) 2 7 7 28859 2
93754 227689 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 84 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6008214.29979 2099586.39862 37.7455284159971 -122.41429222281 (37.7455284159971, -122.41429222281) 2 7 7 28859 2
134216 68097 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 49 Bessie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/1993 12:00:00 AM     Permit Number 31842 6008240.85722104 2100065.07433688 37.7468442446896 -122.414234251858 (37.7468442446896, -122.414234251858) 2 7 7 28859 2
185212 63714 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 220 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/22/1997 12:00:00 AM     Permit Number 24378 6007857.54148412 2100263.37846132 37.7473672046192 -122.415573763175 (37.7473672046192, -122.415573763175) 2 7 7 28859 2
58452 101254 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 3700X Cesar Chavez St 1 Front Yard : Yard Tree DPW 1           6005840.6 2100555.6 37.7480559984104 -122.422568977073 (37.7480559984104, -122.422568977073) 2 4 5 28859 19
87369 81868 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3012-3014 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52207 6009486.0303434 2101043.89087343 37.749601722793 -122.409997630916 (37.749601722793, -122.409997630916) 2 4 7 28859 19
76454 227670 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 403 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6005513.92482 2101330.09926 37.7501641603604 -122.423753669923 (37.7501641603604, -122.423753669923) 2 4 5 28859 19
54078 52269 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 403 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/29/2005 12:00:00 AM     Permit Number 48434 6005520.49766263 2101354.49181367 37.7502315077339 -122.423732674774 (37.7502315077339, -122.423732674774) 2 4 5 28859 19
89012 227683 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 923 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007409.88053 2101914.88747 37.7518767015549 -122.417238758882 (37.7518767015549, -122.417238758882) 2 4 7 28859 19
47586 57377 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3505 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52081 6006157.87748572 2102561.9990288 37.7535830045092 -122.421614323469 (37.7535830045092, -122.421614323469) 2 4 5 28859 19
103423 82598 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3503 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52081 6006166.2666896 2102562.46439955 37.7535847553547 -122.421585344765 (37.7535847553547, -122.421585344765) 2 4 5 28859 19
157287 115975 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 100 SAN JOSE AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6006168 2102576 37.7536220187283 -122.421580311855 (37.7536220187283, -122.421580311855) 2 4 5 28859 19

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