37 rows where Zip Codes = 28856 and qSpecies_id = 63 sorted by qLegalStatus_id

View and edit SQL

Zip Codes

  • 28856 · 37
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)
10043 264733 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1367 De Haro St   Median : Cutout Tree DPW 1       3x3   6012260 2102130 37.7527390251575 -122.400481372119 (37.7527390251575, -122.400481372119) 10 3 8 28856 29
12450 261565 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1801 26th St 2 Sidewalk: Property side : Yard Tree DPW 1       3x3   6013146 2101521 37.7511162126671 -122.39737469907 (37.7511162126671, -122.39737469907) 10 3 8 28856 1
17195 194439 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900x Carolina St 32 Median : Yard Tree DPW 1     12     6012481.17054 2103301.60211 37.7559683209947 -122.3997987802 (37.7559683209947, -122.3997987802) 10 3 8 28856 29
29047 194457 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 25th St 32 Sidewalk: Property side : Yard Tree Private 2     30     6012708.71911 2101842.22219 37.7519738634013 -122.398909414543 (37.7519738634013, -122.398909414543) 10 3 8 28856 29
34697 194442 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900x Carolina St 51 Median : Yard Tree DPW 1     24     6012500.2858 2102979.92319 37.7550861265451 -122.399710087265 (37.7550861265451, -122.399710087265) 10 3 8 28856 29
37115 194449 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300x De Haro St 23 Median : Yard Tree DPW 1     23     6012259.688 2102130.23115 37.7527396424455 -122.400482467314 (37.7527396424455, -122.400482467314) 10 3 8 28856 29
37367 194451 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 930 Kansas St 1 Front Yard : Yard Tree Private 2     29     6011573.12502 2104017.28324 37.7578827599862 -122.402989455212 (37.7578827599862, -122.402989455212) 10 3 8 28856 29
40232 194448 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300x De Haro St 32 Median : Yard Tree DPW 1     27     6012284.461 2102001.80848 37.7523884032163 -122.400387777686 (37.7523884032163, -122.400387777686) 10 3 8 28856 29
43289 194453 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2250 26th St 1 Sidewalk: Curb side : Yard Tree Private 2     9     6011877.75436 2101392.1938 37.750691845665 -122.401751398122 (37.750691845665, -122.401751398122) 10 3 8 28856 29
65583 194443 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1900 23rd St 2 Front Yard : Yard Tree Private 2     28     6012732.21441 2102858.09004 37.7547645253758 -122.398899455441 (37.7547645253758, -122.398899455441) 10 3 8 28856 29
66190 194458 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 25th St 33 Sidewalk: Property side : Yard Tree Private 2     26     6012757.94703 2101850.0059 37.7519979787223 -122.398739722368 (37.7519979787223, -122.398739722368) 10 3 8 28856 29
78908 194452 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 20th St 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   6011998.43391 2104639.55141 37.7596151114626 -122.401562284167 (37.7596151114626, -122.401562284167) 10 3 8 28856 29
79719 194464 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 6 Sidewalk: Curb side : Yard Tree Private 2     16     6012478.49596 2101876.43729 37.7520549795584 -122.399707966672 (37.7520549795584, -122.399707966672) 10 3 8 28856 29
81035 194456 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 22nd St 12 Front Yard : Yard Tree Private 2     2     6013384.43791 2103815.09856 37.7574285843868 -122.396710957944 (37.7574285843868, -122.396710957944) 10 3 8 28856 29
95523 194440 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900x Carolina St 33 Median : Yard Tree DPW 1     6     6012485.2688 2103286.14111 37.7559260969364 -122.399783521388 (37.7559260969364, -122.399783521388) 10 3 8 28856 29
100087 194438 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1051 18th St 1 Side Yard : Yard Tree Private 2     11     6014405.25344 2105708.40792 37.7626839643245 -122.39331303148 (37.7626839643245, -122.39331303148) 10 3 8 28856 29
105080 173727 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 958 Carolina St 1 Sidewalk: Curb side : Cutout Tree DPW 1     9 3x3   6012430 2103470 37.7564278519739 -122.399987571177 (37.7564278519739, -122.399987571177) 10 3 8 28856 29
109147 194450 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300x De Haro St 21 Median : Yard Tree DPW 1     27     6012266.91736 2102141.9772 37.7527722977062 -122.40045829173 (37.7527722977062, -122.40045829173) 10 3 8 28856 29
120848 194447 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 680 De Haro St 4 Sidewalk: Property side : Yard Tree Private 2     1     6012074.20817 2105270.47212 37.761351707727 -122.401344555627 (37.761351707727, -122.401344555627) 10 3 8 28856 29
126912 194445 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 25th St 15 Sidewalk: Curb side : Yard Tree Private 2     11     6014148.42594 2101954.90209 37.7523633759809 -122.393938549541 (37.7523633759809, -122.393938549541) 10 3 8 28856 1
128353 194455 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 22nd St 11 Front Yard : Yard Tree Private 2     8     6013406.26386 2103790.51305 37.757362292666 -122.396633751156 (37.757362292666, -122.396633751156) 10 3 8 28856 29
131381 194466 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 8 Sidewalk: Curb side : Yard Tree Private 2     25     6012435.9357 2101881.1338 37.7520655025415 -122.399855477046 (37.7520655025415, -122.399855477046) 10 3 8 28856 29
132354 194460 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 1 Sidewalk: Curb side : Yard Tree Private 2     24     6012680.82829 2101890.2153 37.7521040879384 -122.399009233909 (37.7521040879384, -122.399009233909) 10 3 8 28856 29
133127 194437 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1021 Minnesota St 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   6015301.57899 2103740.56291 37.7573304413508 -122.390075457711 (37.7573304413508, -122.390075457711) 10 3 8 28856 29
133881 194454 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Rhode Island St 7 Sidewalk: Property side : Yard Tree Private 2     8 Width 6ft   6012013.85217 2102295.56099 37.753179889343 -122.40134423455 (37.753179889343, -122.40134423455) 10 3 8 28856 29
140344 194446 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 25th St 16 Sidewalk: Curb side : Yard Tree Private 2     18     6014162.91853 2101954.38506 37.7523627617528 -122.393888395238 (37.7523627617528, -122.393888395238) 10 3 8 28856 1
148743 194465 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 7 Sidewalk: Curb side : Yard Tree Private 2     23     6012451.33342 2101881.30035 37.7520668182527 -122.399802240798 (37.7520668182527, -122.399802240798) 10 3 8 28856 29
161957 194462 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 4 Sidewalk: Curb side : Yard Tree Private 2     25     6012536.20636 2101883.40971 37.7520773412124 -122.399508883748 (37.7520773412124, -122.399508883748) 10 3 8 28856 29
163675 194461 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 3 Sidewalk: Curb side : Yard Tree Private 2     27     6012563.25713 2101880.94422 37.7520720792617 -122.399415164477 (37.7520720792617, -122.399415164477) 10 3 8 28856 29
166032 194459 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 25th St 34 Sidewalk: Property side : Yard Tree Private 2     24     6012781.55557 2101851.76257 37.7520041175184 -122.398658203327 (37.7520041175184, -122.398658203327) 10 3 8 28856 29
170052 194441 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900x Carolina St 39 Median : Yard Tree DPW 1     18     6012501.46554 2103105.94469 37.7554322198433 -122.399714855461 (37.7554322198433, -122.399714855461) 10 3 8 28856 29
170429 253558 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1240 Wisconsin St 1 Front Yard : Yard Tree Private 2           6012830 2101639 37.7514226163546 -122.398475746389 (37.7514226163546, -122.398475746389) 10 3 8 28856 29
172636 194463 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2000 25th St 5 Sidewalk: Curb side : Yard Tree Private 2     18     6012509.33056 2101878.68569 37.7520628720051 -122.399601493222 (37.7520628720051, -122.399601493222) 10 3 8 28856 29
185304 194444 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 25th St 14 Sidewalk: Curb side : Yard Tree Private 2     14     6014137.98688 2101954.90704 37.7523628094083 -122.393974650128 (37.7523628094083, -122.393974650128) 10 3 8 28856 1
8023 121696 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1300x De Haro St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012218 2102254 37.7530771598286 -122.400635326689 (37.7530771598286, -122.400635326689) 10 3 8 28856 29
140522 121695 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1300x De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012218 2102254 37.7530771598286 -122.400635326689 (37.7530771598286, -122.400635326689) 10 3 8 28856 29
179258 121697 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1300x De Haro St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012218 2102254 37.7530771598286 -122.400635326689 (37.7530771598286, -122.400635326689) 10 3 8 28856 29

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