trees

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
23834 107210 4 15 603 PERALTA AVE 1 unknown : Yard Tree 2     30     6009839.9 2098688.7 37.7431547125392 -122.408607810015 (37.7431547125392, -122.408607810015) 10 7 7 28859 2
50928 105667 4 127 301X DORADO TER 1 unknown : Yard Tree 2           5994306.4 2092922 37.7264385629619 -122.461900058607 (37.7264385629619, -122.461900058607) 9 8 4 28861 40
62684 106004 4 56 695X CAMPBELL AVE   unknown : Yard Tree 5           6009136.9 2088912.4 37.716271678506 -122.410348471622 (37.716271678506, -122.410348471622) 9 7 8 309 39
74819 105668 4 127 301X DORADO TER 2 unknown : Yard Tree 2     12     5994306.4 2092922 37.7264385629619 -122.461900058607 (37.7264385629619, -122.461900058607) 9 8 4 28861 40
125954 105666 4 52 317X DORADO TER 3 unknown : Yard Tree 2     22     5994307.4 2093021.4 37.7267115488018 -122.461903806308 (37.7267115488018, -122.461903806308) 9 8 4 28861 40
139334 105664 4 17 317X DORADO TER 1 unknown : Yard Tree 2     10     5994307.4 2093021.4 37.7267115488018 -122.461903806308 (37.7267115488018, -122.461903806308) 9 8 4 28861 40
190393 105665 4 52 317X DORADO TER 2 unknown : Yard Tree 2     24     5994307.4 2093021.4 37.7267115488018 -122.461903806308 (37.7267115488018, -122.461903806308) 9 8 4 28861 40
129277 103959 4 7 460X Lily St 1 unknown : Pot Tree 2           6004484.08045 2109981.44374 37.773860502373 -122.427931334456 (37.773860502373, -122.427931334456) 7 9 11 28852 10
159 117627 4 15 890x VERMONT ST 4 Unaccepted Street : Yard Tree 2           6011292 2104239 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201) 10 3 8 28856 29
1190 107158 4 35 101x Elsie St 1 Unaccepted Street : Yard Tree 2     20     6007300 2098759 37.7432051631731 -122.417395111614 (37.7432051631731, -122.417395111614) 2 7 7 28859 2
2335 262272 4 17 99X Glendale St   Unaccepted Street : Yard Tree 2       3x3   5999984 2103563 37.7559814441149 -122.443036761048 (37.7559814441149, -122.443036761048) 2 5 5 28862 38
5279 258778 4 15 701X Ortega Way 1 Unaccepted Street : Yard Tree 2       10x10   5991876 2102480 37.7525421857889 -122.470997752755 (37.7525421857889, -122.470997752755) 1 8 4 29491 12
8589 111310 4 105 99x GILROY ST 1 Unaccepted Street : Yard Tree 2       30x30   6015277 2088666 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034) 10 3 8 58 1
9075 121724 4 306 439X ARLINGTON ST 2 Unaccepted Street : Yard Tree 2           6003949.9 2096014.9 37.7354814316621 -122.42878329169 (37.7354814316621, -122.42878329169) 2 7 5 63 7
17203 107449 4 63 1130x CHESTNUT ST 1 Unaccepted Street : Yard Tree 2     60     6006351.9 2120450.9 37.8027125282147 -122.422214196597 (37.8027125282147, -122.422214196597) 5 9 1 28858 32
19314 114270 4 15 27x ESMERALDA AVE 2 Unaccepted Street : Yard Tree 2       3x3   6006799 2098981 37.743786524331 -122.41914318493 (37.743786524331, -122.41914318493) 2 7 7 28859 2
22968 115663 4 62 601x PERU AVE 1 Unaccepted Street : Yard Tree 2       3x3   6005068 2092670 37.7263602983163 -122.424679722884 (37.7263602983163, -122.424679722884) 9 7 6 28861 5
24450 111157 4 62 201x EUGENIA AVE 4 Unaccepted Street : Yard Tree 2       3x3   6006591 2098138 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536) 2 7 7 28859 2
24524 107157 4 15 301X Esmeralda Ave 1 Unaccepted Street : Yard Tree 2     28     6007313 2098782 37.7432690474632 -122.417351790512 (37.7432690474632, -122.417351790512) 2 7 7 28859 2
28400 99274 4 15 16 Joy St 1 Unaccepted Street : Yard Tree 2       3x3 Permit Number 768828 6010347.9 2098933.4 37.7438550437031 -122.406868515265 (37.7438550437031, -122.406868515265) 2 7 7 28859 2
30966 112739 4 41 444 Franconia St 3 Unaccepted Street : Yard Tree 2     30     6009949.70212209 2098546.33795552 37.7427699663381 -122.408218103257 (37.7427699663381, -122.408218103257) 10 7 7 28859 2
34078 106506 4 70 3975 22nd St 2 Unaccepted Street : Yard Tree 2         Permit Number 773291 6002049 2102913 37.7543142223274 -122.435848813122 (37.7543142223274, -122.435848813122) 2 4 5 28862 22
35560 98376 4 41 199X Cragmont Ave 1 Unaccepted Street : Yard Tree 2           5992899 2101153 37.7489576989052 -122.467363590244 (37.7489576989052, -122.467363590244) 1 8 4 29491 40
41809 106281 4 456 399X Elliot St 2 Unaccepted Street : Yard Tree 5         Permit Number 772905 6008798.75873 2088103.62049 37.7140319762934 -122.411460149363 (37.7140319762934, -122.411460149363) 9 7 8 309 39
42128 102522 4 109 1X 31st St 2 Unaccepted Street : Yard Tree 2           5999966.2 2097547.4 37.7394630398899 -122.442666404233 (37.7394630398899, -122.442666404233) 9 7 4 59 40
42371 115664 4 62 601x PERU AVE 2 Unaccepted Street : Yard Tree 2       3x3   6005068 2092670 37.7263602983163 -122.424679722884 (37.7263602983163, -122.424679722884) 9 7 6 28861 5
45331 107372 4 216 305x GREENWICH ST 1 Unaccepted Street : Yard Tree 2     20     6011370 2120243 37.8024234525216 -122.404834287898 (37.8024234525216, -122.404834287898) 3 1 10 308 23
46286 111319 4 127 200x PENINSULA AVE 2 Unaccepted Street : Yard Tree 2           6012569 2087626 37.7129312780718 -122.398395185538 (37.7129312780718, -122.398395185538) 10 3 8 309 1
49395 111159 4 62 201x EUGENIA AVE 6 Unaccepted Street : Yard Tree 2       3x3   6006591 2098138 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536) 2 7 7 28859 2
50112 109625 4 63 312x FILBERT ST 1 Unaccepted Street : Yard Tree 2     14     6011362.9 2120079.8 37.801974948341 -122.40484736081 (37.801974948341, -122.40484736081) 3 1 10 308 23
52679 105069 4 14 49X Esmeralda Ave 2 Unaccepted Street : Yard Tree 2         Permit Number 771039 6006861 2099026 37.7439135755866 -122.418931994103 (37.7439135755866, -122.418931994103) 2 7 7 28859 2
58486 111156 4 62 201x EUGENIA AVE 3 Unaccepted Street : Yard Tree 2       3x3   6006591 2098138 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536) 2 7 7 28859 2
67245 117626 4 15 890x VERMONT ST 3 Unaccepted Street : Yard Tree 2           6011292 2104239 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201) 10 3 8 28856 29
71480 112615 4 15 1798x 22ND ST 2 Unaccepted Street : Yard Tree 2   05/02/2016 12:00:00 AM 3     6012787 2103832 37.7574417223043 -122.398778335858 (37.7574417223043, -122.398778335858) 10 3 8 28856 29
73180 111309 4 105 100x GILROY ST 1 Unaccepted Street : Yard Tree 2       30x30   6015178 2088529 37.7155557353625 -122.389440569451 (37.7155557353625, -122.389440569451) 10 3 8 58 1
73281 111318 4 127 200x PENINSULA AVE 1 Unaccepted Street : Yard Tree 2           6012569 2087626 37.7129312780718 -122.398395185538 (37.7129312780718, -122.398395185538) 10 3 8 309 1
79539 95436 4 56 2675 25th Ave 3 Unaccepted Street : Yard Tree 2     16     5988610 2097126.3 37.7376529013161 -122.481899870051 (37.7376529013161, -122.481899870051) 1 8 3 29491 35
83802 115379 4 17 4004 20TH ST   Unaccepted Street : Yard Tree 2       3x3   6003604 2104237 37.758037821948 -122.430565699194 (37.758037821948, -122.430565699194) 2 4 5 28862 3
85470 106280 4 456 399X Elliot St 1 Unaccepted Street : Yard Tree 5         Permit Number 772905 6008798.75873 2088103.62049 37.7140319762934 -122.411460149363 (37.7140319762934, -122.411460149363) 9 7 8 309 39
86119 111312 4 105 99x GILROY ST 3 Unaccepted Street : Yard Tree 2       30x30   6015277 2088666 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034) 10 3 8 58 1
88123 101366 4 172 1348 Noe St   Unaccepted Street : Yard Tree 2     24   Owner: Brent Sommer 519-1119 nocmout@gmail.com 6003163.2 2100416 37.7475212781449 -122.43181735246 (37.7475212781449, -122.43181735246) 2 4 5 63 22
89451 115665 4 62 601x PERU AVE 3 Unaccepted Street : Yard Tree 2       3x3   6005068 2092670 37.7263602983163 -122.424679722884 (37.7263602983163, -122.424679722884) 9 7 6 28861 5
89537 111311 4 105 99x GILROY ST 2 Unaccepted Street : Yard Tree 2       30x30   6015277 2088666 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034) 10 3 8 58 1
90922 121630 4 62 96x Valmar Ter 1 Unaccepted Street : Yard Tree 2     12 3x3   6005224 2092573 37.7261027669422 -122.42413354236 (37.7261027669422, -122.42413354236) 9 7 6 28861 5
94771 110864 4 528 1798x 22ND ST 1 Unaccepted Street : Yard Tree 2           6012787 2103832 37.7574417223043 -122.398778335858 (37.7574417223043, -122.398778335858) 10 3 8 28856 29
94940 111154 4 62 201x EUGENIA AVE 1 Unaccepted Street : Yard Tree 2       3x3   6006591 2098138 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536) 2 7 7 28859 2
98353 109309 4 15 349x MAYFLOWER ST 1 Unaccepted Street : Yard Tree 2           6009941 2098430 37.7424500403346 -122.408239989358 (37.7424500403346, -122.408239989358) 10 7 7 28859 2
99208 112729 4 15 444 Franconia St 2 Unaccepted Street : Yard Tree 2     24     6009949.70212209 2098546.33795552 37.7427699663381 -122.408218103257 (37.7427699663381, -122.408218103257) 10 7 7 28859 2
103178 107527 4 184 2540x LYON ST 1 Unaccepted Street : Yard Tree 2     30   Permit Number 774117 5999227 2117510 37.7942331479636 -122.446658147156 (37.7942331479636, -122.446658147156) 13   1 57 30
103781 108605 4 63 1140x CHESTNUT ST 2 Unaccepted Street : Yard Tree 2           6006369.1 2120452.7 37.8027184407042 -122.422154803739 (37.8027184407042, -122.422154803739) 5 9 1 28858 32
108041 111158 4 62 201x EUGENIA AVE 5 Unaccepted Street : Yard Tree 2       3x3   6006591 2098138 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536) 2 7 7 28859 2
109691 113439 4 172 401x POWHATTAN AVE 1 Unaccepted Street : Yard Tree 2     20 3x3   6008174 2098184 37.7416754763214 -122.414332364983 (37.7416754763214, -122.414332364983) 2 7 7 28859 2
112586 106503 4 70 3974 22nd St 1 Unaccepted Street : Yard Tree 2         Permit Number 773286 6002049 2102947 37.754407578182 -122.435851245675 (37.754407578182, -122.435851245675) 2 4 5 28862 22
115276 122590 4 18 100 MacOndray Ln 1 Unaccepted Street : Yard Tree 2           6008161 2119143 37.7992232381339 -122.415861106147 (37.7992232381339, -122.415861106147) 5 1 10 308 32
123017 105651 4 268 150 BRONTE ST 2 Unaccepted Street : Yard Tree 2     20     6009287.5 2096640.3 37.737499298819 -122.410373266073 (37.737499298819, -122.410373266073) 10 7 7 28859 2
124486 99112 4 127 80X Bradford St 1 Unaccepted Street : Yard Tree 2           6009564.7 2098208.3 37.7418202221976 -122.409525484318 (37.7418202221976, -122.409525484318) 10 7 7 28859 2
124765 99110 4 127 94 Bernal Heights Blvd 1 Unaccepted Street : Yard Tree 2           6009548.4 2098143.7 37.7416419313174 -122.409577286243 (37.7416419313174, -122.409577286243) 10 7 7 28859 2
125905 102521 4 15 1X 31st St 1 Unaccepted Street : Yard Tree 2           5999966.2 2097547.4 37.7394630398899 -122.442666404233 (37.7394630398899, -122.442666404233) 9 7 4 59 40
130332 102729 4 15 49X Esmeralda Ave 1 Unaccepted Street : Yard Tree 2     24     6006840.1 2099056.7 37.7439966940099 -122.419006438675 (37.7439966940099, -122.419006438675) 2 7 7 28859 2
130598 106504 4 70 3974 22nd St 2 Unaccepted Street : Yard Tree 2         Permit Number 773286 6002049 2102947 37.754407578182 -122.435851245675 (37.754407578182, -122.435851245675) 2 4 5 28862 22
131481 106505 4 70 3975 22nd St 1 Unaccepted Street : Yard Tree 2         Permit Number 773291 6002049 2102913 37.7543142223274 -122.435848813122 (37.7543142223274, -122.435848813122) 2 4 5 28862 22
137991 98379 4 41 199X Cragmont Ave 4 Unaccepted Street : Yard Tree 2           5992899 2101153 37.7489576989052 -122.467363590244 (37.7489576989052, -122.467363590244) 1 8 4 29491 40
139191 111155 4 62 201x EUGENIA AVE 2 Unaccepted Street : Yard Tree 2       3x3   6006591 2098138 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536) 2 7 7 28859 2
140063 95435 4 155 2675 25th Ave 2 Unaccepted Street : Yard Tree 2     12     5988610 2097126.3 37.7376529013161 -122.481899870051 (37.7376529013161, -122.481899870051) 1 8 3 29491 35
140615 96803 4 56 300X Melrose Ave 1 Unaccepted Street : Yard Tree 2     48     5998134.5 2095546.7 37.7338650092742 -122.448855518806 (37.7338650092742, -122.448855518806) 9 7 4 59 40
141297 105070 4 14 49X Esmeralda Ave 3 Unaccepted Street : Yard Tree 2         Permit Number 771039 6006861 2099026 37.7439135755866 -122.418931994103 (37.7439135755866, -122.418931994103) 2 7 7 28859 2
141724 98377 4 41 199X Cragmont Ave 2 Unaccepted Street : Yard Tree 2           5992899 2101153 37.7489576989052 -122.467363590244 (37.7489576989052, -122.467363590244) 1 8 4 29491 40
144056 109200 4 127 2401x CASTRO ST 7 Unaccepted Street : Yard Tree 1           6002698 2098487 37.7421983129634 -122.433288166914 (37.7421983129634, -122.433288166914) 2 7 5 63 7
147160 99960 4 74 279 Filbert St 1 Unaccepted Street : Yard Tree 2         shared responsibility with 1400 Montgomery 6011546.2 2120046.5 37.8018937585678 -122.40421070766 (37.8018937585678, -122.40421070766) 3 1 10 308 23
149123 117545 4 330 3340x HARRISON ST 1 Unaccepted Street : Yard Tree 2     20 3x3   6008964 2099209 37.7445342470575 -122.411673205451 (37.7445342470575, -122.411673205451) 2 7 7 28859 2
149227 105652 4 268 150 BRONTE ST 4 Unaccepted Street : Yard Tree 2     25     6009287.5 2096640.3 37.737499298819 -122.410373266073 (37.737499298819, -122.410373266073) 10 7 7 28859 2
150450 95432 4 155 2675 25th Ave 1 Unaccepted Street : Yard Tree 2     12     5988610 2097126.3 37.7376529013161 -122.481899870051 (37.7376529013161, -122.481899870051) 1 8 3 29491 35
158117 107675 4 16 98x LUNDYS LN 1 Unaccepted Street : Yard Tree 2     14 8x10   6006855 2099015 37.7438830341993 -122.418951960739 (37.7438830341993, -122.418951960739) 2 7 7 28859 2
162309 106282 4 456 399X Elliot St 3 Unaccepted Street : Yard Tree 5         Permit Number 772905 6008798.75873 2088103.62049 37.7140319762934 -122.411460149363 (37.7140319762934, -122.411460149363) 9 7 8 309 39
164541 111320 4 127 200x PENINSULA AVE 3 Unaccepted Street : Yard Tree 2           6012569 2087626 37.7129312780718 -122.398395185538 (37.7129312780718, -122.398395185538) 10 3 8 309 1
165174 112379 4 15 25x ESMERALDA AVE 1 Unaccepted Street : Yard Tree 2     20 3x3   6006716 2099027 37.7439081554699 -122.419433442615 (37.7439081554699, -122.419433442615) 2 7 7 28859 2
165277 115525 4 303 25 FRANCONIA ST 2 Unaccepted Street : Yard Tree 2       3x3   6010006 2099954 37.7466382512014 -122.408122694659 (37.7466382512014, -122.408122694659) 2 7 7 28859 2
168219 117624 4 537 890x VERMONT ST 2 Unaccepted Street : Yard Tree 2           6011292 2104239 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201) 10 3 8 28856 29
172476 98706 4 41 353 UPPER TER   Unaccepted Street : Yard Tree 2           5999086.1 2105914.9 37.7623879420949 -122.446311165521 (37.7623879420949, -122.446311165521) 15 5 5 29492 9
176510 115666 4 62 601x PERU AVE 4 Unaccepted Street : Yard Tree 2       3x3   6005068 2092670 37.7263602983163 -122.424679722884 (37.7263602983163, -122.424679722884) 9 7 6 28861 5
192530 114586 4 15 155x BRONTE ST 1 Unaccepted Street : Yard Tree 2     15 3x3 Permit Number 777226 6009330 2096609 37.7374157381662 -122.410224113722 (37.7374157381662, -122.410224113722) 10 7 7 28859 2
193436 105653 4 15 150 BRONTE ST 3 Unaccepted Street : Yard Tree 2     16   Permit Number 770978 6009287.5 2096640.3 37.737499298819 -122.410373266073 (37.737499298819, -122.410373266073) 10 7 7 28859 2
6380 110632 4 17 1051X Mandalay Ln 1 Unaccepted Street : Cutout Tree 2           5991736.20076 2101819.33429 37.7507200830769 -122.47143306251 (37.7507200830769, -122.47143306251) 1 8 4 29491 12
10855 262421 4 62 123 Moultrie St 1 Unaccepted Street : Cutout Tree 2       3x3   6007822 2098282 37.7419247830103 -122.415556403469 (37.7419247830103, -122.415556403469) 2 7 7 28859 2
20018 256139 4 56 888 Moultrie St 1 Unaccepted Street : Cutout Tree 2       3x3   6007515 2095179 37.7333873668614 -122.416398174089 (37.7333873668614, -122.416398174089) 2 7 7 28859 2
24272 117475 4 59 1200x MONTGOMERY ST 2 Unaccepted Street : Cutout Tree 2           6011580 2119440 37.800230345698 -122.404051036068 (37.800230345698, -122.404051036068) 3 1 10 308 23
34416 110631 4 17 1001X Mandalay Ln   Unaccepted Street : Cutout Tree 2           5991736.20076 2101819.33429 37.7507200830769 -122.47143306251 (37.7507200830769, -122.47143306251) 1 8 4 29491 12
42959 117474 4 59 1200x MONTGOMERY ST 1 Unaccepted Street : Cutout Tree 2           6011580 2119440 37.800230345698 -122.404051036068 (37.800230345698, -122.404051036068) 3 1 10 308 23
69278 111914 4 15 60 LOWER TER 1 Unaccepted Street : Cutout Tree 2     28 3x3   6000264 2106046 37.7628151124003 -122.442246670025 (37.7628151124003, -122.442246670025) 15 5 5 28862 3
94661 110323 4 17 1501x SHOTWELL ST 2 Unaccepted Street : Cutout Tree 2   05/15/2015 12:00:00 AM 3 3x3 Permit Number 775301 6008079 2099374 37.7449376155386 -122.414745041111 (37.7449376155386, -122.414745041111) 2 7 7 28859 2
95955 117473 4 59 1201x MONTGOMERY ST 1 Unaccepted Street : Cutout Tree 2           6011733 2119731 37.8010379082809 -122.403542078239 (37.8010379082809, -122.403542078239) 3 1 10 308 23
104363 114768 4 15 155X Bronte St 1 Unaccepted Street : Cutout Tree 2     12     6009330.8 2096609.5 37.737417155901 -122.410221383029 (37.737417155901, -122.410221383029) 10 7 7 28859 2
104364 114271 4 330 49x ESMERALDA AVE 1 Unaccepted Street : Cutout Tree 2     27 3x3   6006783 2099038 37.7439421324692 -122.419202551725 (37.7439421324692, -122.419202551725) 2 7 7 28859 2
104452 110629 4 15 1000X MANDALAY LN 1 Unaccepted Street : Cutout Tree 2           5991616 2101838 37.7507643799851 -122.471850083311 (37.7507643799851, -122.471850083311) 1 8 4 29491 12
106132 110322 4 17 1501x SHOTWELL ST 1 Unaccepted Street : Cutout Tree 2   05/15/2015 12:00:00 AM 3 3x3 Permit Number 775301 6008079 2099374 37.7449376155386 -122.414745041111 (37.7449376155386, -122.414745041111) 2 7 7 28859 2
106368 117063 4 168 229 MONTCALM ST 1 Unaccepted Street : Cutout Tree 2       3x3   6009811 2099554 37.7455290185947 -122.40876877231 (37.7455290185947, -122.40876877231) 2 7 7 28859 2
107173 117071 4 163 10 JOY ST 1 Unaccepted Street : Cutout Tree 2       3x3   6010420 2098909 37.7437920807055 -122.406617489968 (37.7437920807055, -122.406617489968) 2 7 7 28859 2
114094 117472 4 59 1201x MONTGOMERY ST 2 Unaccepted Street : Cutout Tree 2           6011733 2119731 37.8010379082809 -122.403542078239 (37.8010379082809, -122.403542078239) 3 1 10 308 23
116312 121792 4 15 2556 Broderick St 1 Unaccepted Street : Cutout Tree 2       3x3   6000243 2117343 37.7938325936105 -122.443130684772 (37.7938325936105, -122.443130684772) 13 9 1 57 27
117991 120968 4 127 79x Bradford St 1 Unaccepted Street : Cutout Tree 2     30 3x3   6009615 2098188 37.7417673011584 -122.409350130422 (37.7417673011584, -122.409350130422) 10 7 7 28859 2
120666 110647 4 170 300x NAGLEE AVE 1 Unaccepted Street : Cutout Tree 2     12 3x3   5997872 2088397 37.7142185912398 -122.449248128432 (37.7142185912398, -122.449248128432) 9 7 6 28861 25