sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
66608 113772 6 21 2550 Broadway 4 5 1 1     4     6001375.31674 2117310.7972 37.793808671186106 -122.439210462719 (37.7938086711861, -122.439210462719)
67557 100121 6 1 690 Miramar Ave 1 7 1 1           5995444.4 2093941.6 37.729303587844704 -122.45803982404199 (37.7293035878447, -122.458039824042)
72156 104935 6 62 835 Gonzalez Dr 1 7 1 1           5990419.0 2090610.0 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631)
74397 120924 6 143 3995X Alemany Blvd 7 5 1 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
77671 107413 6 231 276 Yerba Buena Ave 1 7 1 1     28     5995080.66446 2095640.15746 37.733946507354396 -122.459420244296 (37.7339465073544, -122.459420244296)
77934 105417 6 5 1450X McAllister St 3 7 1 1           6002220.7882900005 2111575.67932 37.7781095739995 -122.43587451144501 (37.7781095739995, -122.435874511445)
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)
78391 108038 6 3 1 Twin Peaks Blvd   7 1 1           5998985.485719999 2105240.3128 37.760529947122706 -122.446610614338 (37.7605299471227, -122.446610614338)
78513 113727 6 26 1580 Valencia St 4 7 1 1           6006496.0 2100402.0 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307)
78751 117435 6 182 98X CLIPPER ST 1 13 1 1           6004559.0 2101087.0 37.749442713924296 -122.427038546128 (37.7494427139243, -122.427038546128)
78769 116833 6 60 1750 Geneva Ave 1 7 1 1           6004521.4 2087037.7 37.710864341935 -122.42616849363998 (37.710864341935, -122.42616849364)
78929 99659 6 5 1325 Portola Dr 3 7 1 1           5993615.2 2097760.6 37.7396843456359 -122.464640684629 (37.7396843456359, -122.464640684629)
79287 98950 6 108 401 Grove St 10 7 1 1           6005778.2 2111279.0 37.7774964045324 -122.423547027313 (37.7774964045324, -122.423547027313)
79308 111069 6 163 1836 08TH AVE 3 8 1 1       3x15   5993799.0 2102987.0 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175)
79360 112811 6 17 2023 43rd Ave 1 7 1 1           5982877.4 2101339.2 37.748885310102104 -122.502031530859 (37.7488853101021, -122.502031530859)
79421 120930 6 3 3995X Alemany Blvd 13 5 1 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
79490 113728 6 26 1580 Valencia St 5 7 1 1           6006496.0 2100402.0 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307)
79568 116501 6 3 71X PARKRIDGE DR 2 3 1 1     40 3x3   5999012.0 2102131.0 37.751994056327 -122.446295237287 (37.751994056327, -122.446295237287)
79584 116089 6 5 98x WOODWARD ST 3 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
79699 110954 6 3 126X Mendell St 1 9 1 1   05/12/2015 12:00:00 AM 3     6017060.745069999 2098543.2218400002 37.74315702656929 -122.38362967653299 (37.7431570265693, -122.383629676533)
79771 105872 6 5 595X San Jose Ave 6 7 1 1           6006124.4715599995 2100100.1430599997 37.7468214281195 -122.421555015777 (37.7468214281195, -122.421555015777)
79797 114240 6 60 99x FONT BLVD 16 2 1 1           5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
80137 101978 6 25 25X Tiffany Ave 1 7 1 1     12     6006502.0 2099737.0 37.7458455996049 -122.420223786963 (37.7458455996049, -122.420223786963)
80217 92320 6 2 2733 Wawona St 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5984522.0 2096783.0 37.736471699686206 -122.49600850837099 (37.7364716996862, -122.496008508371)
80520 116010 6 198 199x SAN BUENAVENTURA WAY 2 1 1 1       3x3   5993547.0 2095667.0 37.7339319096844 -122.464724497297 (37.7339319096844, -122.464724497297)
80545 114228 6 140 99x FONT BLVD 4 2 1 1     7     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
80662 110904 6 17 203 CORBETT AVE 1 7 1 1     20 3x3   6000094.0 2105620.0 37.7616357315689 -122.442804047122 (37.7616357315689, -122.442804047122)
80719 116576 6 40 2500x OCEAN AVE 1 9 1 6 4   30 10X10   5991377.0 2094742.0 37.7312667472315 -122.472159374256 (37.7312667472315, -122.472159374256)
80921 104904 6 26 417 Gonzalez Dr 1 7 1 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
81067 113358 6 116 702 Foerster St 1 5 1 1           5998153.40008835 2095558.62470631 37.733898832504295 -122.448791034412 (37.7338988325043, -122.448791034412)
81071 78107 6 129 970 GUERRERO ST 1 7 1 1     15     6005649.9 2103318.5 37.755631523761394 -122.42342479955799 (37.7556315237614, -122.423424799558)
81078 94935 6 469 2451X Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
81189 98546 6 5 555@Rio Teresita Blvd 2 9 1 1           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448)
81326 99859 6 193 4443 19th St 1 7 1 1     12     6001193.1 2104609.9 37.7589248414166 -122.43893032447399 (37.7589248414166, -122.438930324474)
81453 114249 6 40 499x 24TH AVE 1 5 1 1       3x3   5988415.0 2112957.0 37.78110836988721 -122.483734439284 (37.7811083698872, -122.483734439284)
81710 104892 6 62 201 Gonzalez Dr   7 1 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
81752 116834 6 60 1750 Geneva Ave 2 7 1 1           6004521.4 2087037.7 37.710864341935 -122.42616849363998 (37.710864341935, -122.42616849364)
81776 114391 6 82 23x PINTO AVE 2 7 1 1     7     5988521.0 2090808.0 37.720299292258794 -122.481744923362 (37.7202992922588, -122.481744923362)
81797 115888 6 41 811 TREAT AVE 1 8 1 1     20 3x3   6008597.0 2103712.0 37.7568778816719 -122.413260590978 (37.7568778816719, -122.413260590978)
82109 105208 6 1 2694 47TH AVE   7 1 1           5981878.3 2096771.8 37.736285749950206 -122.50514791128201 (37.7362857499502, -122.505147911282)
82114 98455 6 189 2200 22nd St 1 7 1 1           6011565.2 2103754.7 37.7571613219705 -122.402998394603 (37.7571613219705, -122.402998394603)
82126 115125 6 11 499X MAIN ST 3 1 1 1     8     6015842.0 2114626.0 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338)
82216 116521 6 26 70 BEAUMONT AVE 1 9 1 1     10 3x3   5996728.0 2112568.0 37.7805206716372 -122.454947659336 (37.7805206716372, -122.454947659336)
82320 113769 6 17 2550 Broadway 1 5 1 1           6001418.65940389 2117313.19689891 37.7938177263924 -122.439060665499 (37.7938177263924, -122.439060665499)
82400 115123 6 11 499X MAIN ST 1 1 1 1     12     6015842.0 2114626.0 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338)
82402 114388 6 16 361x ARBALLO DR 1 7 1 1     7     5988379.0 2090615.0 37.7197611043299 -122.48222163222201 (37.7197611043299, -122.482221632222)
82542 108215 6 3 865 EL CAMINO DEL MAR 1 7 1 1           5985761.0 2114995.0 37.7865492821054 -122.49306599544501 (37.7865492821054, -122.493065995445)
82760 120597 6 3 499x Ocean Ave 5 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
82925 112725 6 47 40x BERNAL HEIGHTS BLVD 1 1 1 1     30 3x3   6009324.0 2098099.0 37.7415066181332 -122.41035003366801 (37.7415066181332, -122.410350033668)
83026 105765 6 3 95 ORA WAY 1 7 1 1     18     6001454.9 2097857.0 37.7403978808149 -122.437541306682 (37.7403978808149, -122.437541306682)
83185 113738 6 26 1580 Valencia St 15 7 1 1           6006496.0 2100402.0 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307)
83189 104146 6 3 1710-1738 Diamond St 1 7 1 1     40     6001979.7 2099047.6 37.743696813668706 -122.43581192261101 (37.7436968136687, -122.435811922611)
83219 108097 6 17 3370 Washington St 2 8 1 1           5998663.3699 2115944.3199400003 37.789901994506 -122.44849555223101 (37.789901994506, -122.448495552231)
83253 98082 6 105 525 Grafton Ave 1 5 1 1           5995193.7 2090526.9 37.7199132334677 -122.45865940878001 (37.7199132334677, -122.45865940878)
83367 115940 6 41 3401x 17TH ST 1 1 1 18     20 3x3   6006069.0 2106010.0 37.7630453994978 -122.42216662533801 (37.7630453994978, -122.422166625338)
83580 92310 6 18 2591 26th Ave 1 5 1 1 1 10/18/2008 12:00:00 AM   3x3   5988279.0 2097698.2 37.7392039339278 -122.48308618722099 (37.7392039339278, -122.483086187221)
83893 110583 6 100 46 COOK ST 5 1 1 1     36     5997534.0 2113434.0 37.782944683725 -122.45222184269899 (37.782944683725, -122.452221842699)
83993 114406 6 203 500X ARBALLO DR 3 1 1 1       3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035)
84041 114392 6 15 104x TAPIA DR 1 8 1 1     10     5988688.0 2090939.0 37.72066869526729 -122.481177253578 (37.7206686952673, -122.481177253578)
84141 120594 6 3 499x Ocean Ave 2 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
84223 108244 6 46 150 Conrad St 1 16 1 1     20     6001768.8 2096480.0 37.7366348009068 -122.43635744032801 (37.7366348009068, -122.436357440328)
84297 121446 6 17 500 Terry A Francois Blvd 1 5 1 1       3x3   6016102.0 2110410.0 37.775687633053 -122.38777260103399 (37.775687633053, -122.387772601034)
84569 105964 6 17 360 MISSOURI ST 1 7 1 1           6013401.8 2105413.2 37.761817588008206 -122.39676294611401 (37.7618175880082, -122.396762946114)
84582 114072 6 21 454 ARBALLO DR 1 2 1 1     4     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
84668 116500 6 3 71X PARKRIDGE DR 1 3 1 1     45 3x3   5999012.0 2102131.0 37.751994056327 -122.446295237287 (37.751994056327, -122.446295237287)
84673 110840 6 17 2037 TURK BLVD 2 7 1 1           6000252.0 2111948.0 37.779019836036206 -122.442711981138 (37.7790198360362, -122.442711981138)
84676 105867 6 60 3555 Cesar Chavez St 2 7 1 1           6006336.4 2100501.8 37.7479362343406 -122.420850697466 (37.7479362343406, -122.420850697466)
84748 120926 6 143 3995X Alemany Blvd 9 5 1 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
84791 108196 6 44 930 FLORIDA ST 1 1 1 1           6009368.6 2103733.3 37.7569796561067 -122.410593604092 (37.7569796561067, -122.410593604092)
84797 112378 6 54 1850 19TH AVE 1 1 1 1     10 3x3   5990394.0 2102783.0 37.7532883185876 -122.476144836826 (37.7532883185876, -122.476144836826)
85026 99100 6 5 60 Santa Monica Way 1 1 1 1           5993700.7 2097327.0 37.7384987171226 -122.464313592449 (37.7384987171226, -122.464313592449)
85138 103617 6 26 201X Haight St 2 9 1 1           6004725.0 2109149.0 37.7715884407354 -122.427038651796 (37.7715884407354, -122.427038651796)
85229 107718 6 17 1 DOUGLASS ST 1 7 1 1     16     6001037.5 2106279.2 37.763499475963705 -122.439588129958 (37.7634994759637, -122.439588129958)
85374 114726 6 54 520 Townsend St 2 7 1 1           6012508.1 2109575.3 37.7731959986981 -122.40014623691201 (37.7731959986981, -122.400146236912)
85387 107149 6 3 612 WISCONSIN ST 1 13 1 1           6012651.9 2104553.6 37.7594155491308 -122.39929622330901 (37.7594155491308, -122.399296223309)
85678 115250 6 26 1404x Mason St 1 7 1 1   01/20/2016 12:00:00 AM       6009352.6 2118074.7 37.796356867240206 -122.41166222086001 (37.7963568672402, -122.41166222086)
85680 99097 6 5 99X Santa Monica Way 1 2 1 1           5994003.8 2097131.6 37.7379796635799 -122.463251452094 (37.7379796635799, -122.463251452094)
85684 116955 6 46 818 Douglass St 1 8 1 1     6 3x3   6001245.0 2101454.0 37.7502624545247 -122.43852471352 (37.7502624545247, -122.43852471352)
85687 113112 6 129 1633 OAKDALE AVE 1 1 1 1           6014731.0 2095647.0 37.735075549566204 -122.391482947841 (37.7350755495662, -122.391482947841)
85774 100552 6 193 4443 19th St 4 7 1 1           6001193.1 2104609.9 37.7589248414166 -122.43893032447399 (37.7589248414166, -122.438930324474)
85803 106833 6 19 174 STILLINGS AVE 1 7 1 1           5999619.6 2095804.2 37.7346568605649 -122.443739589791 (37.7346568605649, -122.443739589791)
85903 105084 6 54 344 Fulton St 4 7 1 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
86013 114235 6 140 99x FONT BLVD 11 2 1 1     13     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
86041 105089 6 54 344 Fulton St 9 7 1 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
86202 98947 6 340 401 Grove St 7 7 1 1           6005778.2 2111279.0 37.7774964045324 -122.423547027313 (37.7774964045324, -122.423547027313)
86298 105862 6 26 3615-3623X Cesar Chavez St 3 7 1 1           6005538.0 2100417.0 37.747658358497404 -122.423605504909 (37.7476583584974, -122.423605504909)
86498 107113 6 115 2100 MARKET ST   8 1 1           6004034.0 2107672.1 37.767494134010896 -122.429323526179 (37.7674941340109, -122.429323526179)
86677 121161 6 11 350x Octavia St 5 17 1 1           6005623.0 2110494.0 37.7753322239184 -122.42402807847701 (37.7753322239184, -122.424028078477)
86717 108022 6 145 455X Ivy St 2 8 1 1           6005179.30837 2111099.83336 37.776970634543 -122.42560603936 (37.776970634543, -122.42560603936)
86774 122640 6 47 3630X 19th Ave 4 9 1 1       3x8   5990614.0 2091411.0 37.7220764711857 -122.47455416918999 (37.7220764711857, -122.47455416919)
86807 109521 6 17 1308 Ulloa St 1 7 1 1       3x3   5991965.5 2098469.9 37.741536659377395 -122.470396231887 (37.7415366593774, -122.470396231887)
86822 114840 6 5 2455x HYDE ST   1 1 13     12 3x3   6006980.0 2120877.0 37.803917898432395 -122.42007090461901 (37.8039178984324, -122.420070904619)
86829 110841 6 17 2037 TURK BLVD 3 7 1 1           6000252.0 2111948.0 37.779019836036206 -122.442711981138 (37.7790198360362, -122.442711981138)
86962 114103 6 62 5 ACEVEDO AVE 2 7 1 1     15     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
87085 113937 6 3 800 EL CAMINO DEL MAR 1 7 1 1     35     5985966.0 2115003.0 37.7865832348262 -122.49235734524099 (37.7865832348262, -122.492357345241)
87119 112572 6 141 162 GRAND VIEW AVE 4 8 1 1       3x3   6000754.0 2103380.0 37.7555228430156 -122.440360729392 (37.7555228430156, -122.440360729392)
87200 113739 6 26 1580 Valencia St 16 7 1 1           6006496.0 2100402.0 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307)
87325 105504 6 3 39 MAGELLAN AVE 1 7 1 1     18     5994694.1 2101166.3 37.7490976851152 -122.46115713573299 (37.7490976851152, -122.461157135733)
87916 98953 6 39 302 Ivy St 19 7 1 1           6005888.5 2111234.3 37.7773798943726 -122.42316228433 (37.7773798943726, -122.42316228433)
87946 113741 6 11 1580 Valencia St 1 7 1 1     18     6006496.0 2100402.0 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307)
87949 96848 6 75 1486 Innes Ave   7 1 1           6016133.4 2096820.6 37.7383757570157 -122.386716118251 (37.7383757570157, -122.386716118251)
Powered by Datasette · Query took 6.967ms · Data source: data.sfgov.org