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)
135252 254189 1 70 187x Stonecrest Dr   Front Yard : Cutout Tree 2       3x3   5990830 2093201 37.7270038779971 -122.473938047356 (37.7270038779971, -122.473938047356) 9 8 4 64 40
179210 112417 4 70 98X BROADMOOR DR 1 Front Yard : Cutout Tree 2     28 3x3   5990934 2093194 37.7269906812088 -122.47357801435 (37.7269906812088, -122.47357801435) 9 8 4 64 40
177 253253 6 70 99X Lopez Ave 4 Front Yard : Yard Tree 2       10x10   5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
1805 203698 1 70 1696 09th Ave 1 Front Yard : Yard Tree 2     25 Width 6ft   5993434.49176 2103973.54477 37.7567330891842 -122.46571676863 (37.7567330891842, -122.46571676863) 1 8 4 56 12
3682 261986 6 70 1500 Bancroft Ave 3 Front Yard : Yard Tree 2           6014696 2091834 37.7246038778524 -122.391337493735 (37.7246038778524, -122.391337493735) 10 3 8 58 1
3798 262575 6 70 141 Topaz Way   Front Yard : Yard Tree 2       3x3   6001722 2097902 37.7405366227001 -122.436621002014 (37.7405366227001, -122.436621002014) 2 7 5 63 7
6421 220173 1 70 1101 San Jose Ave 37 Front Yard : Yard Tree 2     16     6004965.33197 2096549.91203 37.7370078737986 -122.425310617592 (37.7370078737986, -122.425310617592) 2 7 5 28859 2
7786 220170 1 70 1101 San Jose Ave 34 Front Yard : Yard Tree 2     13     6004937.56248 2096542.42817 37.7369857558904 -122.425406096807 (37.7369857558904, -122.425406096807) 2 7 5 28859 2
8060 220192 1 70 1300 San Jose Ave 64 Front Yard : Yard Tree 2     12 Width 5ft   6003556.22665 2095685.51446 37.7345547247094 -122.430120878078 (37.7345547247094, -122.430120878078) 2 7 5 63 7
9517 246826 1 70 400 Franconia St 3 Front Yard : Yard Tree 2     1     6009973.79808 2098728.47143 37.7432714144464 -122.408147628312 (37.7432714144464, -122.408147628312) 10 7 7 28859 2
14836 221387 1 70 701 Church St 38 Front Yard : Yard Tree 2     17 Width 3ft   6004318.36502 2104792.37844 37.7596032026492 -122.428134698373 (37.7596032026492, -122.428134698373) 2 4 5 28862 3
23415 125278 1 70 1200 Greenwich St 4 Front Yard : Yard Tree 2     16     6006716.82854 2119779.13638 37.8008886127761 -122.420903634692 (37.8008886127761, -122.420903634692) 5 1 1 28858 32
25027 188574 1 70 101 Pennsylvania Ave 24 Front Yard : Yard Tree 2     1     6014321.12378 2106534.34369 37.7649471289393 -122.39366181916 (37.7649471289393, -122.39366181916) 14 3 8 310 29
25090 220149 1 70 1201 San Jose Ave 3 Front Yard : Yard Tree 2     10     6004123.90367 2095822.35629 37.734962596934 -122.428167977786 (37.734962596934, -122.428167977786) 2 7 5 28861 2
25108 97979 1 70 325 Bowdoin St 9 Front Yard : Yard Tree 2     17 3x105 Permit Number 767976 6008557.48708 2094193.99719 37.730741330332 -122.412724380735 (37.730741330332, -122.412724380735) 9 3 7 309 28
25538 97980 4 70 325 Bowdoin St 10 Front Yard : Yard Tree 2       3x105 Permit Number 767976 6008582.5 2094142.5 37.7306013339748 -122.412634267782 (37.7306013339748, -122.412634267782) 9 3 7 309 28
25606 220176 1 70 1101 San Jose Ave 41 Front Yard : Yard Tree 2     7     6004978.26443 2096560.74559 37.7370383509436 -122.425266674926 (37.7370383509436, -122.425266674926) 2 7 5 28859 2
26650 220155 1 70 1201 San Jose Ave 10 Front Yard : Yard Tree 2     8     6004171.83717 2095877.84681 37.7351176733377 -122.428006207723 (37.7351176733377, -122.428006207723) 2 7 5 28861 2
28393 175015 1 70 81 Gillette Ave 5 Front Yard : Yard Tree 2     22 Width 8ft   6013189.92411 2087076.36729 37.7114566649583 -122.39621055537 (37.7114566649583, -122.39621055537) 10 3 8 309 1
28632 188571 1 70 101 Pennsylvania Ave 19 Front Yard : Yard Tree 2     1     6014323.12928 2106506.58009 37.764871007621 -122.393652939236 (37.764871007621, -122.393652939236) 14 3 8 310 29
28670 125286 1 70 941 Vallejo St 6 Front Yard : Yard Tree 2     11     6008909.00848 2118677.12072 37.7979860724672 -122.413239767796 (37.7979860724672, -122.413239767796) 3 1 10 308 21
30617 220175 1 70 1101 San Jose Ave 40 Front Yard : Yard Tree 2     17     6004976.12829 2096559.96941 37.7370360990465 -122.425274005312 (37.7370360990465, -122.425274005312) 2 7 5 28859 2
32776 252873 1 70 1501 Broderick St 7 Front Yard : Yard Tree 2       3x3   6000422 2113928 37.7844660975886 -122.442266061376 (37.7844660975886, -122.442266061376) 15 6 11 29490 13
33137 220158 1 70 1201 San Jose Ave 66 Front Yard : Yard Tree 2     9     6004531.65878 2096118.78837 37.7357995950731 -122.426779327416 (37.7357995950731, -122.426779327416) 2 7 5 28861 2
33246 220147 1 70 1201 San Jose Ave 1 Front Yard : Yard Tree 2     23     6004138.65271 2095814.53197 37.7349419476117 -122.428116427727 (37.7349419476117, -122.428116427727) 2 7 5 28861 2
34055 105417 6 70 1450X McAllister St 3 Front Yard : Yard Tree 2           6002220.78829 2111575.67932 37.7781095739995 -122.435874511445 (37.7781095739995, -122.435874511445) 15 5 11 29492 41
35847 249706 1 70 2400 Baker St 38 Front Yard : Yard Tree 2     10     5999689.68932 2117193.09573 37.7933894315405 -122.445034403012 (37.7933894315405, -122.445034403012) 13 9 1 57 27
35884 220200 1 70 1300 San Jose Ave 73 Front Yard : Yard Tree 2     8 Width 5ft   6003513.54179 2095663.72893 37.7344924889333 -122.430266900093 (37.7344924889333, -122.430266900093) 2 7 5 63 7
37172 188573 1 70 101 Pennsylvania Ave 23 Front Yard : Yard Tree 2     2     6014313.95748 2106525.31857 37.7649219497227 -122.393685974041 (37.7649219497227, -122.393685974041) 14 3 8 310 29
39635 175016 1 70 81 Gillette Ave 6 Front Yard : Yard Tree 2     12 Width 8ft   6013191.1859 2087080.9939 37.7114694389303 -122.396206518314 (37.7114694389303, -122.396206518314) 10 3 8 309 1
39911 97975 1 70 325 Bowdoin St 5 Front Yard : Yard Tree 2     10 3x105 Permit Number 767976 6008564.43786 2094166.6254 37.7306665633988 -122.412698416414 (37.7306665633988, -122.412698416414) 9 3 7 309 28
40734 220146 1 70 450 Bosworth St 3 Front Yard : Yard Tree 2     27     6003150.7799 2095211.43274 37.7332300323227 -122.431488808967 (37.7332300323227, -122.431488808967) 2 7 5 28861 25
41779 246827 1 70 400 Franconia St 4 Front Yard : Yard Tree 2     5     6009974.41819 2098730.47702 37.7432769560816 -122.408145625541 (37.7432769560816, -122.408145625541) 10 7 7 28859 2
42888 113973 6 70 11 Hiliritas Ave 1 Front Yard : Yard Tree 2         Permit Number 776381 6001589.6 2096875.9 37.7377116664791 -122.437005345865 (37.7377116664791, -122.437005345865) 2 7 5 63 7
46939 220174 1 70 1101 San Jose Ave 39 Front Yard : Yard Tree 2     8     6004973.16585 2096557.19919 37.7370283252818 -122.425284050737 (37.7370283252818, -122.425284050737) 2 7 5 28859 2
46991 203881 1 70 2 Cranleigh Dr 17 Front Yard : Yard Tree 2     10 Width 0ft   5991366.80632 2095895.31779 37.7344328773807 -122.472278656638 (37.7344328773807, -122.472278656638) 1 8 4 64 40
47940 97971 1 70 325 Bowdoin St 1 Front Yard : Yard Tree 2     4 3x105   6008579.18793 2094106.30305 37.7305017590298 -122.412643160269 (37.7305017590298, -122.412643160269) 9 3 7 309 28
49681 116977 4 70 100x CARGO WAY 117 Front Yard : Yard Tree 8 DPW for City Agency         6019010 2097405 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394) 10 3 8 58 1
51024 105872 6 70 595X San Jose Ave 6 Front Yard : Yard Tree 2           6006124.47156 2100100.14306 37.7468214281195 -122.421555015777 (37.7468214281195, -122.421555015777) 2 7 7 28859 2
51559 249687 1 70 2400 Baker St 19 Front Yard : Yard Tree 2     37     5999715.024 2117348.66269 37.7938180232448 -122.444957931866 (37.7938180232448, -122.444957931866) 13 9 1 57 27
51614 111552 1 70 900x BOSWORTH ST 30 Front Yard : Yard Tree 1     6     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
52773 220201 1 70 1300 San Jose Ave 74 Front Yard : Yard Tree 2     7 Width 5ft   6003510.43036 2095660.01539 37.7344821161581 -122.430277392481 (37.7344821161581, -122.430277392481) 2 7 5 63 7
52837 99659 6 70 1325 Portola Dr 3 Front Yard : Yard Tree 2           5993615.2 2097760.6 37.7396843456359 -122.464640684629 (37.7396843456359, -122.464640684629) 1 8 4 59 40
53791 220198 1 70 1300 San Jose Ave 70 Front Yard : Yard Tree 2     11 Width 5ft   6003524.19467 2095672.022 37.7345158632135 -122.430230661025 (37.7345158632135, -122.430230661025) 2 7 5 63 7
54519 220179 1 70 1101 San Jose Ave 44 Front Yard : Yard Tree 2     22     6004963.53829 2096567.90345 37.7370571728501 -122.42531809906 (37.7370571728501, -122.42531809906) 2 7 5 28859 2
58489 104690 6 70 1435X La Salle Ave 1 Front Yard : Yard Tree 2         Permit Number 770699 6016460.43075 2095036.98644 37.7334964128222 -122.385461132957 (37.7334964128222, -122.385461132957) 10 3 8 58 1
58980 220171 1 70 1101 San Jose Ave 35 Front Yard : Yard Tree 2     23     6004943.37646 2096556.00352 37.7370233592275 -122.425386961047 (37.7370233592275, -122.425386961047) 2 7 5 28859 2
60331 220156 1 70 1201 San Jose Ave 64 Front Yard : Yard Tree 2     4     6004516.6061 2096115.66582 37.7357901701732 -122.426831148142 (37.7357901701732, -122.426831148142) 2 7 5 28861 2
60784 220162 1 70 1101 San Jose Ave 25 Front Yard : Yard Tree 2     33     6004904.25494 2096495.99975 37.7368563920029 -122.42551795269 (37.7368563920029, -122.42551795269) 2 7 5 28859 2
66434 221378 1 70 190 Storrie St 17 Front Yard : Yard Tree 2     8 Width 3ft   6000803.23299 2105309.21717 37.7608228056365 -122.440328815537 (37.7608228056365, -122.440328815537) 15 4 5 28862 3
67776 188594 1 70 1 Jack Balestreri Way 2 Front Yard : Yard Tree 2     16     6012410.71719 2104764.5597 37.7599813531633 -122.400145172978 (37.7599813531633, -122.400145172978) 10 3 8 28856 29
67882 220157 1 70 1201 San Jose Ave 65 Front Yard : Yard Tree 2     3     6004526.08475 2096117.80265 37.7357965733541 -122.426798528853 (37.7357965733541, -122.426798528853) 2 7 5 28861 2
68330 220150 1 70 1001 San Jose Ave 5 Front Yard : Yard Tree 2     12     6005133.60427 2096768.51614 37.7376176168434 -122.424744371178 (37.7376176168434, -122.424744371178) 2 7 5 28859 2
71099 203882 1 70 2 Cranleigh Dr 16 Front Yard : Yard Tree 2     10 Width 0ft   5991371.09776 2095893.61129 37.7344284401265 -122.47226369551 (37.7344284401265, -122.47226369551) 1 8 4 64 40
71614 221388 1 70 671 Church St 57 Front Yard : Yard Tree 2     17 Width 3ft   6004298.75223 2105308.17182 37.7610183389455 -122.428239289531 (37.7610183389455, -122.428239289531) 2 4 5 28862 3
71845 114379 6 70 443X ARBALLO DR 1 Front Yard : Yard Tree 2     36     5988110 2090275 37.7188118998372 -122.483126550771 (37.7188118998372, -122.483126550771) 1 8 4 64 14
72442 203880 1 70 2 Cranleigh Dr 18 Front Yard : Yard Tree 2     3 Width 0ft   5991364.83676 2095904.51613 37.7344580197106 -122.472286136294 (37.7344580197106, -122.472286136294) 1 8 4 64 40
72786 220144 1 70 450 Bosworth St 1 Front Yard : Yard Tree 2     20     6003159.40524 2095238.92343 37.7333060043723 -122.43146095066 (37.7333060043723, -122.43146095066) 2 7 5 28861 25
76427 188664 1 70 501 Amador St 11 Front Yard : Yard Tree 2     10 Width 1ft   6017799.22634 2099547.38372 37.745955042685 -122.381145981202 (37.745955042685, -122.381145981202) 10 3 8 58 1
81179 175042 1 70 98 San Diego Ave 1 Front Yard : Yard Tree 2     33     5992757.09235 2086323.81583 37.7082322293939 -122.466776470378 (37.7082322293939, -122.466776470378) 9 8 6 28588 25
81570 220168 1 70 1101 San Jose Ave 32 Front Yard : Yard Tree 2     9     6004945.76603 2096533.5746 37.7369619094711 -122.425377103585 (37.7369619094711, -122.425377103585) 2 7 5 28859 2
83981 220193 1 70 1300 San Jose Ave 65 Front Yard : Yard Tree 2     9 Width 5ft   6003549.85445 2095682.63787 37.7345464653385 -122.430142703749 (37.7345464653385, -122.430142703749) 2 7 5 63 7
85020 217845 1 70 2 Cranleigh Dr 35 Front Yard : Yard Tree 2     24     5991433.42379 2095847.21705 37.7343046601167 -122.4720448356 (37.7343046601167, -122.4720448356) 1 8 4 64 40
86411 249836 1 70 333 Greenwich St 4 Front Yard : Yard Tree 2     3 Width 0ft   6011225.58487 2120372.97732 37.8027722652867 -122.405343196852 (37.8027722652867, -122.405343196852) 3 1 10 308 23
87787 221368 1 70 755 Sanchez St 1 Front Yard : Yard Tree 2     15 Width 3ft   6003710.38169 2103854.76962 37.7569943341355 -122.43017051797 (37.7569943341355, -122.43017051797) 2 4 5 28862 3
90893 249812 1 70 260 Chestnut St 2 Front Yard : Yard Tree 2     14 Width 0ft   6010650.19801 2121033.73963 37.8045543690542 -122.407380948177 (37.8045543690542, -122.407380948177) 3 1 10 308 23
91715 220278 1 70 3925 21st St 2 Front Yard : Yard Tree 2     5     6002292.19971 2103528.34865 37.7560176344239 -122.435051775442 (37.7560176344239, -122.435051775442) 2 4 5 28862 22
91798 173615 6 70 1200X JUNIPERO SERRA BLVD 14 Front Yard : Yard Tree 2   01/20/2017 12:00:00 AM 3     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
93424 220182 1 70 1101 San Jose Ave 70 Front Yard : Yard Tree 2     7     6004985.47233 2096611.09675 37.7371770110996 -122.425245335799 (37.7371770110996, -122.425245335799) 2 7 5 28859 2
94888 220143 1 70 2300 22nd St 5 Front Yard : Yard Tree 2     5     6011248.89515 2103712.94956 37.7570290164987 -122.404089366557 (37.7570290164987, -122.404089366557) 10 4 8 28859 19
96982 220196 1 70 1300 San Jose Ave 68 Front Yard : Yard Tree 2     12 Width 5ft   6003535.06176 2095676.55127 37.7345289150748 -122.430193412914 (37.7345289150748, -122.430193412914) 2 7 5 63 7
97238 175009 1 70 265 Hester Ave 1 Front Yard : Yard Tree 2     25     6012301.72001 2087735.75637 37.7132177542762 -122.399326699068 (37.7132177542762, -122.399326699068) 10 3 8 309 1
97511 203879 1 70 2 Cranleigh Dr 19 Front Yard : Yard Tree 2     6 Width 0ft   5991366.58351 2095910.40405 37.7344742875433 -122.472280526329 (37.7344742875433, -122.472280526329) 1 8 4 64 40
101254 175012 1 70 81 Gillette Ave 2 Front Yard : Yard Tree 2     4 Width 8ft   6013182.79855 2087056.15726 37.7114007756959 -122.396233767795 (37.7114007756959, -122.396233767795) 10 3 8 309 1
101335 220137 1 70 2501 25th St 5 Front Yard : Yard Tree 2     17     6011439.73612 2101810.34595 37.7518155467598 -122.403295523263 (37.7518155467598, -122.403295523263) 10 4 8 28859 19
102160 117527 4 70 1099x WALLER ST 1 Front Yard : Yard Tree 2           6000071 2108311 37.769023235971 -122.44307686155 (37.769023235971, -122.44307686155) 15 5 5 29492 9
102398 105415 6 70 1450X McAllister St 1 Front Yard : Yard Tree 2           6002220.78829 2111575.67932 37.7781095739995 -122.435874511445 (37.7781095739995, -122.435874511445) 15 5 11 29492 41
102741 98542 4 70 555 Teresita Blvd 1 Front Yard : Yard Tree 2           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448) 9 7 4 59 40
102806 220188 1 70 1101 San Jose Ave 76 Front Yard : Yard Tree 2     6     6004898.43848 2096540.40011 37.736977976744 -122.425541221768 (37.736977976744, -122.425541221768) 2 7 5 28859 2
106101 107308 4 70 190 EUCALYPTUS DR 3 Front Yard : Yard Tree 2     14     5990695.4 2094728.8 37.7311910349726 -122.474514801842 (37.7311910349726, -122.474514801842) 1 8 4 64 40
107627 220184 1 70 1101 San Jose Ave 72 Front Yard : Yard Tree 2     14     6004926.8696 2096549.97699 37.7370058791054 -122.425443603957 (37.7370058791054, -122.425443603957) 2 7 5 28859 2
107652 220177 1 70 1101 San Jose Ave 42 Front Yard : Yard Tree 2     31     6004978.16757 2096563.63573 37.7370462811452 -122.425267215414 (37.7370462811452, -122.425267215414) 2 7 5 28859 2
107957 94851 6 70 1107 Bowdoin St 2 Front Yard : Yard Tree 2   11/17/2010 12:00:00 AM 12   Permit Number 774691 6009593 2091048 37.7221611506882 -122.408922553301 (37.7221611506882, -122.408922553301) 10 3 7 309 28
108941 188566 1 70 901 Iowa St 1 Front Yard : Yard Tree 2     15     6014791.61868 2102890.82424 37.7549689439879 -122.391779701799 (37.7549689439879, -122.391779701799) 10 3 8 28856 29
113928 220167 1 70 1101 San Jose Ave 31 Front Yard : Yard Tree 2     13     6004945.26232 2096528.1578 37.7369470076993 -122.425378459774 (37.7369470076993, -122.425378459774) 2 7 5 28859 2
114090 220194 1 70 1300 San Jose Ave 66 Front Yard : Yard Tree 2     13 Width 5ft   6003545.8031 2095679.42322 37.7345374091774 -122.430156481356 (37.7345374091774, -122.430156481356) 2 7 5 63 7
114223 105416 6 70 1450X McAllister St 2 Front Yard : Yard Tree 2           6002220.78829 2111575.67932 37.7781095739995 -122.435874511445 (37.7781095739995, -122.435874511445) 15 5 11 29492 41
115084 104751 6 70 13X JUAN BAUTISTA CIR 2 Front Yard : Yard Tree 2           5989494 2090180 37.7186314952818 -122.47833572412 (37.7186314952818, -122.47833572412) 1 8 4 64 14
116008 188572 1 70 101 Pennsylvania Ave 22 Front Yard : Yard Tree 2     1     6014321.61552 2106524.04213 37.764918870439 -122.393659397268 (37.764918870439, -122.393659397268) 14 3 8 310 29
116509 98545 6 70 555@Rio Teresita Blvd 1 Front Yard : Yard Tree 2           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448) 9 7 4 59 40
119294 203878 1 70 2 Cranleigh Dr 20 Front Yard : Yard Tree 2     8 Width 0ft   5991362.95772 2095918.02159 37.7344949935417 -122.472293616873 (37.7344949935417, -122.472293616873) 1 8 4 64 40
121122 220172 1 70 1101 San Jose Ave 36 Front Yard : Yard Tree 2     13     6004959.70888 2096542.80768 37.7369880491675 -122.425329553743 (37.7369880491675, -122.425329553743) 2 7 5 28859 2
121173 125287 1 70 945 Green St 1 Front Yard : Yard Tree 2     18     6008576.87154 2118976.92053 37.7987905960632 -122.414410284916 (37.7987905960632, -122.414410284916) 5 1 10 308 21
123051 97973 1 70 325 Bowdoin St 3 Front Yard : Yard Tree 2     21 3x105 Permit Number 767976 6008571.29393 2094144.04925 37.7306049589414 -122.412673118464 (37.7306049589414, -122.412673118464) 9 3 7 309 28
124179 221369 1 70 755 Sanchez St 2 Front Yard : Yard Tree 2     19 Width 3ft   6003690.30976 2103870.989 37.7570377318327 -122.430241091376 (37.7570377318327, -122.430241091376) 2 4 5 28862 3
124470 105858 6 70 1580 Valencia St 18 Front Yard : Yard Tree 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
126565 220161 1 70 1101 San Jose Ave 23 Front Yard : Yard Tree 2     23     6004865.4895 2096506.15272 37.7368820793529 -122.42565270441 (37.7368820793529, -122.42565270441) 2 7 5 28859 2
127471 220164 1 70 1101 San Jose Ave 28 Front Yard : Yard Tree 2     23     6004931.31387 2096515.53098 37.7369115492209 -122.425425787491 (37.7369115492209, -122.425425787491) 2 7 5 28859 2
128003 249705 1 70 2400 Baker St 37 Front Yard : Yard Tree 2     23     5999691.23036 2117200.88619 37.7934109100399 -122.445029631231 (37.7934109100399, -122.445029631231) 13 9 1 57 27
128560 250218 1 70 310 Filbert St 1 Front Yard : Yard Tree 2     12 Width 0ft   6011294.98745 2120066.49067 37.8019346079448 -122.40508143388 (37.8019346079448, -122.40508143388) 3 1 10 308 23
129614 247936 1 70 1149 Esmeralda Ave 1 Front Yard : Yard Tree 2     11     6010249.43041 2098747.94631 37.7433403177918 -122.407195931541 (37.7433403177918, -122.407195931541) 10 7 7 28859 2