59 rows where Zip Codes = 28862 and qSpecies_id = 65 sorted by Neighborhoods (old)

View and edit SQL

Zip Codes

  • 28862 · 59
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) ▼
10243 221904 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 583 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/02/2020 12:00:00 AM 3 Width 3ft Permit Number 785229 6001404.83719 2101424.58127 37.7501907685919 -122.437969880314 (37.7501907685919, -122.437969880314) 2 4 5 28862 22
22632 221918 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 78 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 5ft   6004080.11539 2102633.34286 37.7536615185686 -122.428804766139 (37.7536615185686, -122.428804766139) 2 4 5 28862 22
24073 221906 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 879 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 3ft   6002491.82292 2103096.81966 37.7548440920015 -122.434330562332 (37.7548440920015, -122.434330562332) 2 4 5 28862 22
30130 221910 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1175 Noe St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   6003225.80615 2101486.76003 37.7504648828526 -122.431677300586 (37.7504648828526, -122.431677300586) 2 4 5 28862 22
35685 99537 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 3720 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/16/2012 12:00:00 AM   3x3 Permit Number 768635 6004924.7 2102557.1 37.7534999396673 -122.425878575683 (37.7534999396673, -122.425878575683) 2 4 5 28862 22
44302 221856 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 310 Hoffman Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6000610.61852 2101933.59312 37.7515431951678 -122.440752837776 (37.7515431951678, -122.440752837776) 2 4 5 28862 22
45404 221907 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1217 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6003244.02772 2101149.87665 37.7495409130801 -122.431590240821 (37.7495409130801, -122.431590240821) 2 4 5 28862 22
47906 67034 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 3947 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1992 12:00:00 AM     Permit Number 30406 6003485.5850907 2102413.54143102 37.7530243281476 -122.430845098487 (37.7530243281476, -122.430845098487) 2 4 5 28862 22
65253 114757 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 861 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/04/2015 12:00:00 AM     Permit Number 777137 6000857.2 2101959.2 37.7516275450509 -122.439901966271 (37.7516275450509, -122.439901966271) 2 4 5 28862 22
67738 221916 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 429 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6004184.08219 2101438.38346 37.7503863234716 -122.428360063075 (37.7503863234716, -122.428360063075) 2 4 5 28862 22
71288 53235 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 80 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1992 12:00:00 AM     Permit Number 31473 6004075.80842764 2102593.23401919 37.7535511453461 -122.428816801411 (37.7535511453461, -122.428816801411) 2 4 5 28862 22
71659 221855 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 310 Hoffman Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6000611.21677 2101947.64163 37.7515818030572 -122.440751776575 (37.7515818030572, -122.440751776575) 2 4 5 28862 22
72559 221853 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 430 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6002339.61262 2100938.00703 37.7489078650277 -122.434702583968 (37.7489078650277, -122.434702583968) 2 4 5 28862 22
72933 221807 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3720 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6004936.8002 2102544.12819 37.7534650059101 -122.425835807291 (37.7534650059101, -122.425835807291) 2 4 5 28862 22
73986 221859 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 861 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6000847.19345 2101982.10251 37.7516898602076 -122.439938212095 (37.7516898602076, -122.439938212095) 2 4 5 28862 22
85505 221920 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 963 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     29 4x4   6003802.10196 2102678.82151 37.7537706531042 -122.429769441907 (37.7537706531042, -122.429769441907) 2 4 5 28862 22
87919 221912 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 424 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6003582.26596 2102758.00468 37.7539756202844 -122.43053533425 (37.7539756202844, -122.43053533425) 2 4 5 28862 22
89825 67817 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 76 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1992 12:00:00 AM     Permit Number 31472 6004074.53693177 2102616.18239315 37.7536140842238 -122.428822834401 (37.7536140842238, -122.428822834401) 2 4 5 28862 22
99045 221908 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1175 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 5ft   6003228.29657 2101452.81084 37.7503718075255 -122.431666264992 (37.7503718075255, -122.431666264992) 2 4 5 28862 22
99862 221909 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1175 Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2     32 Width 5ft   6003227.24309 2101470.4878 37.7504202845862 -122.43167116991 (37.7504202845862, -122.43167116991) 2 4 5 28862 22
100080 67827 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 429 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1992 12:00:00 AM     Permit Number 31487 6004187.64685523 2101514.68763135 37.7505960386394 -122.428353174015 (37.7505960386394, -122.428353174015) 2 4 5 28862 22
100713 221919 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 80 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 5ft   6004080.1128 2102611.51792 37.7536015922648 -122.428803219313 (37.7536015922648, -122.428803219313) 2 4 5 28862 22
103785 63866 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 879 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/16/1987 12:00:00 AM     Permit Number 24569 6002490.08825783 2103093.39072976 37.7548345785172 -122.434336316133 (37.7548345785172, -122.434336316133) 2 4 5 28862 22
106236 120108 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 3528 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/03/2016 12:00:00 AM 3 3x3 Permit Number 778087 6004858 2103141 37.7550994230029 -122.426150804554 (37.7550994230029, -122.426150804554) 2 4 5 28862 22
121593 221917 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1033 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6003826.31981 2102255.52555 37.7526097533439 -122.429655503209 (37.7526097533439, -122.429655503209) 2 4 5 28862 22
125012 221854 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4418 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 2ft   6000475.00831 2102295.38218 37.7525288566262 -122.441247749083 (37.7525288566262, -122.441247749083) 2 4 5 28862 22
131328 221913 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3947 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6003448.79955 2102413.03039 37.7530208406643 -122.430972273466 (37.7530208406643, -122.430972273466) 2 4 5 28862 22
139150 221852 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4338 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     32 Width 4ft   6001688.98407 2100608.31061 37.747965638118 -122.436928854805 (37.747965638118, -122.436928854805) 2 4 5 28862 22
143155 221914 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 476 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6003319.74249 2102160.73191 37.7523207750848 -122.431400568387 (37.7523207750848, -122.431400568387) 2 4 5 28862 22
144494 221905 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 572 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6002660.0308 2103294.31011 37.7553958998276 -122.433762967812 (37.7553958998276, -122.433762967812) 2 4 5 28862 22
148866 67788 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 3879 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1992 12:00:00 AM     Permit Number 31428 6003934.74347541 2102438.27189101 37.7531176706218 -122.42929358548 (37.7531176706218, -122.42929358548) 2 4 5 28862 22
149504 221911 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1175 Noe St 4 Sidewalk: Curb side : Cutout Tree Private 2     31 Width 5ft   6003226.50292 2101503.3413 37.7505104506147 -122.431676074804 (37.7505104506147, -122.431676074804) 2 4 5 28862 22
155147 221860 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 516 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/27/1998 12:00:00 AM 15 Width 3ft Permit Number 39568 6001163.03933 2103237.69221 37.7551553815387 -122.438935950032 (37.7551553815387, -122.438935950032) 2 4 5 28862 22
159463 57100 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 3720 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/16/2012 12:00:00 AM     Permit Number 768635 6004924.75692274 2102545.44998856 37.7534679546686 -122.425877549626 (37.7534679546686, -122.425877549626) 2 4 5 28862 22
163176 67814 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 963 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1992 12:00:00 AM     Permit Number 31468 6003800.96031756 2102663.38209888 37.7537281954709 -122.429772288819 (37.7537281954709, -122.429772288819) 2 4 5 28862 22
186130 221808 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3720 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6004922.45206 2102542.08461 37.753458583869 -122.425885280803 (37.753458583869, -122.425885280803) 2 4 5 28862 22
192627 221915 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 476 Elizabeth St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6003301.60957 2102160.71382 37.7523196977161 -122.431463273608 (37.7523196977161, -122.431463273608) 2 4 5 28862 22
193961 63264 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 474 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1999 12:00:00 AM     Permit Number 23819 6003326.56560874 2102164.81247283 37.7523323660448 -122.431377264225 (37.7523323660448, -122.431377264225) 2 4 5 28862 22
3367 221931 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2136 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6003273.64696 2107146.54353 37.7660080078823 -122.431915952764 (37.7660080078823, -122.431915952764) 15 5 5 28862 3
8855 221923 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 274 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6002696.84533 2104324.2367 37.758225920618 -122.433709258485 (37.758225920618, -122.433709258485) 2 4 5 28862 3
11193 221927 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 30 Collingwood St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001978.23682 2105679.10169 37.7619052494464 -122.436291477373 (37.7619052494464, -122.436291477373) 15 4 5 28862 3
16727 227695 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4250 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6001245.67427 2103366.3123 37.7555132424609 -122.438659390527 (37.7555132424609, -122.438659390527) 2 4 5 28862 3
25181 221922 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 142 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6002658.74413 2105066.93812 37.7602630379377 -122.433894115042 (37.7602630379377, -122.433894115042) 2 4 5 28862 3
31052 109288 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 274 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/06/2015 12:00:00 AM 3 3x3 Permit Number 773379 6002625.7 2104315.8 37.7581987182413 -122.433954706682 (37.7581987182413, -122.433954706682) 2 4 5 28862 3
31207 32474 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 7 Ord St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/10/1996 12:00:00 AM 15   Permit Number 36982 6000854.39467 2106273.37873 37.7634730690508 -122.440221013784 (37.7634730690508, -122.440221013784) 15 5 5 28862 3
48932 221930 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2134 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6003302.06195 2107147.52772 37.7660123210304 -122.431817741407 (37.7660123210304, -122.431817741407) 15 5 5 28862 3
56352 238396 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2221 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/16/2018 12:00:00 AM 3 3x3 Permit Number 782349 6002719.76824 2107072.27368 37.7657726661007 -122.433826396093 (37.7657726661007, -122.433826396093) 15 5 5 28862 3
59484 221933 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 4166 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6001253.22781 2105851.44827 37.7623372504834 -122.438811343586 (37.7623372504834, -122.438811343586) 15 5 5 28862 3
73676 102018 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 4252 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6001333 2103370 37.7555283353782 -122.438357655981 (37.7555283353782, -122.438357655981) 2 4 5 28862 3
90849 221932 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 265 Henry St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6001846.56535 2107325.41516 37.7664181410013 -122.436864736716 (37.7664181410013, -122.436864736716) 15 5 5 28862 3
105651 32556 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 233 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/22/1996 12:00:00 AM 7   Permit Number 37043 6004755.28395 2103949.67696 37.7573140539292 -122.42656360702 (37.7573140539292, -122.42656360702) 2 4 5 28862 3
107364 221928 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3666 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6002501.47722 2106518.4971 37.7642397410968 -122.434541817574 (37.7642397410968, -122.434541817574) 15 5 5 28862 3
108472 109743 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 142 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/03/2015 12:00:00 AM 3 3x3 Permit Number 775046 6002641.7 2105066.1 37.7602597694278 -122.433953002704 (37.7602597694278, -122.433953002704) 2 4 5 28862 3
114883 221926 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 651 Noe St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003063.55536 2104400.84265 37.7584570634637 -122.432446488035 (37.7584570634637, -122.432446488035) 2 4 5 28862 3
134976 255531 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 2130 15th St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/2018 12:00:00 AM 3 3x3 Permit Number 782019 6003380.68215 2107148.89983 37.7660205449408 -122.431545908158 (37.7660205449408, -122.431545908158) 15 5 5 28862 3
139226 221921 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 474 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6002945.55902 2105503.88006 37.7614790472472 -122.432933374683 (37.7614790472472, -122.432933374683) 15 4 5 28862 3
163060 221924 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 651 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6003063.54599 2104384.44794 37.7584120469841 -122.432445349468 (37.7584120469841, -122.432445349468) 2 4 5 28862 3
185444 221929 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 70 Beaver St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6002463.4686 2106805.25277 37.7650249445694 -122.434693785007 (37.7650249445694, -122.434693785007) 15 5 5 28862 3
191257 221925 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 651 Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003063.11799 2104395.60529 37.7584426581259 -122.432447626582 (37.7584426581259, -122.432447626582) 2 4 5 28862 3

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