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)
47 264965 4 10 951 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5994993 2090257 37.7191606150529 -122.45933361899 (37.7191606150529, -122.45933361899) 9 8 6 28861 24
52 264970 4 1 1026 Ingerson Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6014048 2089990 37.7195046364539 -122.393448574201 (37.7195046364539, -122.393448574201) 10 3 8 58 1
53 264969 4 30 1099X Hollister Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF     15x15   6014337 2089983 37.719501468928 -122.392449109694 (37.719501468928, -122.392449109694) 10 3 8 58 1
65 264979 4 35 2450 California St 1 Front Yard : Yard Tree 3           6002592 2115500 37.7889058459562 -122.434871073784 (37.7889058459562, -122.434871073784) 13 9 1 29490 27
116 113159 4 52 555 GROVE ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6005146 2111243 37.777361853017 -122.425731455878 (37.777361853017, -122.425731455878) 7 9 11 28852 10
117 108152 4 53 2232 Webster St 4 Sidewalk: Curb side : Cutout Tree 2           6003295.44003 2116396.66877 37.7914077834913 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
128 110722 4 60 1898X 10th Ave 3 Sidewalk: Curb side : Cutout Tree 2           5993137.43282 2102888.05903 37.753735486992 -122.466665198088 (37.753735486992, -122.466665198088) 1 8 4 56 12
131 109387 4 62 300X BAKER ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6000704 2110147 37.7741005029649 -122.441019094263 (37.7741005029649, -122.441019094263) 15 5 11 29492 16
144 108797 4 45 501-599 University St 4 Sidewalk: Curb side : Cutout Tree 2           6008503.45306 2091469.83252 37.7232583218261 -122.412718672961 (37.7232583218261, -122.412718672961) 9 3 7 309 18
148 108238 4 17 764x JUNIPERO SERRA BLVD 1 Median : Yard Tree 2           5991289.6 2092496.8 37.7250969308873 -122.472297921456 (37.7250969308873, -122.472297921456) 9 8 4 64 40
157 114186 4 66 2200 HAYES ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5997096 2109871 37.7731365175856 -122.453479795748 (37.7731365175856, -122.453479795748) 15 5 2 29492 16
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
162 105806 4 17 1248X ANZA ST   Sidewalk: Curb side : Cutout Tree 2       6x3   5994834 2112130 37.7792092085373 -122.461468091676 (37.7792092085373, -122.461468091676) 11 6 2 54 11
164 116129 4 17 1601X Armstrong Ave 1 Sidewalk: Curb side : Cutout Tree 5           6014258.08027 2092570.23406 37.7266011147526 -122.392902822978 (37.7266011147526, -122.392902822978) 10 3 8 58 1
188 112351 4 67 150 WEST PORTAL AVE 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5992711 2097652 37.7393339885882 -122.467759098278 (37.7393339885882, -122.467759098278) 1 8 4 59 40
194 112359 4 17 1129 DOUGLASS ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6001379 2100423 37.7474391957634 -122.437987492815 (37.7474391957634, -122.437987492815) 2 4 5 63 22
196 116631 4 9 5732X GEARY BLVD 12 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
197 104920 4 72 750 Gonzalez Dr 1 Median : Yard Tree 2           5990385 2090588 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222) 1 8 4 64 14
208 107457 4 68 2682 16TH AVE 1 Sidewalk: Curb side : Cutout Tree 2           5991487.4 2097177.7 37.7379609526954 -122.471955163509 (37.7379609526954, -122.471955163509) 1 8 4 29491 40
217 105438 4 45 1116 Castro St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6002483 2102334 37.7527490702591 -122.434306541099 (37.7527490702591, -122.434306541099) 2 4 5 28862 22
228 256437 4 15 3001 Sunset Blvd 25 Median : Yard Tree 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
229 121402 4 45 346X Duncan St 1 Back Yard : Yard Tree 2       3x3   6004011 2099874 37.7460810947058 -122.428847079389 (37.7460810947058, -122.428847079389) 2 7 5 63 22
231 116978 4 76 111 BAY ST 4 Front Yard : Yard Tree 2           6010550 2121704 37.8063891294227 -122.407774985143 (37.8063891294227, -122.407774985143) 3 1 10 308 23
233 100684 4 17 400 California St 3 Sidewalk: Curb side : Pot Tree 2           6012367 2116823 37.7930886299645 -122.401143699021 (37.7930886299645, -122.401143699021) 4 1 10 28854 6
261 119280 4 53 95 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5995293 2090512 37.7198780283713 -122.458315087488 (37.7198780283713, -122.458315087488) 9 8 6 28861 24
277 110381 4 62 2235 PALOU AVE 1 Sidewalk: Curb side : Cutout Tree 2       27x18   6011689 2097713 37.740579036374 -122.402145495204 (37.740579036374, -122.402145495204) 10 3 8 58 1
299 116945 4 45 3676 23RD ST 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6005238 2102584 37.7535915013127 -122.424797029407 (37.7535915013127, -122.424797029407) 2 4 5 28859 19
301 108803 4 45 401-499 University St 2 Sidewalk: Curb side : Cutout Tree 2           6008323.15237 2092121.01007 37.7250361958168 -122.413387969207 (37.7250361958168, -122.413387969207) 9 3 7 309 28
307 99748 4 17 4224 26th St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6002441 2100645 37.7481090922721 -122.434331041256 (37.7481090922721, -122.434331041256) 2 4 5 28862 22
315 106681 4 88 272 COLLINGWOOD ST 1 Sidewalk: Curb side : Cutout Tree 2           6002031.2 2104270.9 37.7580416780136 -122.436007529668 (37.7580416780136, -122.436007529668) 2 4 5 28862 3
323 106136 4 17 200X RIDGEWOOD AVE 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5996801 2094865 37.7319168756422 -122.453416604011 (37.7319168756422, -122.453416604011) 9 7 4 59 40
329 101063 4 17 710 Diamond St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6001857 2102025 37.7518650783703 -122.436449244442 (37.7518650783703, -122.436449244442) 2 4 5 28862 22
350 119661 4 93 699x Missouri St 2 Sidewalk: Property side : Yard Tree 2           6013712 2104098 37.7582235960409 -122.395597929962 (37.7582235960409, -122.395597929962) 10 3 8 28856 29
359 113255 4 17 178 Edgewood Ave 2 Sidewalk: Curb side : Cutout Tree 2           5996632.6 2106029.8 37.7625629978497 -122.454805165139 (37.7625629978497, -122.454805165139) 15 5 11 29492 12
361 107141 4 17 3498 16TH ST   Sidewalk: Curb side : Cutout Tree 2           6003565.7 2106565.7 37.764429704069 -122.430864344516 (37.764429704069, -122.430864344516) 15 4 5 28862 3
380 116339 4 45 1400X Potrero Ave 19 Sidewalk: Curb side : Cutout Tree 5           6010648.28497 2101378.43149 37.7505853701643 -122.406002059271 (37.7505853701643, -122.406002059271) 10 4 8 28859 19
392 108811 4 45 301-399 University St 5 Sidewalk: Curb side : Cutout Tree 2           6008160.40727 2092653.74948 37.7264898456848 -122.413988233103 (37.7264898456848, -122.413988233103) 9 3 7 309 28
403 108117 4 62 148 28TH AVE 2 Sidewalk: Curb side : Cutout Tree 2           5987142.8 2114987.8 37.7866102289445 -122.488284841308 (37.7866102289445, -122.488284841308) 11 6 1 55 33
405 113785 4 101 1164 SHOTWELL ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6007978 2101134 37.7497645063146 -122.415218844485 (37.7497645063146, -122.415218844485) 2 4 7 28859 19
408 109629 4 16 200X GELLERT DR 30 Median : Cutout Tree 1       30x200   5985380 2094516.3 37.730298158605 -122.492875173009 (37.730298158605, -122.492875173009) 1 8 4 64 35
412 121036 4 36 1830 Polk St 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6006566 2117108 37.7935458417616 -122.421235781398 (37.7935458417616, -122.421235781398) 13 9 10 28858 32
416 116621 4 9 5732X GEARY BLVD 2 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
427 114621 4 45 2400X Post St 6 Sidewalk: Curb side : Cutout Tree 2           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976) 15 6 11 29490 13
443 107383 4 97 73 HILL ST 1 Sidewalk: Curb side : Cutout Tree 2       12x6   6005896.4 2103362 37.7557648742481 -122.422575414787 (37.7557648742481, -122.422575414787) 2 4 5 28859 19
445 110235 4 52 2346x CASTRO ST 1 Median : Cutout Tree 2       3x3   6002664.5 2098664.4 37.7426835115852 -122.433416673574 (37.7426835115852, -122.433416673574) 2 7 5 63 7
447 114683 4 101 235 GEARY ST 3 Sidewalk: Curb side : Cutout Tree 2       4x4   6010571 2114715 37.7872002104764 -122.407209329428 (37.7872002104764, -122.407209329428) 5 10 10 28852 6
451 114938 4 15 4400x OCEAN AVE 14 Front Yard : Cutout Tree 2       3x3   5985931 2095134 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
463 116745 4 62 2998x SLOAT BLVD 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5981657 2096559 37.7356884360348 -122.505897251941 (37.7356884360348, -122.505897251941) 1 8 3 29491 35
465 105354 4 17 3294 26th St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6007856.1 2100992.4 37.7493688530402 -122.415630356523 (37.7493688530402, -122.415630356523) 2 4 7 28859 19
466 116275 4 45 700X Greenwich St 2 Sidewalk: Curb side : Cutout Tree 5           6009521.9 2120182.3 37.8021533125646 -122.411225360908 (37.8021533125646, -122.411225360908) 3 1 10 308 23
468 121614 4 45 800X Alvarado St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6001168 2102650 37.7535420028484 -122.438876681597 (37.7535420028484, -122.438876681597) 2 4 5 28862 22
476 102238 4 76 1104 York St 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6009987 2102770 37.7543693005663 -122.408386989199 (37.7543693005663, -122.408386989199) 2 4 7 28859 19
501 108350 4 113 1501x RIVERA ST 6 Sidewalk: Property side : Yard Tree 2       3x3   5988383 2100343 37.7464719103157 -122.482920391178 (37.7464719103157, -122.482920391178) 1 8 3 29491 35
506 264804 4 11 600X Visitacion Ave 8 Sidewalk: Curb side : Cutout Tree 2 FUF     3x3   6010564 2086911 37.7108561363482 -122.405274840324 (37.7108561363482, -122.405274840324) 9 7 8 309 39
508 113374 4 27 88 HOWARD ST 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6014757 2116474 37.7922633974731 -122.39284966575 (37.7922633974731, -122.39284966575) 12 2 9 28855 6
515 262251 4 15 4210 Ocean Ave 4 Sidewalk: Property side : Yard Tree 2       3x3   5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
569 112652 4 19 3100X 26TH ST 6 Sidewalk: Curb side : Cutout Tree 5       3x3   6008747 2100981 37.749387590387 -122.41254878695 (37.749387590387, -122.41254878695) 2 4 7 28859 19
621 104871 4 124 50-52 Ord St 1 Sidewalk: Curb side : Cutout Tree 2       5x4 Permit Number 770461 6000747.1 2106070.8 37.7629107285672 -122.440577579902 (37.7629107285672, -122.440577579902) 15 5 5 28862 3
653 262559 4 72 1801 03rd St 9 Sidewalk: Curb side : Cutout Tree 2       3x3   6015928 2106803 37.7657739601897 -122.388122739596 (37.7657739601897, -122.388122739596) 14 3 9 310 29
694 114020 4 130 1 HANGAH ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6010635 2117072 37.7936755489769 -122.407154109442 (37.7936755489769, -122.407154109442) 3 1 10 28857 4
731 262111 4 36 2021 16th Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5991247 2101647 37.7502185858925 -122.473112177678 (37.7502185858925, -122.473112177678) 1 8 4 29491 12
770 111807 4 53 50X COLUMBIA SQUARE ST 4 Sidewalk: Curb side : Cutout Tree 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
787 110793 4 27 900 CALIFORNIA ST 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6009776 2116634 37.7924247975925 -122.410095399183 (37.7924247975925, -122.410095399183) 5 1 10 28857 21
829 262514 4 16 2230 Jerrold Ave 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6012281 2099339 37.74507671213 -122.400212745638 (37.74507671213, -122.400212745638) 10 3 8 58 1
838 264883 4 41 1624 48th Ave 1 Sidewalk: Property side : Cutout Tree 2       3x3   5981321 2103997 37.7560913197894 -122.50761065519 (37.7560913197894, -122.50761065519) 1 8 3 56 35
910 259043 4 72 3639 Taraval St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5981868 2098709 37.7416041617746 -122.505327058934 (37.7416041617746, -122.505327058934) 1 8 3 29491 35
932 111099 4 15 480X LAKESHORE DR 20 Median : Cutout Tree 1       30x200   5984942 2095282 37.7323749444343 -122.494445798495 (37.7323749444343, -122.494445798495) 1 8 4 64 35
1070 261149 4 65 322x Santiago St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   5991839 2099782 37.7451320352893 -122.470929181064 (37.7451320352893, -122.470929181064) 1 8 4 29491 40
1093 262511 4 16 2230 Jerrold Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6012281 2099339 37.74507671213 -122.400212745638 (37.74507671213, -122.400212745638) 10 3 8 58 1
1105 106501 4 17 1266 09TH AVE   Sidewalk: Curb side : Cutout Tree 2       3x6   5993358 2106830.8 37.764573953722 -122.46618893715 (37.764573953722, -122.46618893715) 11 8 11 56 12
1127 263624 4 41 980 Green St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6008397 2119007 37.7988630807128 -122.415034830901 (37.7988630807128, -122.415034830901) 5 1 10 308 32
1134 262481 4 27 2001 Market St 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6004735 2108212 37.769016230753 -122.426937316023 (37.769016230753, -122.426937316023) 8 4 5 28862 3
1152 259051 4 14 25 Baden St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6000711 2094308 37.7306108324003 -122.439859019702 (37.7306108324003, -122.439859019702) 9 7 4 63 40
1199 116255 4 177 155 LAGUNA ST 3 Sidewalk: Curb side : Cutout Tree 2       7x6   6005176 2109399 37.7723003725615 -122.425496410637 (37.7723003725615, -122.425496410637) 7 9 5 28852 10
1229 264907 4 1 259 Clara St 5 Sidewalk: Curb side : Cutout Tree 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
1232 264776 4 76 90x Guy Pl 10 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
1361 105851 4 17 2590 16TH AVE   Sidewalk: Curb side : Cutout Tree 2       3x3   5991465.4 2097806.4 37.7396859298071 -122.472077039908 (37.7396859298071, -122.472077039908) 1 8 4 29491 40
1376 263620 4 59 900 Beach St 3 Side Yard : Yard Tree 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
1385 101200 4 36 502 Irving St 2 Sidewalk: Curb side : Cutout Tree 2           5994231.2 2106687.3 37.7642302811549 -122.463158383346 (37.7642302811549, -122.463158383346) 11 5 11 56 12
1436 256792 4 36 120 Cedar St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6006815 2114489 37.7863687502832 -122.420188259313 (37.7863687502832, -122.420188259313) 13 9 10 28858 36
1442 103437 4 187 50X Bluxome St 14 Sidewalk: Property side : Cutout Tree 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
1477 112866 4 83 750 VICENTE ST 3 Sidewalk: Curb side : Cutout Tree 2       3x3   5990595 2097751 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927) 1 8 4 29491 40
1523 260685 4 15 198X Miraloma Dr 2 Median : Yard Tree 2       10x10   5994595 2096392 37.7359829456919 -122.461153801837 (37.7359829456919, -122.461153801837) 9 8 4 59 40
1574 122761 4 16 86X Park Hill Ave 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6001171 2107689 37.7673780360046 -122.439227450619 (37.7673780360046, -122.439227450619) 15 5 5 29492 3
1588 260075 4 63 171X Gellert Dr 1 Median : Yard Tree 2       3x3   5985371 2094678 37.7307416178434 -122.492918192866 (37.7307416178434, -122.492918192866) 1 8 4 64 35
1730 121323 4 17 3699X Laguna St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6003556 2121083 37.8042900105203 -122.431934584375 (37.8042900105203, -122.431934584375) 13 9 1 28858 17
1769 251583 4 14 75 Rice St 1 Sidewalk: Curb side : Cutout Tree 2   09/30/1995 12:00:00 AM   3x3   5995352 2086409 37.7086155444167 -122.457814401925 (37.7086155444167, -122.457814401925) 9 7 6 28861 25
1778 262558 4 72 1801 03rd St 8 Sidewalk: Curb side : Cutout Tree 2       3x3   6015928 2106803 37.7657739601897 -122.388122739596 (37.7657739601897, -122.388122739596) 14 3 9 310 29
1841 113206 4 65 50x DASHIELL HAMMETT ST 2 Sidewalk: Curb side : Cutout Tree 2       2x2   6010410 2116139 37.7911011617465 -122.407866810246 (37.7911011617465, -122.407866810246) 5 1 10 28857 21
1914 116946 4 45 3676 23RD ST 6 Sidewalk: Curb side : Cutout Tree 2       3x3   6005238 2102584 37.7535915013127 -122.424797029407 (37.7535915013127, -122.424797029407) 2 4 5 28859 19
1918 262485 4 22 500X Delta St 1 Sidewalk: Curb side : Cutout Tree 2 FUF     3x3   6009406 2087980 37.7137265813857 -122.409352565386 (37.7137265813857, -122.409352565386) 9 7 8 309 39
1922 260512 4 7 180 Stratford Dr 1 Sidewalk: Property side : Cutout Tree 2       3x3   5990850 2091280 37.7217304489912 -122.473728831815 (37.7217304489912, -122.473728831815) 9 8 4 64 40
1942 113791 4 101 1152 SHOTWELL ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6008028 2101194 37.7499320627009 -122.415050188245 (37.7499320627009, -122.415050188245) 2 4 7 28859 19
1943 262553 4 72 1801 03rd St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6015928 2106803 37.7657739601897 -122.388122739596 (37.7657739601897, -122.388122739596) 14 3 9 310 29
1948 113530 4 209 2598x 30TH AVE 3 Front Yard : Yard Tree 2       3x3   5987135 2097625 37.7389363086492 -122.487036198648 (37.7389363086492, -122.487036198648) 1 8 3 29491 35
2023 264805 4 11 600X Visitacion Ave 9 Sidewalk: Curb side : Cutout Tree 2 FUF     3x3   6010564 2086911 37.7108561363482 -122.405274840324 (37.7108561363482, -122.405274840324) 9 7 8 309 39
2062 112894 4 36 1x WEBSTER ST 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6004219 2108568 37.7699645303419 -122.428747509741 (37.7699645303419, -122.428747509741) 7 9 5 28862 10
2069 116350 4 212 4051X 24TH ST 4 Sidewalk: Curb side : Cutout Tree 3       3x3   6002850 2101803 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035) 2 4 5 28862 22
2072 259693 4 58 30 Lafayette St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6007347 2109367 37.7723349336637 -122.417984438142 (37.7723349336637, -122.417984438142) 8 2 9 28853 19
2094 262557 4 72 1801 03rd St 7 Sidewalk: Curb side : Cutout Tree 2       3x3   6015928 2106803 37.7657739601897 -122.388122739596 (37.7657739601897, -122.388122739596) 14 3 9 310 29
2101 117036 4 70 2220x SUTTER ST 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6001781 2114465 37.7860179225956 -122.437602866759 (37.7860179225956, -122.437602866759) 13 6 1 29490 27