trees

Custom SQL query returning 54 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
5288 260453 8 62 3554 Alemany Blvd 4 unknown : Yard Tree 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
7863 260451 8 62 3554 Alemany Blvd 2 unknown : Yard Tree 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
8587 260455 8 62 3554 Alemany Blvd 6 unknown : Yard Tree 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
12648 260457 8 62 3554 Alemany Blvd 8 unknown : Yard Tree 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
16690 260450 8 62 3554 Alemany Blvd 1 unknown : Yard Tree 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
19362 260454 8 62 3554 Alemany Blvd 5 unknown : Yard Tree 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
19609 260452 8 62 3554 Alemany Blvd 3 unknown : Yard Tree 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
27177 101951 8 17 21 Lyell St   unknown : Yard Tree 2           6003106 2094969 37.7325618289587 -122.43162632292 (37.7325618289587, -122.43162632292) 9 7 5 28861 25
7701 97237 8 9 125 Excelsior Ave   Sidewalk: Property side : Yard Tree 4 FUF 09/07/2011 12:00:00 AM     Permit Number 767513 6002911 2092621.3 37.7261045201699 -122.432132888294 (37.7261045201699, -122.432132888294) 9 7 6 28861 5
21821 97236 8 317 125 Excelsior Ave   Sidewalk: Property side : Yard Tree 4 FUF 09/07/2011 12:00:00 AM     Permit Number 767513 6002911 2092621.3 37.7261045201699 -122.432132888294 (37.7261045201699, -122.432132888294) 9 7 6 28861 5
106561 97238 8 9 125 Excelsior Ave 1 Sidewalk: Property side : Yard Tree 4 FUF 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767513 6002911 2092621.3 37.7261045201699 -122.432132888294 (37.7261045201699, -122.432132888294) 9 7 6 28861 5
80950 255115 8 11 301X Chester Ave 2 Sidewalk: Property side : Cutout Tree 2       10x10   5991786 2087190 37.7105544703116 -122.470195673297 (37.7105544703116, -122.470195673297) 9 8 4 64 24
153614 255116 8 28 301X Chester Ave 3 Sidewalk: Property side : Cutout Tree 1       10x10   5991786 2087190 37.7105544703116 -122.470195673297 (37.7105544703116, -122.470195673297) 9 8 4 64 24
6335 262305 8 112 100 Saint Elmo Way 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5994960 2094889 37.7318770738882 -122.459783023889 (37.7318770738882, -122.459783023889) 9 8 4 59 40
7179 260247 8 224 568 Huron Ave 1 Sidewalk: Curb side : Cutout Tree 2           5998297.39121 2088148.96817 37.7135618752392 -122.447759972312 (37.7135618752392, -122.447759972312) 9 7 6 28861 25
13403 261178 8 160 205 Leland Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6009827 2087549 37.7125667222905 -122.407867055005 (37.7125667222905, -122.407867055005) 9 7 8 309 39
124062 102101 8 64 331 Vernon St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/19/2012 12:00:00 AM 12 3x3 Permit Number 769722 5992434.3 2090067.3 37.7184923011832 -122.468164197766 (37.7184923011832, -122.468164197766) 9 8 6 64 24
154591 112948 8 1 400 Pioche St 1 Sidewalk: Curb side : Cutout Tree 1 FUF   12 3x15   6005670.66964 2093276.94718 37.7280608613968 -122.422639431486 (37.7280608613968, -122.422639431486) 9 7 7 309 5
194103 109076 8 40 1137 Munich St 1 Sidewalk: Curb side : Cutout Tree 2 FUF     3x3 Permit Number 772744 6001554.7 2087011.6 37.7106245477128 -122.436420213894 (37.7106245477128, -122.436420213894) 9 7 6 28861 5
53415 254271 8 15 1201X Junipero Serra Blvd 1 Side Yard : Yard Tree 8       10x10   5991180 2089593 37.717117469349 -122.472465193375 (37.717117469349, -122.472465193375) 9 8 6 64 24
171323 253471 8 240 17 Valletta Ct 1 Side Yard : Yard Tree 2       6x10   5999337 2096545 37.7366747995559 -122.444769861358 (37.7366747995559, -122.444769861358) 9 7 4 63 40
194461 265095 8 35 1100 Junipero Serra Blvd 1 Side Yard : Cutout Tree 2       10x10   5991104 2090006 37.7182470667789 -122.472757983106 (37.7182470667789, -122.472757983106) 9 8 4 64 40
12060 101900 8 15 1100 Ocean Ave 1 Front Yard : Yard Tree 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
30542 98548 8 155 132 Hamerton Ave 1 Front Yard : Yard Tree 2           6001332.8 2095440.7 37.7337563407686 -122.437790462907 (37.7337563407686, -122.437790462907) 9 7 5 63 40
44661 102745 8 41 222 Moncada Way 1 Front Yard : Yard Tree 2           5992354 2093377.4 37.7275763858966 -122.468682482409 (37.7275763858966, -122.468682482409) 9 8 4 59 40
53937 94690 8 348 749 Congo St   Front Yard : Yard Tree 2   10/28/2010 12:00:00 AM     Permit Number 53820 6000274 2096023 37.735294937499 -122.441492809367 (37.735294937499, -122.441492809367) 9 7 4 63 40
54121 101901 8 16 1100 Ocean Ave 2 Front Yard : Yard Tree 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
101831 120995 8 284 231 Delano Ave 1 Front Yard : Yard Landscaping 2       3x3   6000066 2092260 37.7249507611268 -122.44194193564 (37.7249507611268, -122.44194193564) 9 7 6 28861 25
124153 118318 8 58 20 Norton St 1 Front Yard : Yard Tree 3           6002015.68632 2092167.12899 37.7248066672809 -122.435195459751 (37.7248066672809, -122.435195459751) 9 7 6 28861 25
128219 101903 8 72 1100 Ocean Ave 4 Front Yard : Yard Tree 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
129765 105353 8 17 1979 SAN JOSE AVE 2 Front Yard : Yard Tree 2   04/16/2014 12:00:00 AM 27   Permit Number 772405 5999886.5 2092393.4 37.7253068164695 -122.442572018552 (37.7253068164695, -122.442572018552) 9 7 6 28861 25
144842 101905 8 72 1100 Ocean Ave 6 Front Yard : Yard Tree 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
191552 101904 8 72 1100 Ocean Ave 5 Front Yard : Yard Tree 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
192549 98880 8 41 101 Lansdale Ave 1 Front Yard : Yard Tree 2     11     5994747.9 2097283.1 37.7384384842789 -122.460689725403 (37.7384384842789, -122.460689725403) 9 7 4 59 40
170 108637 8 15 15 TUCKER AVE   Back Yard : Yard Tree 2           6011049.2 2088423.2 37.7150354478954 -122.403704200211 (37.7150354478954, -122.403704200211) 9 7 8 309 39
390 255918 8 15 80 Molimo Dr 1 Back Yard : Yard Tree 2       10x10   5998634.42423 2096706.77911 37.7370788872961 -122.447210599537 (37.7370788872961, -122.447210599537) 9 7 4 59 40
533 257925 8 15 274 Staples Ave   Back Yard : Yard Tree 2       10x10   5998272.17919 2093819.44967 37.7291302611298 -122.448255187535 (37.7291302611298, -122.448255187535) 9 7 4 28861 40
13832 259913 8 15 23 Cresta Vista Dr 1 Back Yard : Yard Tree 2       3x3   5995254 2096176 37.7354277647167 -122.45885975654 (37.7354277647167, -122.45885975654) 9 7 4 59 40
28928 116154 8 100 324 POPE ST 1 Back Yard : Yard Tree 2       3x3   6000502 2087202 37.7110874704678 -122.440072212787 (37.7110874704678, -122.440072212787) 9 7 6 28861 5
39981 256672 8 15 15 Kenwood Way 11 Back Yard : Yard Tree 2       30x30   5994751 2093714 37.7286387886762 -122.4604204683 (37.7286387886762, -122.4604204683) 9 8 4 59 40
60302 187670 8 15 230 Victoria St 1 Back Yard : Yard Tree 2       3x3   5993274 2088748 37.7149182807441 -122.465165952001 (37.7149182807441, -122.465165952001) 9 8 6 64 24
97665 121104 8 15 477 Myra Way 1 Back Yard : Yard Tree 2       3x3   5997298 2097021 37.7378652095891 -122.45185385939 (37.7378652095891, -122.45185385939) 9 7 4 59 40
127263 98715 8 15 26 Vernon St   Back Yard : Yard Tree 2           5992459 2088068 37.713004133171 -122.467933479353 (37.713004133171, -122.467933479353) 9 8 6 64 24
129920 106227 8 56 38 Stanford Heights Ave 1 Back Yard : Yard Tree 2           5997884 2095808.5 37.7345695210024 -122.44974042874 (37.7345695210024, -122.44974042874) 9 7 4 59 40
139843 108680 8 113 240 SANTA ANA AVE 1 Back Yard : Yard Tree 2           5992606.9 2095181.7 37.7325451527527 -122.46793939449 (37.7325451527527, -122.46793939449) 9 8 4 59 40
148738 252848 8 330 99 Reposa Way 1 Back Yard : Yard Tree 2       3x3   5998022 2098104 37.7408803073177 -122.44942865965 (37.7408803073177, -122.44942865965) 9 7 4 59 40
150726 106275 8 56 42 Stanford Heights Ave 1 Back Yard : Yard Tree 2           5997882.5 2095834.4 37.7346405503947 -122.449747480555 (37.7346405503947, -122.449747480555) 9 7 4 59 40
157400 97685 8 41 84 Coventry Ct   Back Yard : Yard Tree 2           5997084 2096485 37.7363812239889 -122.452555087132 (37.7363812239889, -122.452555087132) 9 7 4 59 40
167578 100472 8 15 70 Stanford Heights Ave   Back Yard : Yard Tree 2           5997872.4 2096006.9 37.735113616296 -122.449794826729 (37.735113616296, -122.449794826729) 9 7 4 59 40
176195 102381 8 15 258 Molimo Dr   Back Yard : Yard Tree 2           5997615 2096604 37.7367383790998 -122.450727783905 (37.7367383790998, -122.450727783905) 9 7 4 59 40
176836 102639 8 15 251 Dorado Ter 1 Back Yard : Yard Tree 2           5994312.1 2092840.7 37.7262156610351 -122.461874461465 (37.7262156610351, -122.461874461465) 9 8 4 28861 40
104559 254162 8 15 301X Chester Ave 1 Back Yard : Cutout Tree 2       10x10   5991786 2087190 37.7105544703116 -122.470195673297 (37.7105544703116, -122.470195673297) 9 8 4 64 24
130825 255872 8 17 100 Stonecrest Dr 1 Back Yard : Cutout Tree 2       3x3   5990801 2093784 37.7286029699614 -122.474080817952 (37.7286029699614, -122.474080817952) 9 8 4 64 40
131954 110939 8 15 38 SAINT CHARLES AVE 1 Back Yard : Cutout Tree 2     30 3x3   5992046 2088201 37.7133454608488 -122.46937060641 (37.7133454608488, -122.46937060641) 9 8 6 64 24