sf-trees

Data source: data.sfgov.org

Custom SQL query returning 63 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
5920 139500 2 42 748 CENTRAL AVE 1 1 1 1       Width 0ft   5999620.0523 2111133.4316 37.776747194618395 -122.44483956661199 (37.7767471946184, -122.444839566612)
24187 142264 2 42 575 LINDEN ST 1 1 1 1     10 Width 0ft   6004642.0376 2110688.0426 37.775809585078896 -122.427435282317 (37.7758095850789, -122.427435282317)
24822 250192 2 42 11 Alta St 2 13 1 1     9 Width 0ft   6011786.88966 2119947.0785 37.8016342173021 -122.403370805543 (37.8016342173021, -122.403370805543)
25501 141630 2 42 1801 GROVE ST 12 1 1 1     8 Width 0ft   5999025.3732 2110414.9246 37.774740403045996 -122.446845016858 (37.774740403046, -122.446845016858)
31678 137728 2 42 1989 McAllister St 1 1 1 1     12 Width 0ft   5999638.3271 2111189.9480000003 37.77690341710429 -122.444780412241 (37.7769034171043, -122.444780412241)
33547 137666 2 42 1901 GOLDEN GATE AVE 3 1 1 1     5 Width 0ft   6000398.0082 2111639.7629 37.7781818179135 -122.442184748811 (37.7781818179135, -122.442184748811)
33826 184961 2 42 1990 41st Ave 19 1 1 1     8 Width 0ft   5983548.8239 2101628.2630000003 37.7497184185455 -122.4997311455 (37.7497184185455, -122.4997311455)
35471 140101 2 42 771 Central Ave 2 1 1 1     6 Width 0ft   5999584.517999999 2111094.1746 37.7766373769699 -122.44495966716002 (37.7766373769699, -122.44495966716)
37452 140100 2 42 785 Central Ave 1 1 1 1     4 Width 0ft   5999576.3959 2111131.7395 37.7767400570235 -122.44499046488501 (37.7767400570235, -122.444990464885)
38437 142346 2 42 505 Central Ave 1 1 1 1     7 Width 0ft   5999691.4094 2110243.208 37.7743069396367 -122.44452872557699 (37.7743069396367, -122.444528725577)
41788 138778 2 42 2250 Sutter St 10 1 1 1     1 Width 0ft   6001713.8653 2114306.3395 37.785578464198 -122.437823766308 (37.785578464198, -122.437823766308)
41964 246075 2 42 635 Clayton St 1 1 1 1     12 Width 0ft   5998492.5621 2108432.0423 37.7692654626532 -122.44854527514299 (37.7692654626532, -122.448545275143)
42359 138339 2 42 2250 Sutter St 3 1 1 1     7 Width 0ft   6001909.1348 2114331.7204 37.7856592553419 -122.437150009777 (37.7856592553419, -122.437150009777)
42577 139655 2 42 848 BAKER ST 2 1 1 1     11 Width 0ft   6000491.15 2111934.8144 37.7789972619427 -122.441883720544 (37.7789972619427, -122.441883720544)
45099 184964 2 42 1990 41st Ave 22 1 1 1     8 Width 0ft   5983545.7781 2101731.1432 37.7500007203614 -122.499749280915 (37.7500007203614, -122.499749280915)
45153 140717 2 42 556 SCOTT ST 2 1 1 1     7 Width 0ft   6002162.097 2110427.6982 37.774954171002 -122.43599537996201 (37.774954171002, -122.435995379962)
45939 138342 2 42 2250 Sutter St 6 1 1 1     8 Width 0ft   6001808.8392 2114319.4393 37.7856198329437 -122.437496123305 (37.7856198329437, -122.437496123305)
47761 250191 2 42 11 Alta St 1 13 1 1     11 Width 0ft   6011795.08799 2119945.2148 37.8016295579248 -122.40334230423099 (37.8016295579248, -122.403342304231)
50765 244169 2 42 1752 Page St 1 1 1 1     10 Width 0ft   5998187.9203 2108956.9743 37.7706893684237 -122.449636842472 (37.7706893684237, -122.449636842472)
54226 137665 2 42 1901 GOLDEN GATE AVE 2 1 1 1     7 Width 0ft   6000382.7272 2111637.7254 37.778175352566 -122.44223746490101 (37.778175352566, -122.442237464901)
55440 138357 2 42 2499 Bush St 10 1 1 1     7 Width 0ft   6001830.9567 2114618.7351 37.7864428800724 -122.437441043234 (37.7864428800724, -122.437441043234)
60228 245868 2 42 415 Laguna St 1 1 1 1     6 Width 0ft   6005026.3603 2110433.2652 37.775131757595204 -122.42608767011801 (37.7751317575952, -122.426087670118)
60547 184904 2 42 1990 41st Ave 23 1 1 1     7 Width 0ft   5983548.4855 2101753.1406 37.7500612779998 -122.499741544392 (37.7500612779998, -122.499741544392)
60577 245840 2 42 421 Laguna St 1 1 1 1     5 Width 0ft   6005021.78 2110481.0306 37.775262650872 -122.42610691556601 (37.775262650872, -122.426106915566)
61827 138346 2 42 1770 SCOTT ST 4 1 1 1     8 Width 0ft   6001590.3534 2114514.4235 37.7861427855089 -122.438265993007 (37.7861427855089, -122.438265993007)
61990 140718 2 42 556 SCOTT ST 3 1 1 1     12 Width 0ft   6002160.0013 2110449.3533 37.7750135114472 -122.436004179308 (37.7750135114472, -122.436004179308)
62430 246034 2 42 618 Clayton St 1 1 1 1     4 Width 0ft   5998524.9649 2108501.9958 37.7694593898353 -122.44843823441002 (37.7694593898353, -122.44843823441)
63850 138348 2 42 2499 Bush St 1 1 1 1     6 Width 0ft   6001613.9728 2114589.4995 37.786350268304 -122.43818965646001 (37.786350268304, -122.43818965646)
64130 248395 2 42 1655 Waller St 1 1 1 1     8 Width 0ft   5997659.0251 2108142.2349 37.768422030688896 -122.451407517669 (37.7684220306889, -122.451407517669)
65413 137613 2 42 1502 MCALLISTER ST 1 1 1 1     8 Width 0ft   6001914.7987 2111556.8609 37.778040516588604 -122.436931690487 (37.7780405165886, -122.436931690487)
65658 183506 2 42 2542 27th Ave 2 2 1 1     6 Width 0ft   5988021.6131 2097993.9577 37.7400010259161 -122.483997786352 (37.7400010259161, -122.483997786352)
69574 245838 2 42 423 Laguna St 1 1 1 1     10 Width 0ft   6005012.6195 2110528.7961 37.7753932855436 -122.426142005084 (37.7753932855436, -122.426142005084)
70197 138347 2 42 1770 SCOTT ST 5 1 1 1     11 Width 0ft   6001586.1357 2114554.9139 37.786253721877706 -122.438283486898 (37.7862537218777, -122.438283486898)
70529 138351 2 42 2499 Bush St 4 1 1 1     7 Width 0ft   6001690.7359 2114600.4656 37.786384743909295 -122.437924862001 (37.7863847439093, -122.437924862001)
70721 245867 2 42 419 Laguna St 1 1 1 1     5 Width 0ft   6005023.743 2110457.4751 37.775198084155605 -122.42609844781799 (37.7751980841556, -122.426098447818)
72487 249768 2 42 266 Lombard St 4 7 1 1     12 Width 0ft   6010977.12206 2120702.10235 37.8036620671076 -122.406226211476 (37.8036620671076, -122.406226211476)
73916 200693 2 42 1607 Newcomb Ave 1 1 1 1     11 Width 0ft   6015092.9345 2095762.8694 37.7354137854933 -122.39023969268999 (37.7354137854933, -122.39023969269)
74240 141691 2 42 101 Beaumont Ave 1 1 1 1     9 Width 0ft   5996753.535 2112367.4021 37.7799713474759 -122.45484482437 (37.7799713474759, -122.45484482437)
75193 139501 2 42 750 CENTRAL AVE 1 1 1 1     10 Width 0ft   5999619.0371 2111147.3069 37.7767852347068 -122.444844076108 (37.7767852347068, -122.444844076108)
75611 182146 2 42 1690 21st Ave 2 1 1 1     9 Width 0ft   5989681.6149 2103872.2722 37.756237834999 -122.478688039412 (37.756237834999, -122.478688039412)
132605 142261 2 42 575 LINDEN ST 2 1 1 1     5 Width 0ft   6004683.1776 2110693.6136 37.775827208405104 -122.427293365492 (37.7758272084051, -122.427293365492)
134727 140102 2 42 1720 FULTON ST 1 1 1 1     3 Width 0ft   5999455.5793 2110868.7857 37.7760111570338 -122.445389492297 (37.7760111570338, -122.445389492297)
135843 250193 2 42 11 Alta St 3 13 1 1     35 Width 0ft   6011782.399230001 2119949.71509 37.8016412059365 -122.403386530161 (37.8016412059365, -122.403386530161)
149751 138140 2 42 1942 MCALLISTER ST 1 1 1 1     11 Width 0ft   5999833.7647 2111267.0068 37.7771261520231 -122.444109874692 (37.7771261520231, -122.444109874692)
150574 138352 2 42 2499 Bush St 5 1 1 1     4 Width 0ft   6001715.4366 2114603.3734 37.78639413258121 -122.437839612353 (37.7863941325812, -122.437839612353)
154005 248396 2 42 1655 Waller St 2 1 1 1     7 Width 0ft   5997671.1383 2108143.749 37.768426881635605 -122.45136572862499 (37.7684268816356, -122.451365728625)
156262 140103 2 42 1720 FULTON ST 2 1 1 1     9 Width 0ft   5999438.9967 2110868.4473 37.776009281241 -122.44544683133002 (37.776009281241, -122.44544683133)
157543 139098 2 42 2600 POST ST 2 1 1 1     8 Width 0ft   5999639.9141 2113670.3506 37.7837140544374 -122.44495327295601 (37.7837140544374, -122.444953272956)
157995 140719 2 42 556 SCOTT ST 4 1 1 1     7 Width 0ft   6002157.9056 2110466.8172 37.775061343901896 -122.436012678697 (37.7750613439019, -122.436012678697)
158299 138337 2 42 2250 Sutter St 1 1 1 1     12 Width 0ft   6001955.802999999 2114338.6797 37.7856810164636 -122.436989049911 (37.7856810164636, -122.436989049911)
159913 138338 2 42 2250 Sutter St 2 1 1 1     6 Width 0ft   6001931.2408 2114335.4048 37.7856706283151 -122.437073793387 (37.7856706283151, -122.437073793387)
164961 138533 2 42 2299 SUTTER ST 2 1 1 1     5 Width 0ft   6001645.5525 2114240.3384 37.7853933573613 -122.438055378776 (37.7853933573613, -122.438055378776)
170339 140104 2 42 1750 FULTON ST 1 1 1 1     8 Width 0ft   5999428.844 2110866.7552 37.776004055577204 -122.44548183036301 (37.7760040555772, -122.445481830363)
172105 182147 2 42 1690 21st Ave 3 1 1 1     8 Width 0ft   5989680.1915 2103890.3009 37.756287254354 -122.478694280415 (37.756287254354, -122.478694280415)
173572 245839 2 42 423 Laguna St 2 1 1 1     5 Width 0ft   6005015.8911 2110507.8578 37.775335978986796 -122.4261291969 (37.7753359789868, -122.4261291969)
174353 138350 2 42 2499 Bush St 3 1 1 1     10 Width 0ft   6001659.5245 2114595.4043 37.786369071961104 -122.438032482637 (37.7863690719611, -122.438032482637)
175294 141632 2 42 1801 GROVE ST 14 1 1 1     7 Width 0ft   5999054.1432 2110418.5587 37.7747520248793 -122.446745757486 (37.7747520248793, -122.446745757486)
179698 218406 2 42 225 Castenada Ave 4 2 1 1     6 Width 0ft   5994236.919980001 2100511.7669599997 37.7472741826649 -122.462690582315 (37.7472741826649, -122.462690582315)
180907 137667 2 42 1901 GOLDEN GATE AVE 4 1 1 1     7 Width 0ft   6000415.6663 2111642.14 37.7781893511619 -122.442123833863 (37.7781893511619, -122.442123833863)
184019 245165 2 42 1364 Page St 1 1 1 1     11 Width 0ft   6000037.7937 2109212.4329 37.7714964504984 -122.443256472847 (37.7714964504984, -122.443256472847)
187109 142298 2 42 1501 GROVE ST 3 1 1 1     7 Width 0ft   6000546.8174 2110627.5355 37.775410978082 -122.44159730622299 (37.775410978082, -122.441597306223)
187692 138344 2 42 2250 Sutter St 8 1 1 1     9 Width 0ft   6001758.896000001 2114311.2519 37.785594512870205 -122.43766832543301 (37.7855945128702, -122.437668325433)
188012 138353 2 42 2499 Bush St 6 1 1 1     9 Width 0ft   6001742.4732 2114607.6747 37.786407480206705 -122.43774638091499 (37.7864074802067, -122.437746380915)
Powered by Datasette · Query took 4.943ms · Data source: data.sfgov.org