sf-trees

Data source: data.sfgov.org

Custom SQL query returning 40 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4658 176983 3 38 2935 Alemany Blvd 1 1 1 2     22 Width 3ft   5996974.67191 2087476.2225099998 37.711638981816 -122.452283225586 (37.711638981816, -122.452283225586)
4683 176984 3 38 2923 Alemany Blvd 2 1 1 2     28 Width 3ft   5996996.89662 2087496.1826099998 37.7116950608382 -122.452207850721 (37.7116950608382, -122.452207850721)
8136 2477 3 38 2307X Sacramento St 1 1 1 2     12 3x4   6003648.68016 2115921.80581 37.790123955413705 -122.43124522668998 (37.7901239554137, -122.43124522669)
11074 882 3 38 1138X Alemany Blvd 1 1 1 2   02/26/2016 12:00:00 AM 28 3x3   6003576.60001 2094409.9739299999 37.7310535326811 -122.429959483056 (37.7310535326811, -122.429959483056)
11690 1262 3 38 3900 Alemany Blvd 1 1 1 2     30 3X5   5992602.03225 2087509.49597 37.7114788737215 -122.467398529617 (37.7114788737215, -122.467398529617)
12496 24276 3 38 350X Winding Way 14 11 1 2     6 8   6000825.35085 2086800.6303 37.710003801206796 -122.438925891137 (37.7100038012068, -122.438925891137)
17570 1213 3 38 3411 Alemany Blvd 1 1 1 2     25 3X3   5993897.04108 2087339.7447 37.711087454604204 -122.46291036762199 (37.7110874546042, -122.462910367622)
18415 13417 3 38 400 Marietta Dr 1 11 1 2     70 5   5999553.15658 2097034.9165400001 37.7380323275191 -122.444057708717 (37.7380323275191, -122.444057708717)
21000 29586 3 38 500X Junipero Serra Blvd 21 11 1 2     9 3X3   5991342.7865 2093687.81781 37.7283702470744 -122.47220084100901 (37.7283702470744, -122.472200841009)
21489 29601 3 38 900X Junipero Serra Blvd 10 11 1 2   03/09/2013 12:00:00 AM 3 3X3   5991172.090009999 2091066.888 37.7211639453471 -122.472599932234 (37.7211639453471, -122.472599932234)
21749 29627 3 38 900X Junipero Serra Blvd 36 11 1 2   03/09/2013 12:00:00 AM 12 3X3   5991152.87782 2090760.03066 37.7203202787275 -122.472643981031 (37.7203202787275, -122.472643981031)
23148 973 3 38 1599 Alemany Blvd 4 1 1 2     22 0   6001917.27172 2093023.46154 37.72715237348 -122.435596901293 (37.72715237348, -122.435596901293)
24818 191371 3 38 900x Carolina St 66 3 1 2     13     6012518.79145 2102845.53786 37.7547181653131 -122.39963665401699 (37.7547181653131, -122.399636654017)
27702 191370 3 38 900x Carolina St 63 3 1 2     15     6012517.15762 2102887.31193 37.75483277672829 -122.399645237162 (37.7548327767283, -122.399645237162)
30866 200618 3 38 1400x La Salle Ave 59 11 1 2     3 Width 0ft   6016445.2081 2095088.6176 37.733637339432 -122.38551735943399 (37.733637339432, -122.385517359434)
38640 191369 3 38 900x Carolina St 62 3 1 2     15     6012514.91638 2102899.16549 37.7548651990855 -122.399653820263 (37.7548651990855, -122.399653820263)
38728 200604 3 38 1400x La Salle Ave 61 11 1 2     8 Width 0ft   6016455.981000001 2095075.886 37.7336029770488 -122.385479227084 (37.7336029770488, -122.385479227084)
72294 200614 3 38 1400x La Salle Ave 55 11 1 2     6 Width 0ft   6016432.4764 2095111.6325 37.73369982930821 -122.385562980445 (37.7336998293082, -122.385562980445)
76333 200612 3 38 1400x La Salle Ave 53 11 1 2     4 Width 0ft   6016428.558999999 2095128.7713 37.7337466722751 -122.385577718213 (37.7337466722751, -122.385577718213)
76733 200616 3 38 1400x La Salle Ave 57 11 1 2     7 Width 0ft   6016436.8835 2095099.8803 37.7336678039609 -122.385546924914 (37.7336678039609, -122.385546924914)
79154 976 3 38 1599 Alemany Blvd 7 1 1 2     25 3X4   6001942.44101 2093088.0021099998 37.7273310167784 -122.43551450655701 (37.7273310167784, -122.435514506557)
79594 12917 3 38 2935X Alemany Blvd 1 1 1 2     45 3x3   5996989.32715 2087489.72289 37.7116768903089 -122.452233546915 (37.7116768903089, -122.452233546915)
84781 101254 3 38 3700X Cesar Chavez St 1 7 1 2           6005840.6 2100555.6 37.74805599841039 -122.422568977073 (37.7480559984104, -122.422568977073)
94398 116654 3 38 199x Esmeralda Ave 9 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
95215 116655 3 38 199x Esmeralda Ave 9 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
95391 113478 3 38 100x ESMERALDA AVE 5 14 1 2     8     6006917.0 2098966.0 37.7437519821991 -122.418734104398 (37.7437519821991, -122.418734104398)
95944 116681 3 38 100 Esmeralda Ave 20 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
98542 12918 3 38 2935X Alemany Blvd 2 1 1 2     45 3x3   5996989.32715 2087489.72289 37.7116768903089 -122.452233546915 (37.7116768903089, -122.452233546915)
102052 23670 3 38 317 Virginia Ave 1 11 1 2     3 12   6006937.941544901 2098264.8464559 37.7418279505329 -122.41861198258002 (37.7418279505329, -122.41861198258)
105136 18878 3 38 2305 Sacramento St 1 1 1 2     26 3X3   6003659.521319999 2115878.15996 37.7900047293604 -122.43120460047501 (37.7900047293604, -122.431204600475)
112441 24808 3 38 7117 Geary Blvd 1 1 1 2   08/22/1996 12:00:00 AM 3 3X3   5984967.23631 2112432.54215 37.7794670623637 -122.49562310699899 (37.7794670623637, -122.495623106999)
117712 26830 3 38 3590X 19th Ave 7 1 1 2   03/18/1999 12:00:00 AM 8 3x18   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219)
128729 105136 3 38 175X ESMERALDA AVE 2 19 1 2           6007213.0 2098808.0 37.7433348108676 -122.41769940776301 (37.7433348108676, -122.417699407763)
131762 191368 3 38 900x Carolina St 60 3 1 2     25     6012502.16132 2102909.3105599997 37.7548923442165 -122.399698643387 (37.7548923442165, -122.399698643387)
137132 200619 3 38 1400x La Salle Ave 60 11 1 2     8 Width 0ft   6016453.0429 2095085.1899 37.733628361140106 -122.38549003320101 (37.7336283611401, -122.385490033201)
139249 16565 3 38 2305X Alemany Blvd 1 1 1 2     30 3X3   5999593.35864 2089327.05238 37.716870613942795 -122.443365227339 (37.7168706139428, -122.443365227339)
140815 16566 3 38 2305X Alemany Blvd 2 1 1 2     16 3X3   5999574.07501 2089304.05837 37.716806377922104 -122.44343023048201 (37.7168063779221, -122.443430230482)
142319 24738 3 38 7700 Geary Blvd 1 1 1 2   02/09/1996 12:00:00 AM 3 3X3   5983089.132019999 2112566.68135 37.7797252106941 -122.502130088809 (37.7797252106941, -122.502130088809)
143078 121420 3 38 1155x Prague St 1 11 1 2       3x3   6000780.0 2086820.0 37.7100544057225 -122.439084019343 (37.7100544057225, -122.439084019343)
182431 218284 3 38 50x Junipero Serra Frontage West 0 3 1 2     28     5991438.8932 2095398.7783700002 37.7330736770928 -122.4719932523 (37.7330736770928, -122.4719932523)
Powered by Datasette · Query took 3.454ms · Data source: data.sfgov.org