sf-trees

Data source: data.sfgov.org

Custom SQL query returning 34 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
9677 114154 6 5 1200x JUNIPERO SERRA BLVD 13 7 1 1     20     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9996 173615 6 5 1200X JUNIPERO SERRA BLVD 14 7 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
77934 105417 6 5 1450X McAllister St 3 7 1 1           6002220.7882900005 2111575.67932 37.7781095739995 -122.43587451144501 (37.7781095739995, -122.435874511445)
78929 99659 6 5 1325 Portola Dr 3 7 1 1           5993615.2 2097760.6 37.7396843456359 -122.464640684629 (37.7396843456359, -122.464640684629)
79771 105872 6 5 595X San Jose Ave 6 7 1 1           6006124.4715599995 2100100.1430599997 37.7468214281195 -122.421555015777 (37.7468214281195, -122.421555015777)
80060 113973 6 5 11 Hiliritas Ave 1 7 1 1         Permit Number 776381 6001589.6 2096875.9 37.7377116664791 -122.437005345865 (37.7377116664791, -122.437005345865)
81189 98546 6 5 555@Rio Teresita Blvd 2 9 1 1           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448)
85026 99100 6 5 60 Santa Monica Way 1 1 1 1           5993700.7 2097327.0 37.7384987171226 -122.464313592449 (37.7384987171226, -122.464313592449)
85142 104690 6 5 1435X La Salle Ave 1 7 1 1         Permit Number 770699 6016460.43075 2095036.9864400001 37.733496412822205 -122.385461132957 (37.7334964128222, -122.385461132957)
85680 99097 6 5 99X Santa Monica Way 1 2 1 1           5994003.8 2097131.6 37.7379796635799 -122.463251452094 (37.7379796635799, -122.463251452094)
89406 114379 6 5 443X ARBALLO DR 1 7 1 1     36     5988110.0 2090275.0 37.718811899837206 -122.483126550771 (37.7188118998372, -122.483126550771)
91700 95229 6 5 1@Carl Irving St 5 9 1 1   11/16/2010 12:00:00 AM 15     5995817.2 2106753.3 37.7645027364821 -122.45767767256001 (37.7645027364821, -122.45767767256)
98300 94851 6 5 1107 Bowdoin St 2 7 1 1   11/17/2010 12:00:00 AM 12   Permit Number 774691 6009593.0 2091048.0 37.7221611506882 -122.408922553301 (37.7221611506882, -122.408922553301)
102846 105415 6 5 1450X McAllister St 1 7 1 1           6002220.7882900005 2111575.67932 37.7781095739995 -122.43587451144501 (37.7781095739995, -122.435874511445)
104669 95231 6 5 1@Carl Irving St 10 9 1 1   11/16/2010 12:00:00 AM       5995817.2 2106753.3 37.7645027364821 -122.45767767256001 (37.7645027364821, -122.45767767256)
105103 105858 6 5 1580 Valencia St 18 7 1 1           6006496.0 2100402.0 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307)
105359 98545 6 5 555@Rio Teresita Blvd 1 7 1 1           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448)
105444 105416 6 5 1450X McAllister St 2 7 1 1           6002220.7882900005 2111575.67932 37.7781095739995 -122.43587451144501 (37.7781095739995, -122.435874511445)
108061 104751 6 5 13X JUAN BAUTISTA CIR 2 7 1 1           5989494.0 2090180.0 37.7186314952818 -122.47833572411999 (37.7186314952818, -122.47833572412)
118749 105859 6 5 1580 Valencia St 18 7 1 1           6006496.0 2100402.0 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307)
121713 92964 6 5 380 Valdez Ave 1 7 1 1     17     5995792.2 2095482.9 37.7335556021648 -122.456948893253 (37.7335556021648, -122.456948893253)
138465 120551 6 5 1485 Fairfax Ave 1 7 1 1           6016296.0 2097688.0 37.7407664622153 -122.38621437638201 (37.7407664622153, -122.386214376382)
171221 112905 6 5 2401 Keith St 1 7 1 1     25     6014331.87009 2092225.76664 37.725659374776605 -122.39262364628901 (37.7256593747766, -122.392623646289)
2854 253253 6 5 99X Lopez Ave 4 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
8131 112367 6 5 2770 Broadway 1 5 1 1   07/23/2015 12:00:00 AM 3 3x3 Permit Number 774944 6000432.434780001 2117179.73451 37.7933951089516 -122.442463497617 (37.7933951089516, -122.442463497617)
13306 187657 6 5 2072 15th Ave 1 2 1 1       3x3   5991666.0 2101424.0 37.7496305363998 -122.47164701446 (37.7496305363998, -122.47164701446)
78383 115661 6 5 341 HAZELWOOD AVE 1 1 1 1     15 3x3   5996066.0 2095432.0 37.7334315621613 -122.455998615118 (37.7334315621613, -122.455998615118)
79584 116089 6 5 98x WOODWARD ST 3 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
86822 114840 6 5 2455x HYDE ST   1 1 13     12 3x3   6006980.0 2120877.0 37.803917898432395 -122.42007090461901 (37.8039178984324, -122.420070904619)
101747 113695 6 5 907 FLORIDA ST 1 1 1 1     24 3x3   6009441.0 2103786.0 37.7571284172194 -122.41034693748101 (37.7571284172194, -122.410346937481)
103243 116088 6 5 98x WOODWARD ST 2 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
107871 116087 6 5 98x WOODWARD ST 1 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
125535 116090 6 5 98x WOODWARD ST 4 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
154324 112045 6 5 2418 Pacific Ave 1 8 1 1     18 3x3   6002446.95594 2117111.03197 37.7933210893366 -122.435488200226 (37.7933210893366, -122.435488200226)
Powered by Datasette · Query took 6.154ms · Data source: data.sfgov.org