trees

Custom SQL query returning 50 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
13614 258670 8 15 152 Kensington Way   Front Yard : Yard Tree 2       3x3   5994743 2098651 37.7421941161526 -122.460805774677 (37.7421941161526, -122.460805774677) 1 8 4 59 40
75016 98140 8 41 315 San Marcos Ave   Front Yard : Yard Tree 2           5992920.8 2100212.1 37.7463754865467 -122.467219803339 (37.7463754865467, -122.467219803339) 1 8 4 29491 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
34 262408 8 15 66X Edgehill Way 1 Unaccepted Street : Yard Tree 2       3x3   5994840 2098758 37.7424934921887 -122.46047813267 (37.7424934921887, -122.46047813267) 1 8 4 59 40
3020 260513 8 15 1990 41st Ave 1 Back Yard : Yard Tree 13       10x10   5983703 2101544 37.7494961014415 -122.499191781388 (37.7494961014415, -122.499191781388) 1 8 3 29491 35
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
10450 114373 8 37 805 GONZALEZ DR 1 Front Yard : Yard Tree 2     18     5988302 2089566 37.7168763353695 -122.482410970247 (37.7168763353695, -122.482410970247) 1 8 4 64 14
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
20402 257888 8 28 155X Magellan Ave 1 Front Yard : Yard Tree 3       10x10   5995070 2100842 37.7482288640106 -122.459833790503 (37.7482288640106, -122.459833790503) 1 8 4 29491 40
20664 121198 8 64 2521 18th Ave 1 Sidewalk: Property side : Cutout Tree 2     3 3x3   5990743 2098231 37.740809941753 -122.47460574514 (37.740809941753, -122.47460574514) 1 8 4 29491 40
30075 100070 8 17 331 Serrano Dr 1 Front Yard : Yard Tree 2         Permit Number 777990 5990400 2090718 37.7201612636948 -122.475243338807 (37.7201612636948, -122.475243338807) 1 8 4 64 40
35596 254587 8 155 1270 24th Ave 1 Back Yard : Cutout Tree 2       3x3   5988678 2106679 37.7638860263594 -122.482364481098 (37.7638860263594, -122.482364481098) 1 8 3 56 35
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
46471 253626 8 41 1671 Funston Ave 1 Back Yard : Yard Tree 2       10x10   5992125 2104081 37.7569525124502 -122.470253253306 (37.7569525124502, -122.470253253306) 1 8 4 56 12
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
55834 121404 8 155 1900 08th Ave 1 Back Yard : Yard Tree 2     3 10x10   5993817 2102486 37.7526707300666 -122.464285931649 (37.7526707300666, -122.464285931649) 1 8 4 29491 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
89692 122453 8 15 217 San Marcos Ave 1 Back Yard : Yard Tree 2       10x10   5993325.07095 2100296.14299 37.7466295758311 -122.465827998209 (37.7466295758311, -122.465827998209) 1 8 4 29491 40
96282 117254 8 15 2067 33RD AVE 1 Back Yard : Yard Tree 2       3x3   5985987 2101171 37.7486056682842 -122.491266304796 (37.7486056682842, -122.491266304796) 1 8 3 29491 35
99909 96676 8 68 1701 21st Ave 1 Sidewalk: Curb side : Cutout Tree 2   06/22/2011 12:00:00 AM       5989644.3 2103769.9 37.7559545815884 -122.478809598698 (37.7559545815884, -122.478809598698) 1 8 3 56 35
103546 113379 8 272 140 CASTENADA AVE 1 Front Yard : Yard Tree 2     50     5994437 2101097 37.7488926059174 -122.462041158848 (37.7488926059174, -122.462041158848) 1 8 4 29491 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
105992 258053 8 15 1651 Portola Dr 1 Sidewalk: Property side : Yard Tree 1       Width 5ft   5991822.8552 2096210.84451 37.7353256172728 -122.470724935722 (37.7353256172728, -122.470724935722) 1 8 4 59 40
108384 122480 8 15 596X Buckingham Way 1 Side Yard : Cutout Tree 2       3x3   5990152 2094375 37.7301880902761 -122.476367577616 (37.7301880902761, -122.476367577616) 1 8 4 64 14
112077 253339 8 41 2019X 24th Ave 1 Sidewalk: Property side : Yard Tree 8       3x3   5988853 2101569 37.7498655183494 -122.481384971136 (37.7498655183494, -122.481384971136) 1 8 3 29491 35
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
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
131293 254124 8 15 365 Edgehill Way 1 Back Yard : Cutout Tree 2       3x3   5994964 2098864 37.7427916745102 -122.460057057879 (37.7427916745102, -122.460057057879) 1 8 4 59 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
133884 114949 8 15 1X WOODACRE DR 1 unknown : Yard Tree 1     30 30x100   5991187 2095315 37.7328290635508 -122.472857998502 (37.7328290635508, -122.472857998502) 1 8 4 64 40
134592 102469 8 15 1021 Kirkham St 1 Back Yard : Yard Tree 2           5991773 2105198 37.7599991432047 -122.471551983129 (37.7599991432047, -122.471551983129) 1 8 4 56 12
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
159644 120526 8 15 1439 47th Ave 1 Back Yard : Yard Tree 2     20 3x3   5981489 2105275 37.7596102388302 -122.50712446854 (37.7596102388302, -122.50712446854) 1 8 3 56 35
168913 114365 8 15 2546 28th Ave 1 Back Yard : Yard Tree 2     35     5987735.7 2097954.4 37.7398757613896 -122.484983441996 (37.7398757613896, -122.484983441996) 1 8 3 29491 35
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
177432 102706 8 41 1342 Funston Ave 1 Back Yard : Yard Tree 2           5992135.4 2106294.8 37.7630316255695 -122.470378504645 (37.7630316255695, -122.470378504645) 1 8 11 56 12
177799 103504 8 15 148 Huntington Dr 1 Back Yard : Yard Tree 2           5984515 2095210 37.7321522522788 -122.49591670505 (37.7321522522788, -122.49591670505) 1 8 4 64 35
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
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
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
56515 102470 8 15 1021 Kirkham St 2 Back Yard : Yard Tree 2           5991773 2105198 37.7599991432047 -122.471551983129 (37.7599991432047, -122.471551983129) 1 8 4 56 12
75714 114950 8 15 1X WOODACRE DR 2 unknown : Yard Tree 1       30x100   5991187 2095315 37.7328290635508 -122.472857998502 (37.7328290635508, -122.472857998502) 1 8 4 64 40
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
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
107546 112377 8 127 801 ULLOA ST 3 Sidewalk: Curb side : Cutout Tree 3     36     5993401 2098089 37.7405736985828 -122.465405140197 (37.7405736985828, -122.465405140197) 1 8 4 59 40
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
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
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
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