sf-trees

Data source: data.sfgov.org

Custom SQL query returning 21 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
28648 213960 2 82 360 Faxon Ave 9 1 1 1     13 Width 3ft   5994774.81066 2091163.6355700002 37.7216374725616 -122.460153459937 (37.7216374725616, -122.460153459937)
36604 213973 2 82 1061 Capitol Ave 6 1 1 1     13 Width 3ft   5995027.24606 2091045.4090900002 37.721327367434604 -122.459272306869 (37.7213273674346, -122.459272306869)
75783 213912 2 82 1235 03rd Ave 1 1 1 1     13 Width 3ft   5995137.8838599995 2107141.32964 37.7655291179984 -122.460055338482 (37.7655291179984, -122.460055338482)
158714 35136 1 82 714 Naples St 1 1 1 1 1 01/28/1998 12:00:00 AM 13   Permit Number 38666 6002360.3768 2089504.48193 37.7175152006551 -122.43381368236 (37.7175152006551, -122.43381368236)
93193 69368 1 82 3636 Webster St 1 1 1 1 1 04/18/1994 12:00:00 AM 13   Permit Number 33462 6002615.01621 2121133.0987299997 37.8043741790738 -122.43519451581999 (37.8043741790738, -122.43519451582)
8758 7287 3 82 1850 Fillmore St 1 1 1 2     13 3X3   6003043.7765 2114538.1757 37.786290560678204 -122.433239236497 (37.7862905606782, -122.433239236497)
74006 179305 2 82 226 Edinburgh St 1 1 1 1     13 Width 3ft   6003843.99427 2092374.03152 37.7254784293655 -122.42888996161899 (37.7254784293655, -122.428889961619)
169247 239359 2 82 1301 Sanchez St 1 1 1 1     13 Width 2ft   6003915.03036 2100651.96891 37.7482117843565 -122.42923439386699 (37.7482117843565, -122.429234393867)
180069 136226 2 82 1570 Chestnut St 1 1 1 1     13 Width 3ft   6004327.39771 2120155.21272 37.8017862476969 -122.429198904827 (37.8017862476969, -122.429198904827)
25779 32030 1 82 3321 16th St 1 1 1 1   07/24/1995 12:00:00 AM 13   Permit Number 35417 6004551.31558 2106568.33958 37.764492746462395 -122.42745555912701 (37.7644927464624, -122.427455559127)
175148 136110 2 82 1725 Pacific Ave 3 1 1 1     13 Width 4ft   6005929.66848 2117544.18385 37.7947075984216 -122.423468565942 (37.7947075984216, -122.423468565942)
162611 136256 2 82 1422 Vallejo St 3 1 1 1     13 Width 3ft   6006727.18618 2118403.8407799997 37.7971129818473 -122.42077010155701 (37.7971129818473, -122.420770101557)
63227 136249 2 82 1717 Jones St 2 1 1 1     13 Width 3ft   6008299.50959 2118376.18019 37.797125527381894 -122.41532749988701 (37.7971255273819, -122.415327499887)
148148 239334 2 82 3206 Harrison St 3 1 1 1     13 Width 3ft   6008990.25346 2099948.20272 37.7465654071644 -122.411634644342 (37.7465654071644, -122.411634644342)
184376 239329 2 82 3215 Harrison St 1 1 1 1     13 Width 3ft   6009024.67189 2099961.90595 37.746604963844206 -122.411516596636 (37.7466049638442, -122.411516596636)
173165 239337 2 82 1534 Alabama St 1 1 1 1     13 Width 3ft   6009307.10914 2100388.95638 37.7477933882533 -122.410570106037 (37.7477933882533, -122.410570106037)
148808 136271 2 82 240 Joice St 1 1 1 1     13 Width 3ft   6010208.66727 2117064.18713 37.7936302286056 -122.40862871256701 (37.7936302286056, -122.408628712567)
171428 197068 2 82 430 San Bruno Ave 1 1 1 1     13 Width 3ft   6010884.7435 2106309.51664 37.764138254402596 -122.405531618298 (37.7641382544026, -122.405531618298)
176731 197101 2 82 37 Arkansas St 1 9 1 1     13 Width 3ft   6012884.97292 2106850.1929599997 37.7657344728051 -122.398651302829 (37.7657344728051, -122.398651302829)
67268 197120 2 82 301 Mississippi St 1 4 1 1     13 Width 3ft   6014065.797040001 2105649.96536 37.7625046287026 -122.394483006312 (37.7625046287026, -122.394483006312)
178520 197119 2 82 309 Mississippi St 1 4 1 1     13 Width 3ft   6014067.1485 2105627.53504 37.7624431150761 -122.394476761399 (37.7624431150761, -122.394476761399)
Powered by Datasette · Query took 8.16ms · Data source: data.sfgov.org