sf-trees

Data source: data.sfgov.org

Custom SQL query returning 69 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1083 108357 1 52 250X Pixley St 2 1 1 11   12/17/2014 12:00:00 AM 3 2x4 Permit Number 773698 6002140.21513 2118970.4470599997 37.7984091333207 -122.436682703142 (37.7984091333207, -122.436682703142)
2633 108358 1 52 250X Pixley St 3 1 1 11   12/17/2014 12:00:00 AM 3 2x4 Permit Number 773698 6002123.0245900005 2118966.98612 37.798398653541796 -122.43674193970399 (37.7983986535418, -122.436741939704)
3074 199930 1 79 1801 Ingalls St 4 1 1 11   02/28/2006 12:00:00 AM 6 Width 0ft   6016497.9258 2092921.8231 37.727690668221506 -122.385184171361 (37.7276906682215, -122.385184171361)
3081 199928 1 79 1801 Ingalls St 2 1 1 11   02/27/2008 12:00:00 AM 4 Width 0ft   6016476.4427 2092884.9162 37.727588140695204 -122.385255868852 (37.7275881406952, -122.385255868852)
3082 199927 1 79 1801 Ingalls St 1 1 1 11   02/28/2006 12:00:00 AM 5 Width 0ft   6016464.324 2092869.4925 37.7275451198245 -122.385296689415 (37.7275451198245, -122.385296689415)
3105 199929 1 79 1801 Ingalls St 3 1 1 11   02/28/2006 12:00:00 AM 6 Width 0ft   6016487.4596 2092903.0942 37.727638663365 -122.385219049049 (37.727638663365, -122.385219049049)
7958 108356 1 52 250X Pixley St 1 1 1 11   12/17/2014 12:00:00 AM 3 2x4 Permit Number 773698 6002158.91155 2118972.60439 37.798416119273206 -122.436618162405 (37.7984161192732, -122.436618162405)
13443 14968 1 60 400X Mendell St 1 1 1 11     12 3X3   6016667.040519999 2097697.80462 37.7408139135396 -122.384932128834 (37.7408139135396, -122.384932128834)
13712 6809 1 91 1400X Fairfax Ave 1 1 1 11   12/19/2000 12:00:00 AM 6 3X3   6016539.9784699995 2097547.42551 37.7403939741954 -122.385360989424 (37.7403939741954, -122.385360989424)
13725 14972 1 60 400X Mendell St 5 1 1 11     12 3X3   6016621.68773 2097636.5481 37.740643206920204 -122.385084676324 (37.7406432069202, -122.385084676324)
14309 14975 1 97 400X Mendell St 8 1 1 11     12 3x3   6016578.93942 2097580.627 37.7404872941606 -122.38522858943001 (37.7404872941606, -122.38522858943)
14941 6814 1 32 1400X Fairfax Ave 6 1 1 11     12 3X3   6016451.12132 2097615.70854 37.7405765491786 -122.38567298313801 (37.7405765491786, -122.385672983138)
15048 6813 1 21 1400X Fairfax Ave 5 1 1 11   12/15/1998 12:00:00 AM 6 3X3   6016463.58165 2097607.01609 37.740553370940106 -122.38562929405799 (37.7405533709401, -122.385629294058)
15227 6810 1 91 1400X Fairfax Ave 2 1 1 11   03/30/2006 12:00:00 AM 3 3X3   6016518.03729 2097563.6173900003 37.74043721991 -122.38543798216999 (37.74043721991, -122.38543798217)
15295 6623 1 44 1415 Evans Ave 6 1 1 11     18 3x3   6016531.01979 2097819.1041099997 37.7411394528345 -122.385410892796 (37.7411394528345, -122.385410892796)
15389 6625 1 44 1415 Evans Ave 8 1 1 11   11/24/1998 12:00:00 AM 6 3x3   6016564.1874 2097795.2525 37.7410757961225 -122.385294548421 (37.7410757961225, -122.385294548421)
15805 6811 1 21 1400X Fairfax Ave 3 1 1 11   03/30/2006 12:00:00 AM 3 3X3   6016498.596480001 2097579.9662200003 37.7404810348687 -122.38550634055599 (37.7404810348687, -122.385506340556)
15813 14969 1 60 400X Mendell St 2 1 1 11     12 3x3   6016654.44168 2097681.89431 37.7407695301847 -122.38497458311501 (37.7407695301847, -122.384974583115)
15881 6819 1 32 1400X Fairfax Ave 11 1 1 11     12 3X3   6016343.96785 2097693.33127 37.7407837556653 -122.386048891651 (37.7407837556653, -122.386048891651)
16016 6627 1 44 1415 Evans Ave 10 1 1 11   11/24/1998 12:00:00 AM 6 3x3   6016607.54293 2097762.50213 37.740988268684895 -122.385142357926 (37.7409882686849, -122.385142357926)
16096 14971 1 76 400X Mendell St 4 1 1 11   02/25/2008 12:00:00 AM 3 3X3   6016631.74011 2097650.02311 37.740680762618396 -122.385050857322 (37.7406807626184, -122.385050857322)
16138 14974 1 97 400X Mendell St 7 1 1 11     12 3X3   6016589.22096 2097595.13367 37.7405276953073 -122.385194050084 (37.7405276953073, -122.385194050084)
16378 6624 1 44 1415 Evans Ave 7 1 1 11   02/04/2004 12:00:00 AM 3 3x3   6016547.14534 2097807.00624 37.7411071266849 -122.385354293091 (37.7411071266849, -122.385354293091)
16652 14973 1 60 400X Mendell St 6 1 1 11     12 3X3   6016605.91834 2097618.21478 37.740591995028 -122.385137924278 (37.740591995028, -122.385137924278)
16668 6626 1 44 1415 Evans Ave 9 1 1 11   11/24/1998 12:00:00 AM 6 3x3   6016580.825619999 2097781.51455 37.741038994951204 -122.38523606192 (37.7410389949512, -122.38523606192)
16680 14970 1 60 400X Mendell St 3 1 1 11     18 3x3   6016646.28629 2097669.62437 37.740735388316395 -122.385001926999 (37.7407353883164, -122.385001926999)
16744 6812 1 5 1400X Fairfax Ave 4 1 1 11   12/19/2000 12:00:00 AM 6 3X3   6016477.270719999 2097595.73141 37.740523142935096 -122.385581175844 (37.7405231429351, -122.385581175844)
53801 6629 1 5 1415 Evans Ave 12 1 1 11   05/16/2013 12:00:00 AM 17 4x4   6016652.34226 2097729.17939 37.7408992492988 -122.38498513575001 (37.7408992492988, -122.38498513575)
77710 6828 1 43 1450X Fairfax Ave 10 1 1 11     12 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.38617968089301 (37.740834465841, -122.386179680893)
77797 116382 1 21 2501 25th St 3 1 1 11 2     3x3   6011435.88896489 2101815.42613948 37.7518292809831 -122.403309184671 (37.7518292809831, -122.403309184671)
79905 6621 1 5 1415 Evans Ave 4 1 1 11     18 3x3   6016617.7688071 2097746.8662364 37.740945901362 -122.385105911093 (37.740945901362, -122.385105911093)
80931 29508 1 11 1850X Ingalls St 2 1 1 11   02/28/2006 12:00:00 AM 3 3x3   6016520.1701445 2092944.0657869 37.727752972771604 -122.385108820711 (37.7277529727716, -122.385108820711)
81179 6632 1 5 1415 Evans Ave 15 1 1 11     18 3x3   6016617.7688071 2097746.8662364 37.740945901362 -122.385105911093 (37.740945901362, -122.385105911093)
81436 6830 1 91 1450X Fairfax Ave 12 1 1 11   12/19/2000 12:00:00 AM 6 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.38617968089301 (37.740834465841, -122.386179680893)
83488 6826 1 91 1450X Fairfax Ave 8 1 1 11   12/19/2000 12:00:00 AM 6 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.38617968089301 (37.740834465841, -122.386179680893)
84017 6816 1 43 1400X Fairfax Ave 8 1 1 11     12 3X3   6016560.821272099 2097522.8211505003 37.740327568702895 -122.385287208511 (37.7403275687029, -122.385287208511)
84330 111073 2 19 1450 IRVING ST 2 5 1 11       3x3   5991201.0 2106639.0 37.7639226370674 -122.473635352969 (37.7639226370674, -122.473635352969)
86601 27299 1 71 7800X Geary Blvd 6 11 1 11   06/10/1999 12:00:00 AM 6 5X5   5982630.17797 2112395.09735 37.779227117259296 -122.503705073784 (37.7792271172593, -122.503705073784)
87748 29455 1 11 1809X Ingalls St 1 1 1 11   02/28/2006 12:00:00 AM 12 3X3   6016520.1701445 2092944.0657869 37.727752972771604 -122.385108820711 (37.7277529727716, -122.385108820711)
88255 29451 1 11 1829X Ingalls St 1 1 1 11   02/28/2006 12:00:00 AM 12 3X3   6016488.0524002 2092900.9411781002 37.7276327843847 -122.385216849755 (37.7276327843847, -122.385216849755)
88375 29457 1 11 1809X Ingalls St 3 1 1 11   02/28/2006 12:00:00 AM 12 3x3   6016492.91829 2092912.51025 37.7276648199576 -122.38520083393 (37.7276648199576, -122.38520083393)
89314 67338 1 21 2501 25th St 1 1 1 11 2 07/22/1992 12:00:00 AM   3x3 Permit Number 30822 6011435.88896489 2101815.42613948 37.7518292809831 -122.403309184671 (37.7518292809831, -122.403309184671)
91196 29453 1 11 1829X Ingalls St 3 1 1 11   02/28/2006 12:00:00 AM 12 3X3   6016488.0524002 2092900.9411781002 37.7276327843847 -122.385216849755 (37.7276327843847, -122.385216849755)
92056 27295 1 71 7800X Geary Blvd 2 11 1 11   06/10/1999 12:00:00 AM 6 5X5   5982729.47953 2112398.50568 37.779242313567295 -122.50336180684499 (37.7792423135673, -122.503361806845)
93388 29509 1 11 1850X Ingalls St 3 1 1 11   02/28/2006 12:00:00 AM 12 3x3   6016520.1701445 2092944.0657869 37.727752972771604 -122.385108820711 (37.7277529727716, -122.385108820711)
104221 6822 1 91 1450X Fairfax Ave 3 1 1 11   03/30/2006 12:00:00 AM 3 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.38617968089301 (37.740834465841, -122.386179680893)
104985 27857 1 43 1450X Fairfax Ave 7 1 1 11     12 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.38617968089301 (37.740834465841, -122.386179680893)
105097 29454 1 11 1829X Ingalls St 4 1 1 11   02/28/2006 12:00:00 AM 8 3X3   6016488.0524002 2092900.9411781002 37.7276327843847 -122.385216849755 (37.7276327843847, -122.385216849755)
108134 6817 1 43 1400X Fairfax Ave 9 1 1 11     12 3X3   6016560.821272099 2097522.8211505003 37.740327568702895 -122.385287208511 (37.7403275687029, -122.385287208511)
109299 29456 1 11 1809X Ingalls St 2 1 1 11   02/27/2008 12:00:00 AM 3 3X3   6016520.1701445 2092944.0657869 37.727752972771604 -122.385108820711 (37.7277529727716, -122.385108820711)
109571 6823 1 21 1450X Fairfax Ave 5 1 1 11   03/30/2006 12:00:00 AM 3 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.38617968089301 (37.740834465841, -122.386179680893)
111288 27297 1 71 7800X Geary Blvd 4 11 1 11   06/10/1999 12:00:00 AM 6 5X5   5982680.863919999 2112396.64212 37.7792343387449 -122.50352984750401 (37.7792343387449, -122.503529847504)
113663 29507 1 11 1850X Ingalls St 1 1 1 11   02/28/2006 12:00:00 AM 16 3x3   6016520.1701445 2092944.0657869 37.727752972771604 -122.385108820711 (37.7277529727716, -122.385108820711)
114112 27296 1 71 7800X Geary Blvd 3 11 1 11   06/10/1999 12:00:00 AM 6 5X5   5982703.46074 2112397.7930900003 37.7792388274313 -122.50345176232 (37.7792388274313, -122.50345176232)
117415 6829 1 43 1450X Fairfax Ave 11 1 1 11     12 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.38617968089301 (37.740834465841, -122.386179680893)
118421 6831 1 21 1450X Fairfax Ave 14 1 1 11   03/30/2006 12:00:00 AM 3 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.38617968089301 (37.740834465841, -122.386179680893)
118616 6824 1 5 1450X Fairfax Ave 4 1 1 11     18 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.38617968089301 (37.740834465841, -122.386179680893)
122437 29452 1 11 1829X Ingalls St 2 1 1 11   02/28/2006 12:00:00 AM 12 3X3   6016488.0524002 2092900.9411781002 37.7276327843847 -122.385216849755 (37.7276327843847, -122.385216849755)
124744 6820 1 91 1450X Fairfax Ave 1 1 1 11   12/19/2000 12:00:00 AM 3 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.38617968089301 (37.740834465841, -122.386179680893)
125546 27294 1 71 7800X Geary Blvd 1 11 1 11   02/12/2001 12:00:00 AM 6 5X5   5982752.16339 2112399.44122 37.77924621575129 -122.503283404585 (37.7792462157513, -122.503283404585)
126966 6825 1 43 1450X Fairfax Ave 6 1 1 11     12 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.38617968089301 (37.740834465841, -122.386179680893)
127073 6827 1 91 1450X Fairfax Ave 9 1 1 11   12/19/2000 12:00:00 AM 6 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.38617968089301 (37.740834465841, -122.386179680893)
128442 29458 1 11 1809X Ingalls St 4 1 1 11   02/28/2006 12:00:00 AM 12 3X3   6016520.1701445 2092944.0657869 37.727752972771604 -122.385108820711 (37.7277529727716, -122.385108820711)
128827 6631 1 5 1415 Evans Ave 14 1 1 11   02/15/2001 12:00:00 AM 18 3x3   6016617.7688071 2097746.8662364 37.740945901362 -122.385105911093 (37.740945901362, -122.385105911093)
128886 6821 1 91 1450X Fairfax Ave 2 1 1 11   12/19/2000 12:00:00 AM 3 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.38617968089301 (37.740834465841, -122.386179680893)
139108 6818 1 43 1400X Fairfax Ave 10 1 1 11     12 3X3   6016560.821272099 2097522.8211505003 37.740327568702895 -122.385287208511 (37.7403275687029, -122.385287208511)
143978 27298 1 71 7800X Geary Blvd 5 11 1 11   06/10/1999 12:00:00 AM 6 5X5   5982658.07107 2112395.9042 37.7792309725957 -122.503608641413 (37.7792309725957, -122.503608641413)
145043 6815 1 43 1400X Fairfax Ave 7 1 1 11     12 3X3   6016560.821272099 2097522.8211505003 37.740327568702895 -122.385287208511 (37.7403275687029, -122.385287208511)
145895 111072 2 19 1450 IRVING ST 1 5 1 11       3x3   5991277.0 2106586.0 37.7637815143869 -122.473368628437 (37.7637815143869, -122.473368628437)
Powered by Datasette · Query took 2.153ms · Data source: data.sfgov.org