sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1582 45051 3 37 2243 26th Ave 1 1 1 1 1 05/08/2001 12:00:00 AM 3   Permit Number 43936 5988218.295 2100043.5647 37.7456401553342 -122.483467967859 (37.7456401553342, -122.483467967859)
4538 253635 3 37 830 Oak St 2 5 1 2   02/22/2008 12:00:00 AM       6003018.63904 2109969.70237 37.7737452502421 -122.43299969185101 (37.7737452502421, -122.432999691851)
10437 115185 3 37 2300X Alemany Blvd 2 11 1 2     3     5999482.43288 2089277.31598 37.716727722789 -122.443745071105 (37.716727722789, -122.443745071105)
10742 115189 3 37 2300X Alemany Blvd 6 11 1 2     3     5999437.68927 2089235.07738 37.716609193035396 -122.443896694081 (37.7166091930354, -122.443896694081)
11166 112236 3 37 2400X Alemany Blvd 1 11 1 2   10/04/2015 08:45:00 AM 3     5999186.55259 2088995.9330400003 37.7159382286299 -122.444747565144 (37.7159382286299, -122.444747565144)
11251 115187 3 37 2300X Alemany Blvd 4 11 1 2     3     5999459.81391 2089256.7158599999 37.716669869389 -122.443821774256 (37.716669869389, -122.443821774256)
11513 112244 3 37 2400X Alemany Blvd 9 11 1 2   10/27/2015 07:23:00 AM 3     5999075.356319999 2088897.5178 37.7156616565467 -122.445124838863 (37.7156616565467, -122.445124838863)
12254 112240 3 37 2400X Alemany Blvd 5 11 1 2   10/27/2015 07:38:00 AM 3     5999143.09775 2088953.6674799998 37.7158196970968 -122.444894728405 (37.7158196970968, -122.444894728405)
12735 115192 3 37 2300X Alemany Blvd 9 11 1 2     3     5999381.87795 2089181.7631299999 37.7164596204897 -122.44408577653499 (37.7164596204897, -122.444085776535)
12942 112238 3 37 2400X Alemany Blvd 3 11 1 2   10/27/2015 08:30:00 AM 3     5999164.96486 2088975.3114099998 37.715880374360204 -122.444820700722 (37.7158803743602, -122.444820700722)
13110 112242 3 37 2400X Alemany Blvd 7 11 1 2   10/27/2015 07:31:00 AM 3     5999099.9806 2088915.2496599997 37.7157117496696 -122.445041000443 (37.7157117496696, -122.445041000443)
16849 22416 3 37 5800 03rd St 15 1 1 2     18     6013664.2375 2091773.8949 37.724381524856206 -122.39489998248001 (37.7243815248562, -122.39489998248)
17550 1369 3 37 34 Amethyst Way 1 1 1 2   12/02/1997 12:00:00 AM 3     5999059.98844 2100047.12811 37.746274991794294 -122.445979419622 (37.7462749917943, -122.445979419622)
18003 26207 3 37 758 San Jose Ave 1 1 1 2   12/09/1997 12:00:00 AM 6     6005594.7559 2098614.98254 37.742713632417605 -122.42328116790199 (37.7427136324176, -122.423281167902)
19020 25 3 37 736 14th St 1 1 1 2   07/17/1995 12:00:00 AM 0     6003903.525084401 2107767.6234363 37.7677490306877 -122.429781635515 (37.7677490306877, -122.429781635515)
19614 96252 3 37 301X Lee Ave 4 1 1 2   04/18/2011 12:00:00 AM     Permit Number 56953 5996248.46954 2091917.7406900001 37.7237927195289 -122.45511390994899 (37.7237927195289, -122.455113909949)
23097 24665 3 37 4850 Geary Blvd 1 1 1 2     7     5991933.61016 2112783.76885 37.7808369148225 -122.471549293385 (37.7808369148225, -122.471549293385)
23348 12189 3 37 1463 La Salle Ave 1 1 1 2     2     6016268.9903 2095509.3837 37.7347829272824 -122.38615592449699 (37.7347829272824, -122.386155924497)
36706 112246 3 37 2400X Alemany Blvd 11 11 1 2     1     5999047.56745 2088876.5109400002 37.715602390323 -122.44521938006399 (37.715602390323, -122.445219380064)
42483 97165 3 37 262 07th St 1 1 1 2     5     6010119.55903 2111062.91718 37.777147179847105 -122.408513509413 (37.7771471798471, -122.408513509413)
78172 442 3 37 700x 23rd Ave 2 11 1 2     12     5988814.32729 2110443.9038299997 37.7742313463884 -122.482168813724 (37.7742313463884, -122.482168813724)
79734 87582 3 37 3438X 19th Ave 1 1 1 2   02/24/2008 12:00:00 AM 3     5990574.05576 2092494.61094 37.725049482144 -122.47477129702 (37.725049482144, -122.47477129702)
81195 115191 3 37 2300X Alemany Blvd 8 11 1 2     3     5999393.52095 2089220.32873 37.7165661770546 -122.444048302203 (37.7165661770546, -122.444048302203)
83870 107512 3 37 1528X ALEMANY BLVD 1 11 1 2           6001955.0 2093277.9 37.727853146555 -122.435484669091 (37.727853146555, -122.435484669091)
83974 96248 3 37 1150 Ocean Ave 18 1 1 2   04/18/2011 12:00:00 AM     Permit Number 56953 5996248.46954 2091917.7406900001 37.7237927195289 -122.45511390994899 (37.7237927195289, -122.455113909949)
85262 115190 3 37 2300X Alemany Blvd 7 11 1 2     3     5999393.52095 2089220.32873 37.7165661770546 -122.444048302203 (37.7165661770546, -122.444048302203)
86069 115193 3 37 2300X Alemany Blvd 5 11 1 2     3     5999393.52095 2089220.32873 37.7165661770546 -122.444048302203 (37.7165661770546, -122.444048302203)
86411 115186 3 37 2300X Alemany Blvd 3 11 1 2     3     5999393.52095 2089220.32873 37.7165661770546 -122.444048302203 (37.7165661770546, -122.444048302203)
86803 96247 3 37 1150 Ocean Ave 5 1 1 2   04/18/2011 12:00:00 AM     Permit Number 56953 5996248.46954 2091917.7406900001 37.7237927195289 -122.45511390994899 (37.7237927195289, -122.455113909949)
87978 102959 3 37 1299X Junipero Serra Blvd 1 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
90389 464 3 37 760x 23rd Ave 18 11 1 2     6     5988827.211759999 2110098.29514 37.7732831501538 -122.48209892030701 (37.7732831501538, -122.482098920307)
92748 112239 3 37 2400X Alemany Blvd 4 11 1 2   10/27/2015 07:41:00 AM 3     5999054.92129 2088906.8460099997 37.715686103277505 -122.44519614164 (37.7156861032775, -122.44519614164)
95066 112245 3 37 2400X Alemany Blvd 10 11 1 2           5999054.92129 2088906.8460099997 37.715686103277505 -122.44519614164 (37.7156861032775, -122.44519614164)
101575 112247 3 37 2400X Alemany Blvd 12 11 1 2           5999054.92129 2088906.8460099997 37.715686103277505 -122.44519614164 (37.7156861032775, -122.44519614164)
104100 59809 3 37 1150 Ocean Ave 1 1 1 2   04/18/2011 12:00:00 AM     Permit Number 56953 5996255.87005341 2091897.48526237 37.723737527503 -122.455086864771 (37.723737527503, -122.455086864771)
104474 97692 3 37 70x Benton Ave 1 3 1 2   11/05/2011 12:00:00 AM       6004768.61645 2094959.0484200001 37.732628603868704 -122.425877544976 (37.7326286038687, -122.425877544976)
107333 41353 3 37 450 Guerrero St 5 1 1 1   03/03/2000 12:00:00 AM     Permit Number 42003 6005497.49834422 2106351.86830907 37.763951837444296 -122.424167571577 (37.7639518374443, -122.424167571577)
108864 102970 3 37 1299X Junipero Serra Blvd 17 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
110037 112243 3 37 2400X Alemany Blvd 8 11 1 2   10/27/2015 07:27:00 AM 3     5999054.92129 2088906.8460099997 37.715686103277505 -122.44519614164 (37.7156861032775, -122.44519614164)
114045 96250 3 37 301X Lee Ave 2 1 1 2   04/18/2011 12:00:00 AM     Permit Number 56953 5996248.46954 2091917.7406900001 37.7237927195289 -122.45511390994899 (37.7237927195289, -122.455113909949)
114714 87590 3 37 3690X 19th Ave 18 1 1 2   03/09/2013 12:00:00 AM 4     5990484.73648 2091103.44002 37.721224497411704 -122.474978557179 (37.7212244974117, -122.474978557179)
115055 24664 3 37 4850 Geary Blvd 2 1 1 2   02/14/1996 12:00:00 AM 6     5991951.48109 2112844.05547 37.781003479214604 -122.47149186391701 (37.7810034792146, -122.471491863917)
117724 17034 3 37 1160X Oak St 3 1 1 2   09/30/2014 01:41:00 PM 3     6001440.1294862 2109757.6168908 37.7730732545672 -122.438444795938 (37.7730732545672, -122.438444795938)
117769 115188 3 37 2300X Alemany Blvd 5 4 1 2     3     5999393.52095 2089220.32873 37.7165661770546 -122.444048302203 (37.7165661770546, -122.444048302203)
118012 96249 3 37 301X Lee Ave 1 1 1 2   04/18/2011 12:00:00 AM     Permit Number 56953 5996248.46954 2091917.7406900001 37.7237927195289 -122.45511390994899 (37.7237927195289, -122.455113909949)
118468 112237 3 37 2400X Alemany Blvd 2 11 1 2   10/27/2015 08:35:00 AM 3     5999054.92129 2088906.8460099997 37.715686103277505 -122.44519614164 (37.7156861032775, -122.44519614164)
120774 452 3 37 740x 23rd Ave 15 11 1 2     12     5988823.98791 2110205.31094 37.773576798380205 -122.482117913396 (37.7735767983802, -122.482117913396)
122409 96253 3 37 301X Lee Ave 5 1 1 2   04/18/2011 12:00:00 AM     Permit Number 56953 5996248.46954 2091917.7406900001 37.7237927195289 -122.45511390994899 (37.7237927195289, -122.455113909949)
125222 24674 3 37 4249 Geary Blvd 1 1 1 2   02/16/1996 12:00:00 AM 3     5993792.82485 2112723.92119 37.7807799742006 -122.465113065959 (37.7807799742006, -122.465113065959)
140437 96251 3 37 301X Lee Ave 3 1 1 2   04/18/2011 12:00:00 AM     Permit Number 56953 5996248.46954 2091917.7406900001 37.7237927195289 -122.45511390994899 (37.7237927195289, -122.455113909949)
141449 11981 3 37 1200X La Salle Ave 8 1 1 2   03/10/2007 12:00:00 AM 6     6017464.4799176 2094331.6246005 37.731615128467496 -122.381940767084 (37.7316151284675, -122.381940767084)
143039 115184 3 37 2300X Alemany Blvd 1 11 1 2     3     5999393.52095 2089220.32873 37.7165661770546 -122.444048302203 (37.7165661770546, -122.444048302203)
144552 112241 3 37 2400X Alemany Blvd 6 11 1 2   10/27/2015 07:34:00 AM 3     5999054.92129 2088906.8460099997 37.715686103277505 -122.44519614164 (37.7156861032775, -122.44519614164)
156626 97167 3 37 262 07th St 2 1 1 2     3     6010129.00149 2111054.10104 37.7771235015924 -122.40848022278 (37.7771235015924, -122.40848022278)
174181 242061 3 37 10x Benton Ave 7 3 1 2     2     6004744.49443 2095004.6976299998 37.732752583154394 -122.42596418912301 (37.7327525831544, -122.425964189123)
23157 16087 3 37 278 Monterey Blvd 1 1 1 2     4 0   6000249.694130001 2094706.57543 37.731678958116 -122.441482409212 (37.731678958116, -122.441482409212)
104777 3759 3 37 1062 Carolina St 1 11 1 2     12 18   6012453.5755993 2103020.9691678 37.755196225865895 -122.39987450779499 (37.7551962258659, -122.399874507795)
19259 1364 3 37 25 Amethyst Way 1 1 1 2     12 1X1   5999126.95834 2100012.88601 37.746184795201 -122.445745384538 (37.746184795201, -122.445745384538)
82881 104834 3 37 1202X Arguello Blvd 1 11 1 2   05/27/2014 12:00:00 AM 1 1x4   5995869.9 2107172.9 37.7656578771265 -122.45752575958599 (37.7656578771265, -122.457525759586)
12177 287 3 37 3355 19th Ave 3 1 1 2   02/27/1998 12:00:00 AM 6 2   5990530.52606 2093814.1828 37.7286701727855 -122.475018054542 (37.7286701727855, -122.475018054542)
22038 354 3 37 3690X 19th Ave 1 1 1 2   11/10/1995 12:00:00 AM 24 2   5990504.49839 2091477.17058 37.722251813860204 -122.474937513077 (37.7222518138602, -122.474937513077)
79259 329 3 37 3454X 19th Ave 1 1 1 2   11/15/1995 12:00:00 AM 3 2   5990579.05408 2092494.4249099998 37.725049260991604 -122.474754004974 (37.7250492609916, -122.474754004974)
79963 368 3 37 3690X 19th Ave 17 1 1 2   11/07/2015 01:12:00 PM 3 2   5990489.74295 2091103.38095 37.7212246253626 -122.474961247113 (37.7212246253626, -122.474961247113)
80402 389 3 37 3721X 19th Ave 10 1 1 2   03/18/2006 12:00:00 AM 3 2   5990351.3309 2090950.31436 37.72079632016629 -122.475428522866 (37.7207963201663, -122.475428522866)
83114 366 3 37 3690X 19th Ave 13 1 1 2     3 2   5990489.74295 2091103.38095 37.7212246253626 -122.474961247113 (37.7212246253626, -122.474961247113)
84381 343 3 37 3590X 19th Ave 12 1 1 2   03/09/2013 12:00:00 AM 3 2   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219)
85567 384 3 37 3721X 19th Ave 5 1 1 2   03/18/2006 12:00:00 AM 3 2   5990351.3309 2090950.31436 37.72079632016629 -122.475428522866 (37.7207963201663, -122.475428522866)
86727 387 3 37 3721X 19th Ave 7 1 1 2   03/18/2006 12:00:00 AM 3 2   5990351.3309 2090950.31436 37.72079632016629 -122.475428522866 (37.7207963201663, -122.475428522866)
94449 351 3 37 3590X 19th Ave 21 1 1 2   02/22/2008 12:00:00 AM 3 2   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219)
96255 338 3 37 3590X 19th Ave 6 1 1 2   03/18/1999 12:00:00 AM   2   5990537.683837099 2091850.0721832002 37.723277631918 -122.474850005229 (37.723277631918, -122.474850005229)
97846 238 3 37 3007 19th Ave 2 1 1 2   03/18/2006 12:00:00 AM 6 2   5990525.395690001 2095120.4577099998 37.7322565763444 -122.47513111186001 (37.7322565763444, -122.47513111186)
98859 346 3 37 3590X 19th Ave 15 1 1 2   11/07/2015 01:09:00 PM 3 2   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219)
98926 357 3 37 3690X 19th Ave 4 2 1 2   03/09/2013 12:00:00 AM 2 2   5990489.74295 2091103.38095 37.7212246253626 -122.474961247113 (37.7212246253626, -122.474961247113)
104889 352 3 37 3590X 19th Ave 20 1 1 2   05/18/1994 12:00:00 AM 3 2   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219)
108637 360 3 37 3690X 19th Ave 6 1 1 2   03/09/2013 12:00:00 AM 2 2   5990489.74295 2091103.38095 37.7212246253626 -122.474961247113 (37.7212246253626, -122.474961247113)
110799 342 3 37 3590X 19th Ave 11 1 1 2   03/09/2013 12:00:00 AM 3 2   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219)
110873 367 3 37 3690X 19th Ave 15 1 1 2   05/12/1994 12:00:00 AM 12 2   5990489.74295 2091103.38095 37.7212246253626 -122.474961247113 (37.7212246253626, -122.474961247113)
113903 355 3 37 3690X 19th Ave 3 1 1 2   03/09/2013 12:00:00 AM 2 2   5990489.7429471 2091103.3809490001 37.7212246253597 -122.47496124712299 (37.7212246253597, -122.474961247123)
114841 388 3 37 3721X 19th Ave 9 1 1 2   03/18/2006 12:00:00 AM 3 2   5990351.3309 2090950.31436 37.72079632016629 -122.475428522866 (37.7207963201663, -122.475428522866)
115580 347 3 37 3590X 19th Ave 16 1 1 2   02/24/2008 12:00:00 AM 25 2   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219)
119861 345 3 37 3590X 19th Ave 14 1 1 2     3 2   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219)
120248 383 3 37 3721X 19th Ave 2 1 1 2   03/18/2006 12:00:00 AM 3 2   5990351.3309 2090950.31436 37.72079632016629 -122.475428522866 (37.7207963201663, -122.475428522866)
123472 27533 3 37 3721X 19th Ave 3 1 1 2   03/18/2006 12:00:00 AM 3 2   5990351.3309 2090950.31436 37.72079632016629 -122.475428522866 (37.7207963201663, -122.475428522866)
125863 385 3 37 3721X 19th Ave 6 1 1 2   03/18/2006 12:00:00 AM 3 2   5990351.3309 2090950.31436 37.72079632016629 -122.475428522866 (37.7207963201663, -122.475428522866)
127778 341 3 37 3590X 19th Ave 10 1 1 2   03/10/2013 12:00:00 AM 10 2   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219)
10556 26324 3 37 1923 San Jose Ave 1 1 1 2   12/14/2000 12:00:00 AM 3 2X2   6000151.26449 2092808.65787 37.7264621078328 -122.44168654361401 (37.7264621078328, -122.441686543614)
17440 4242 3 37 4024 Cesar Chavez St 2 1 1 2     12 2X2   6003700.62714 2100425.74142 37.7475784763835 -122.42995965841101 (37.7475784763835, -122.429959658411)
86785 8935 3 37 4630 Geary Blvd 2 1 1 2   06/28/2001 12:00:00 AM 3 2X2   5992645.55478 2112808.55137 37.7809461229512 -122.469088155637 (37.7809461229512, -122.469088155637)
104242 24786 3 37 7795X Geary Blvd 1 1 1 2     6 2X2   5982848.853180001 2112367.91788 37.779165345195295 -122.502946585831 (37.7791653451953, -122.502946585831)
110981 24649 3 37 334 Winfield St 2 1 1 2     6 2X2   6006577.8350722 2097905.0215139 37.7408196712937 -122.41983158857599 (37.7408196712937, -122.419831588576)
126668 344 3 37 3590X 19th Ave 13 1 1 2   02/24/2008 12:00:00 AM 3 2X2   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219)
128385 9995 3 37 109 GUERRERO ST 2 1 1 2   11/06/2015 12:59:00 PM 3 2X2   6005457.0 2108414.0 37.7696116724665 -122.424454330606 (37.7696116724665, -122.424454330606)
142325 24788 3 37 7795X Geary Blvd 3 1 1 2     6 2X2   5982848.853180001 2112367.91788 37.779165345195295 -122.502946585831 (37.7791653451953, -122.502946585831)
1531 5189 3 37 509 Divisadero St 1 1 1 2     12 2X3   6001637.7109 2110249.8513 37.7744360439082 -122.43779659970501 (37.7744360439082, -122.437796599705)
23304 24655 3 37 333 Winfield St 1 1 1 2     5 2X3   6006602.01583 2097861.4273599996 37.7407013336984 -122.419744887942 (37.7407013336984, -122.419744887942)
87324 5216 3 37 911 Divisadero St 1 1 1 2     10 2X3   6001435.51822 2111590.83947 37.778106560678296 -122.43859212487601 (37.7781065606783, -122.438592124876)
94462 9254 3 37 6500X Geary Blvd 8 1 1 2   03/12/2011 12:00:00 AM 3 2X3   5986710.23998 2112596.1628099997 37.7800182322354 -122.48960543507401 (37.7800182322354, -122.489605435074)
114680 9251 3 37 6500X Geary Blvd 5 1 1 2   10/01/1993 12:00:00 AM 3 2X3   5986757.88302 2112599.10461 37.7800290909757 -122.489440834967 (37.7800290909757, -122.489440834967)
12677 26323 3 37 1925 San Jose Ave 1 1 1 2   02/23/2005 12:00:00 AM 3 2x2   6000135.6278 2092787.21241 37.7264023325969 -122.441739060413 (37.7264023325969, -122.441739060413)
20315 9992 3 37 67 Guerrero St 1 1 1 2   07/02/2014 12:00:00 AM 3 2x2   6005450.489519999 2108526.98568 37.7699215363694 -122.42448488798901 (37.7699215363694, -122.424484887989)
83481 104785 3 37 750 Holly Park Cir 1 11 1 2   12/21/2014 11:00:00 PM 3 2x2   6006276.6738599995 2096799.83163 37.7377680961975 -122.42079445065201 (37.7377680961975, -122.420794450652)
Powered by Datasette · Query took 67.634ms · Data source: data.sfgov.org