61 rows where Zip Codes = 63 and qSpecies_id = 63 sorted by qAddress

View and edit SQL

Zip Codes

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)
19749 234503 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1000 San Jose Ave 39 Front Yard : Yard Tree Private 2     2     6005117.95051 2097175.77056 37.7387349615553 -122.424827458621 (37.7387349615553, -122.424827458621) 2 7 5 63 7
7702 262097 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 10x Cuesta Ct 1 Unaccepted Street : Yard Tree DPW 1 Private     3x3   5999757 2101744 37.7509739685765 -122.443691128062 (37.7509739685765, -122.443691128062) 2 5 5 63 38
15519 262098 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 10x Cuesta Ct 2 Unaccepted Street : Yard Tree DPW 1 Private     3x3   5999757 2101744 37.7509739685765 -122.443691128062 (37.7509739685765, -122.443691128062) 2 5 5 63 38
105900 234504 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100 San Jose Ave 5 Front Yard : Yard Tree Private 2     16     6004845.11812 2096728.13188 37.7374904329363 -122.425738932323 (37.7374904329363, -122.425738932323) 2 7 5 63 7
119227 234505 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100 San Jose Ave 7 Front Yard : Yard Tree Private 2     16     6004841.55243 2096717.56088 37.7374612058616 -122.425750508406 (37.7374612058616, -122.425750508406) 2 7 5 63 7
148660 234506 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100 San Jose Ave 8 Front Yard : Yard Tree Private 2     24     6004826.97139 2096714.28402 37.737451384369 -122.425800688759 (37.737451384369, -122.425800688759) 2 7 5 63 7
187165 234507 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1100 San Jose Ave 32 Sidewalk: Property side : Yard Tree Private 2     17 Width 9ft   6004787.92016 2096687.497 37.7373756263678 -122.425933801003 (37.7373756263678, -122.425933801003) 2 7 5 63 7
62583 234511 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300 San Jose Ave 59 Front Yard : Yard Tree Private 2     5 Width 10ft   6003237.34595 2095470.24367 37.7339455743229 -122.431207993878 (37.7339455743229, -122.431207993878) 2 7 5 63 7
161041 234512 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300 San Jose Ave 61 Front Yard : Yard Tree Private 2     12 Width 6ft   6003219.80457 2095456.80721 37.7339076867834 -122.431267680974 (37.7339076867834, -122.431267680974) 2 7 5 63 7
149206 234518 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1481 Noe St 2 Sidewalk: Curb side : Pot Tree Private 2     5 Width 4ft   6003337.48877 2099628.14838 37.7453678996008 -122.431158447529 (37.7453678996008, -122.431158447529) 2 7 5 63 22
24668 97534 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 203 Surrey St 1 Front Yard : Yard Tree Private 2         Permit Number 768282 6002070 2096079.6 37.7355525046422 -122.435287431957 (37.7355525046422, -122.435287431957) 2 7 5 63 7
11808 247102 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 20 Front Yard : Yard Tree Private 2     35     6002745.76405 2098754.96889 37.7429368028052 -122.43314215589 (37.7429368028052, -122.43314215589) 2 7 5 63 22
60884 247108 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 26 Front Yard : Yard Tree Private 2     48     6002704.67605 2098786.321 37.7430205575564 -122.433286466502 (37.7430205575564, -122.433286466502) 2 7 5 63 22
88434 247104 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 22 Front Yard : Yard Tree Private 2     31     6002734.00484 2098778.85198 37.743001713153 -122.433184522069 (37.743001713153, -122.433184522069) 2 7 5 63 22
94885 247113 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 31 Front Yard : Yard Tree Private 2     5     6002717.05441 2098681.21035 37.7427326503855 -122.433236156629 (37.7427326503855, -122.433236156629) 2 7 5 63 22
101832 247109 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 27 Front Yard : Yard Tree Private 2     55     6002712.35608 2098750.32101 37.7429221456486 -122.433257339272 (37.7429221456486, -122.433257339272) 2 7 5 63 22
145279 247112 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2301 Castro St 30 Front Yard : Yard Tree Private 2     4     6002722.94518 2098688.33329 37.7427525424969 -122.433216296891 (37.7427525424969, -122.433216296891) 2 7 5 63 22
20818 247070 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2401 Castro St 6 Front Yard : Yard Tree Private 2     24     6002744.91385 2098422.48032 37.7420238182333 -122.433121344697 (37.7420238182333, -122.433121344697) 2 7 5 63 22
67373 247069 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2401 Castro St 5 Front Yard : Yard Tree Private 2     25     6002737.44051 2098436.60323 37.7420621725331 -122.433148193957 (37.7420621725331, -122.433148193957) 2 7 5 63 22
92432 247072 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2401 Castro St 8 Front Yard : Yard Tree Private 2     22     6002777.34907 2098440.51813 37.7420751857223 -122.433010482565 (37.7420751857223, -122.433010482565) 2 7 5 63 22
101920 247071 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2401 Castro St 7 Front Yard : Yard Tree Private 2     27     6002776.8237 2098415.08611 37.7420053254986 -122.433010482544 (37.7420053254986, -122.433010482544) 2 7 5 63 22
12407 115154 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 245x ARLINGTON ST 3 Median : Yard Tree DPW 1       3x3   6004671 2096632 37.7372166357496 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
93601 115152 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 245x ARLINGTON ST 1 Median : Yard Tree DPW 1     30 3x3   6004671 2096632 37.7372166357496 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
97461 115155 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 245x ARLINGTON ST 4 Median : Yard Tree DPW 1       3x3   6004671 2096632 37.7372166357496 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
105484 115153 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 245x ARLINGTON ST 2 Median : Yard Tree DPW 1       3x3   6004671 2096632 37.7372166357496 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
126197 115156 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 245x ARLINGTON ST 5 Median : Yard Tree DPW 1       3x3   6004671 2096632 37.7372166357496 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
87762 117289 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 26X GLADEVIEW WAY 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   5997876 2101605 37.7504848455829 -122.450185761312 (37.7504848455829, -122.450185761312) 1 5 4 63 38
3910 173844 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 2X Crestline Dr 1 Front Yard : Yard Tree Private 2           5999319 2101169 37.7493701671822 -122.445164434644 (37.7493701671822, -122.445164434644) 2 5 5 63 38
120346 98601 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 301 Twin Peaks Blvd 1 Sidewalk: Property side : Cutout Tree Private 2     24 3x3   5998661.2 2104103.7 37.757390562446 -122.447650343479 (37.757390562446, -122.447650343479) 15 5 5 63 3
92200 247144 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500 27th St 14 Front Yard : Yard Tree Private 2     23     6003151.94767 2100099.93337 37.7466527951889 -122.431833698065 (37.7466527951889, -122.431833698065) 2 7 5 63 22
119760 247143 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500 27th St 13 Front Yard : Yard Tree Private 2     26     6003160.52798 2100099.92491 37.7466532583536 -122.431804027655 (37.7466532583536, -122.431804027655) 2 7 5 63 22
128762 247016 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500 Valley St 6 Sidewalk: Property side : Yard Tree Private 2     3     6002574.36339 2099193.51243 37.7441312166966 -122.433766148707 (37.7441312166966, -122.433766148707) 2 7 5 63 22
68284 253182 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 5157 Diamond Heights Blvd 1 Front Yard : Yard Tree Private 2           6000788 2100195 37.7467795353698 -122.440014780391 (37.7467795353698, -122.440014780391) 2 4 5 63 22
86615 253183 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 5159 Diamond Heights Blvd 1 Front Yard : Yard Tree Private 2           6000808 2099903 37.745978911495 -122.439924689335 (37.745978911495, -122.439924689335) 2 4 5 63 22
86352 234521 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 5300x Diamond Heights Blvd 4 Median : Yard Tree DPW 1     30     6001544.41953 2098938.98574 37.7433738490244 -122.437309239227 (37.7433738490244, -122.437309239227) 2 7 5 63 7
5758 262529 Property Tree 8 Pinus pinea :: Italian Stone Pine 63 555 Portola Dr 8 Front Yard : Yard Tree SFUSD 4       10x10   5997546 2099815 37.7455510557903 -122.451197845188 (37.7455510557903, -122.451197845188) 2 7 5 63 7
22210 111263 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 700X BOSWORTH ST 1 Front Yard : Yard Tree DPW 1     36     6002150 2095428 37.7337679036822 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
55697 111280 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 700X BOSWORTH ST 18 Front Yard : Cutout Tree DPW 1     48     6002150 2095428 37.7337679036822 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
148503 111281 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 700X BOSWORTH ST 19 Front Yard : Yard Tree DPW 1     48     6002150 2095428 37.7337679036822 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
50762 2044 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 700X Bosworth St 1 Front Yard : Cutout Tree DPW 1     36   Permit Number 772999 6002154.6210393 2095431.8532492 37.7337787461998 -122.434948555048 (37.7337787461998, -122.434948555048) 2 7 5 63 7
3008 251503 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800X Bosworth St 15 Side Yard : Yard Tree DPW 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
22926 251501 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800X Bosworth St 13 Side Yard : Yard Tree DPW 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
68470 251502 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800X Bosworth St 14 Side Yard : Yard Tree DPW 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
115262 251499 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800X Bosworth St 11 Side Yard : Yard Tree DPW 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
177928 251498 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800X Bosworth St 10 Side Yard : Yard Tree DPW 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
184944 251500 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800X Bosworth St 12 Side Yard : Yard Tree DPW 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
60691 111521 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800x BOSWORTH ST 16 Front Yard : Yard Tree DPW 1     36     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
63289 111517 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800x BOSWORTH ST 12 Front Yard : Yard Tree DPW 1     36     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
69354 111518 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800x BOSWORTH ST 13 Front Yard : Yard Tree DPW 1     27     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
90813 111522 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800x BOSWORTH ST 17 Front Yard : Yard Tree DPW 1     20     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
150055 111519 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800x BOSWORTH ST 14 Front Yard : Yard Tree DPW 1     36     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
183860 111506 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 800x BOSWORTH ST 1 Front Yard : Yard Tree DPW 1     48     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
163088 12974 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 84 Lippard Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6001901.0890899 2095580.5218873 37.7341725574726 -122.435835722721 (37.7341725574726, -122.435835722721) 2 7 5 63 7
136927 211081 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 90 Melrose Ave 7 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   5999513.42858 2095531.79881 37.7339028547188 -122.444087092249 (37.7339028547188, -122.444087092249) 9 7 4 63 40
186578 211080 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 90 Melrose Ave 5 Sidewalk: Property side : Yard Tree Private 2     6 Width 8ft   5999525.10685 2095532.7271 37.7339060697915 -122.444046783738 (37.7339060697915, -122.444046783738) 9 7 4 63 40
38246 111524 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900x BOSWORTH ST 2 Front Yard : Yard Tree DPW 1     28     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
110008 111523 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 900x BOSWORTH ST 1 Front Yard : Yard Tree DPW 1     28     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
15787 12969 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 99X Lippard Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     36 3X4   6001957.7757889 2095598.483465 37.7342250957668 -122.435641023763 (37.7342250957668, -122.435641023763) 2 7 5 63 7
121594 12970 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 99X Lippard Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     36 5X4   6001957.7757889 2095598.483465 37.7342250957668 -122.435641023763 (37.7342250957668, -122.435641023763) 2 7 5 63 7
134644 12968 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 99X Lippard Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     36 4X4   6001957.7757889 2095598.483465 37.7342250957668 -122.435641023763 (37.7342250957668, -122.435641023763) 2 7 5 63 7
186052 12967 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 99X Lippard Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   6001957.7757889 2095598.483465 37.7342250957668 -122.435641023763 (37.7342250957668, -122.435641023763) 2 7 5 63 7

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