sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
11838 86566 3 12 2291 27th Ave 1 1 1 2   12/29/2006 12:00:00 AM 3 3x3   5987915.7374 2099735.4596 37.7447765661609 -122.484491558794 (37.7447765661609, -122.484491558794)
11840 86359 3 12 2471 25th Ave 1 1 1 2   12/18/2006 12:00:00 AM 3 3x3   5988580.1409 2098503.4453 37.7414324462154 -122.482103965972 (37.7414324462154, -122.482103965972)
11860 86029 3 12 1358 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987436.0953 2106019.4795 37.7620028444435 -122.486611370794 (37.7620028444435, -122.486611370794)
11870 25764 1 12 1686 Geneva Ave 1 1 1 1   01/15/1997 12:00:00 AM 16 2X3   6004225.91042 2087173.5217 37.7112205731354 -122.427199443002 (37.7112205731354, -122.427199443002)
11879 86555 3 12 1819 27th Ave 1 1 1 2   12/28/2006 12:00:00 AM 5 3x3   5987809.0175 2102882.3372 37.7534108357177 -122.48509141307 (37.7534108357177, -122.48509141307)
11890 86455 3 12 2274 27th Ave 1 1 1 2   12/28/2006 12:00:00 AM 3 3x3   5987957.131 2099832.7559 37.745046126390704 -122.484355563995 (37.7450461263907, -122.484355563995)
11902 86165 1 12 1351 24th Ave 3 1 1 8   01/19/2007 12:00:00 AM 3 3x3   5988632.0413 2106102.0394 37.762299176167495 -122.482481157841 (37.7622991761675, -122.482481157841)
11948 25355 1 12 600 Geneva Ave 2 1 1 1   12/21/2001 12:00:00 AM 8 2X3   5999172.673169999 2090392.4667 37.7197719989595 -122.44489586965099 (37.7197719989595, -122.444895869651)
11950 86142 3 12 1410 24th Ave 1 1 1 2   01/22/2007 12:00:00 AM 3 3x3   5988690.132999999 2105701.6052 37.761203071827296 -122.482250903757 (37.7612030718273, -122.482250903757)
11956 25368 1 12 1040 Geneva Ave 1 1 1 1   06/21/1996 12:00:00 AM 16 3X3   6000898.99381 2088714.73107 37.7152636858484 -122.438808440557 (37.7152636858484, -122.438808440557)
11980 86461 3 12 1878 27th Ave 1 1 1 2   12/28/2006 12:00:00 AM 3 3x3   5987868.3971 2102516.6759 37.75241028685029 -122.48485924507 (37.7524102868503, -122.48485924507)
12025 11599 3 12 4136 Judah St 1 1 1 2   04/24/2008 12:00:00 AM 3 3X3   5981645.3397 2105589.2786 37.7604823646112 -122.506607085828 (37.7604823646112, -122.506607085828)
12040 25473 3 12 1122 Geneva Ave 1 1 1 2   07/02/1996 12:00:00 AM 30 3x3   6001298.41093 2088479.30059 37.7146399619525 -122.4374110344 (37.7146399619525, -122.4374110344)
12052 86363 3 12 2519 25th Ave 1 1 1 2   12/18/2006 12:00:00 AM 3 3x3   5988589.8664 2098166.1552 37.7405069015373 -122.48204563583 (37.7405069015373, -122.48204563583)
12053 86242 3 12 2326 25th Ave 1 1 1 2   12/15/2006 12:00:00 AM 3 3x3   5988591.4394 2099475.9359999998 37.744103307456896 -122.48213612861 (37.7441033074569, -122.48213612861)
12062 86151 3 12 1258 24th Ave 1 1 1 2   01/22/2007 12:00:00 AM 3 3x3   5988650.5568 2106753.3083 37.7640884602726 -122.482464842862 (37.7640884602726, -122.482464842862)
12063 86239 3 12 2346 25th Ave 1 1 1 2   07/24/2014 12:00:00 AM 3 3x3   5988595.8369 2099352.8059 37.743765480375295 -122.48211190453699 (37.7437654803753, -122.482111904537)
12069 86348 3 12 2403 25th Ave 1 1 1 2   12/18/2006 12:00:00 AM 3 3x3   5988566.603999999 2098929.5183 37.7426015435709 -122.48218197906401 (37.7426015435709, -122.482181979064)
12083 25360 3 12 960 Geneva Ave 1 1 1 2   02/03/2016 08:23:00 AM 3 3x3   6000506.71785 2088949.98974 37.715887327923795 -122.440181174736 (37.7158873279238, -122.440181174736)
12095 86229 3 12 2442 25th Ave 1 1 1 2   12/15/2006 12:00:00 AM 3 3x3   5988619.7362 2098695.6689 37.741962544741604 -122.48198113875401 (37.7419625447416, -122.481981138754)
12097 86367 3 12 2591 25th Ave 1 1 1 2   12/18/2006 12:00:00 AM 3 3x3   5988607.7698 2097707.1537 37.739247644561296 -122.481950118341 (37.7392476445613, -122.481950118341)
12105 86556 3 12 1823 27th Ave 1 1 1 2   12/28/2006 12:00:00 AM 3 3x3   5987809.2575 2102855.2249 37.7533364066252 -122.485088594036 (37.7533364066252, -122.485088594036)
12123 86469 3 12 1826 27th Ave 1 1 1 2   12/28/2006 12:00:00 AM 6 3x3   5987859.0288 2102838.2592 37.7532927224365 -122.48491523213 (37.7532927224365, -122.48491523213)
12131 25371 1 12 1128 Geneva Ave 1 1 1 1   06/21/1996 12:00:00 AM 20 3X3   6001319.11795 2088467.3510200002 37.7146083282968 -122.437338607489 (37.7146083282968, -122.437338607489)
12134 86236 3 12 2366 25th Ave 1 1 1 2   12/15/2006 12:00:00 AM 3 3x3   5988600.911 2099212.4241 37.743380323988795 -122.482084077627 (37.7433803239888, -122.482084077627)
12166 25775 3 12 1965 Geneva Ave 1 1 1 2   02/07/1997 12:00:00 AM 16 2X3   6005734.23372 2086319.0681 37.708959607374 -122.42192563687999 (37.708959607374, -122.42192563688)
12181 86162 3 12 1325 24th Ave 1 1 1 2   01/19/2007 12:00:00 AM 8 3x3   5988625.5481 2106291.4256 37.7628188014042 -122.48251749296001 (37.7628188014042, -122.48251749296)
12188 86238 3 12 2350 25th Ave 1 1 1 2   12/15/2006 12:00:00 AM 3 3x3   5988597.8665 2099312.8901 37.74365600013439 -122.482101963137 (37.7436560001344, -122.482101963137)
12190 86161 3 12 1263 24th Ave 1 1 1 2   01/19/2007 12:00:00 AM 3 3x3   5988609.1983 2106737.2244 37.7640418922386 -122.482606709452 (37.7640418922386, -122.482606709452)
12207 25780 3 12 1679 Geneva Ave 1 1 1 2   12/11/1997 12:00:00 AM 16 2X3   6004231.29582 2087263.70147 37.711468491959295 -122.427187249092 (37.7114684919593, -122.427187249092)
12215 25370 1 12 1100 Geneva Ave 1 1 1 1   06/21/1996 12:00:00 AM 14 3X3   6001209.09194 2088530.7104900002 37.7147760437566 -122.43772343639401 (37.7147760437566, -122.437723436394)
12277 86341 3 12 2339 25th Ave 1 1 1 2   12/18/2006 12:00:00 AM 3 3x3   5988548.8369 2099394.3407 37.7438767902403 -122.48227745988999 (37.7438767902403, -122.48227745989)
12279 13336 3 12 201 Mansell St 3 1 1 2   10/10/1997 12:00:00 AM 9 3X3   6011177.6215699995 2090502.44045 37.720751792334205 -122.40340650860901 (37.7207517923342, -122.403406508609)
12301 15694 1 12 4200 Mission St 1 1 1 1   04/19/1995 12:00:00 AM 10 3x3   6003454.34297 2093966.93362 37.7298301192653 -122.430350548736 (37.7298301192653, -122.430350548736)
12312 86354 3 12 2443 25th Ave 1 1 1 2   12/18/2006 12:00:00 AM 3 3x3   5988573.3724 2098693.9767 37.741955201822705 -122.482141324018 (37.7419552018227, -122.482141324018)
12332 86155 3 12 1222 24th Ave 1 1 1 2   01/22/2007 12:00:00 AM 3 3x3   5988644.4296 2106981.5458 37.7647147817035 -122.482502759874 (37.7647147817035, -122.482502759874)
12358 86559 3 12 1883 27th Ave 1 1 1 2   12/28/2006 12:00:00 AM 3 3x3   5987822.6937 2102488.6083 37.7523305587422 -122.48501523391501 (37.7523305587422, -122.485015233915)
12363 92312 6 12 2711 34th Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985822.132 2096946.3119 37.7369961745626 -122.49152548244 (37.7369961745626, -122.49152548244)
12364 86241 3 12 2334 25th Ave 1 1 1 2   12/15/2006 12:00:00 AM 3 3x3   5988593.469 2099425.8721 37.743965963212204 -122.482125443827 (37.7439659632122, -122.482125443827)
12368 86224 3 12 2486X 25th Ave 2 1 1 2   12/15/2006 12:00:00 AM 3 3x3   5988630.9041 2098386.3513 37.74111388913521 -122.481919871057 (37.7411138891352, -122.481919871057)
12397 86340 3 12 2335 25th Ave 1 1 1 2   12/18/2006 12:00:00 AM 3 3x3   5988548.8369 2099418.3686 37.743942764529 -122.482279219959 (37.743942764529, -122.482279219959)
12428 86337 3 12 2319 25th Ave 1 1 1 2   12/18/2006 12:00:00 AM 3 3x3   5988545.1142 2099521.5873 37.744225959358396 -122.48229965301 (37.7442259593584, -122.48229965301)
12448 25779 3 12 1711 Geneva Ave 1 1 1 2   04/18/1997 12:00:00 AM 18 2X3   6004456.9664199995 2087146.9586900002 37.711160700777604 -122.426398965455 (37.7111607007776, -122.426398965455)
12456 86243 3 12 2322 25th Ave 1 1 1 2   12/15/2006 12:00:00 AM 3 3x3   5988592.116 2099499.2766 37.7441674339538 -122.482135498709 (37.7441674339538, -122.482135498709)
12459 25774 1 12 2027 Geneva Ave 1 1 1 1   02/07/1997 12:00:00 AM 16 2x3   6005967.118919999 2086230.6545099998 37.7087299735811 -122.42111447716299 (37.7087299735811, -122.421114477163)
12463 86457 3 12 2254 27th Ave 1 1 1 2   12/28/2006 12:00:00 AM 3 3x3   5987953.7171 2099943.2812 37.7453494007747 -122.484375473288 (37.7453494007747, -122.484375473288)
12470 86244 3 12 2314 25th Ave 1 1 1 2   12/15/2006 12:00:00 AM 3 3x3   5988589.7481 2099549.3405 37.7443047585161 -122.482147353295 (37.7443047585161, -122.482147353295)
12493 86464 3 12 1850 27th Ave 1 1 1 2   12/28/2006 12:00:00 AM 6 3x3   5987865.2759 2102688.9112 37.752883016880396 -122.484882672992 (37.7528830168804, -122.484882672992)
12519 25762 1 12 1676 Geneva Ave 1 1 1 1   01/15/1997 12:00:00 AM 18 2X3   6004168.351919999 2087205.26365 37.711304474489495 -122.427400639338 (37.7113044744895, -122.427400639338)
12533 25386 3 12 1217 Geneva Ave 1 1 1 2   06/25/1996 12:00:00 AM 25 3X3   6001760.84463 2088297.4882099999 37.714167024663894 -122.43579967681801 (37.7141670246639, -122.435799676818)
12541 86032 3 12 1318 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987424.9672 2106284.1357 37.7627288689785 -122.48666929207899 (37.7627288689785, -122.486669292079)
12559 29187 3 12 3109 Ortega St 6 1 1 2   03/18/2006 12:00:00 AM 3 3X3   5984347.8378 2102209.6716 37.7513616599003 -122.497011074793 (37.7513616599003, -122.497011074793)
12560 86352 3 12 2427 25th Ave 1 1 1 2   12/18/2006 12:00:00 AM 3 3x3   5988571.3419 2098778.2438 37.7421864590746 -122.48215451685499 (37.7421864590746, -122.482154516855)
12610 25367 1 12 1034 Geneva Ave 1 1 1 1   06/21/1996 12:00:00 AM 15 3x3   6000865.40343 2088735.44534 37.715318651499096 -122.438926026914 (37.7153186514991, -122.438926026914)
12623 86458 3 12 2226 27th Ave 1 1 1 2   12/28/2006 12:00:00 AM 3 3x3   5987945.6091 2100121.6579 37.7458387037388 -122.48441658969999 (37.7458387037388, -122.4844165897)
12632 86350 3 12 2409 25th Ave 1 1 1 2   12/18/2006 12:00:00 AM 3 3x3   5988567.6193 2098874.694 37.7424510694905 -122.482174452838 (37.7424510694905, -122.482174452838)
12638 86460 3 12 2214 27th Ave 1 1 1 2   12/28/2006 12:00:00 AM 3 3x3   5987944.7556 2100194.2034 37.746037844721705 -122.48442486087099 (37.7460378447217, -122.484424860871)
12650 25395 1 12 1039 Geneva Ave 1 1 1 1   06/27/1996 12:00:00 AM 15 3X3   6000907.995680001 2088802.01255 37.7155038534055 -122.438783577018 (37.7155038534055, -122.438783577018)
12655 25376 1 12 1276 Geneva Ave 1 1 1 1   08/04/1998 12:00:00 AM 18 3x3   6002007.30225 2088058.64573 37.713525212695295 -122.43493075454701 (37.7135252126953, -122.434930754547)
12666 25361 3 12 968 Geneva Ave 1 1 1 2   03/30/2013 12:00:00 AM 3 3x3   6000527.06071 2088936.736 37.7158520942878 -122.44010991066901 (37.7158520942878, -122.440109910669)
12684 86164 1 12 1351 24th Ave 2 1 1 8   01/19/2007 12:00:00 AM 3 3x3   5988630.418 2106137.2111 37.762395653655894 -122.482489349436 (37.7623956536559, -122.482489349436)
12689 86338 3 12 2323 25th Ave 1 1 1 2   12/18/2006 12:00:00 AM 3 3x3   5988544.4374 2099494.8519 37.74415251162289 -122.482300034785 (37.7441525116229, -122.482300034785)
12706 86349 3 12 2407 25th Ave 2 1 1 2   12/18/2006 12:00:00 AM 3 3x3   5988567.6193 2098909.213 37.7425458496029 -122.482176981212 (37.7425458496029, -122.482176981212)
12708 86044 3 12 1347 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987389.6474 2106093.022 37.762202064183896 -122.486777414544 (37.7622020641839, -122.486777414544)
12719 25392 1 12 1063 Geneva Ave 1 1 1 1   12/17/1997 12:00:00 AM 14 3X3   6001061.933019999 2088709.29333 37.7152580237143 -122.438244863328 (37.7152580237143, -122.438244863328)
12745 86023 3 12 1422 28th Ave 1 1 1 2   01/04/2007 12:00:00 AM 3 3x3   5987448.5891 2105584.2307 37.7608084988449 -122.486536201474 (37.7608084988449, -122.486536201474)
12759 29190 3 12 3109 Ortega St 3 1 1 2   03/18/2006 12:00:00 AM 3 3X3   5984243.2655 2102205.949 37.751345310189706 -122.49737241758001 (37.7513453101897, -122.49737241758)
12776 86346 3 12 2385 25th Ave 1 1 1 2   12/18/2006 12:00:00 AM 3 3x3   5988558.6511 2099117.5116 37.7431172612038 -122.48222324762399 (37.7431172612038, -122.482223247624)
12778 29173 3 12 3311 Ortega St 4 1 1 2   03/18/2006 12:00:00 AM 3 3x3   5983664.9026 2102188.6895 37.7512640052924 -122.499371156123 (37.7512640052924, -122.499371156123)
12780 93409 3 12 1444 Taraval St 1 1 1 2   06/16/2015 10:28:00 AM 3 3x3   5988655.8798 2099025.5303 37.7428703596386 -122.481880324493 (37.7428703596386, -122.481880324493)
12781 86153 3 12 1242 24th Ave 1 1 1 2   01/22/2007 12:00:00 AM 3 3x3   5988649.025 2106860.534 37.7643827836745 -122.482477998167 (37.7643827836745, -122.482477998167)
12787 86028 3 12 1362 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987436.5792 2105997.2232 37.761941762959204 -122.486608062939 (37.7619417629592, -122.486608062939)
12820 86177 3 12 1523 24th Ave 1 1 1 2   01/19/2007 12:00:00 AM 3 3x3   5988670.915 2104946.7047 37.7591292016425 -122.482262060171 (37.7591292016425, -122.482262060171)
12823 86467 3 12 1834 27th Ave 1 1 1 2   12/28/2006 12:00:00 AM 3 3x3   5987860.8339 2102786.7134 37.7531512966831 -122.484905208537 (37.7531512966831, -122.484905208537)
12892 98234 2 12 1714 24th Ave 1 1 1 1     20 7x3.5   5988761.0773 2103624.0997 37.7555029284864 -122.481853358314 (37.7555029284864, -122.481853358314)
12895 25384 1 12 1247 Geneva Ave 1 1 1 1   06/25/1996 12:00:00 AM 23 3X3   6001863.38565 2088237.0164599998 37.7140068068465 -122.435440932771 (37.7140068068465, -122.435440932771)
12899 86134 3 12 1596 24th Ave 1 1 1 2   01/18/2007 12:00:00 AM 3 3x3   5988728.7146 2104493.0502 37.7578869506911 -122.48202893064301 (37.7578869506911, -122.482028930643)
12908 86553 3 12 1811 27th Ave 1 1 1 2   12/28/2006 12:00:00 AM 3 3x3   5987806.7158 2102929.3806 37.7535398701446 -122.48510282406299 (37.7535398701446, -122.485102824063)
12925 25778 3 12 1707 Geneva Ave 1 1 1 2   04/18/1997 12:00:00 AM 18 2X3   6004431.84726 2087156.7380099997 37.711186132712704 -122.426486479377 (37.7111861327127, -122.426486479377)
12937 86035 3 12 1256 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987412.9292 2106732.5029 37.7639592601802 -122.48674385238701 (37.7639592601802, -122.486743852387)
12955 86136 3 12 1566 24th Ave 1 1 1 2   01/18/2007 12:00:00 AM 3 3x3   5988723.3718 2104672.7634 37.758380083924706 -122.482060573277 (37.7583800839247, -122.482060573277)
12966 86459 3 12 2218 27th Ave 1 1 1 2   12/28/2006 12:00:00 AM 3 3x3   5987944.3289 2100172.8665 37.7459792344128 -122.48442477163799 (37.7459792344128, -122.484424771638)
12979 86019 3 12 1546 28th Ave 1 1 1 2   01/04/2007 12:00:00 AM 3 3x3   5987476.0557 2104753.7682 37.758529876731295 -122.486380235963 (37.7585298767313, -122.486380235963)
13020 87559 3 12 4135 Judah St 1 1 1 2   02/24/2008 12:00:00 AM 3 3x3   5981638.7597 2105526.7098 37.7603101811501 -122.506625202077 (37.7603101811501, -122.506625202077)
13024 86353 3 12 2439 25th Ave 1 1 1 2   12/18/2006 12:00:00 AM 3 3x3   5988572.3572 2098719.3584 37.7420248342665 -122.482146693274 (37.7420248342665, -122.482146693274)
13105 86055 3 12 1483 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987419.9015 2105210.8874 37.7597817279749 -122.486608004107 (37.7597817279749, -122.486608004107)
13107 86143 3 12 1390 24th Ave 1 1 1 2   01/22/2007 12:00:00 AM 3 3x3   5988682.364 2105874.2348 37.76167661395021 -122.482290421416 (37.7616766139502, -122.482290421416)
13152 86021 3 12 1514 28th Ave 1 1 1 2   01/04/2007 12:00:00 AM 3 3x3   5987469.9607 2104957.5126 37.759088948014394 -122.486416273524 (37.7590889480144, -122.486416273524)
13155 86150 3 12 1266 24th Ave 1 1 1 2   01/22/2007 12:00:00 AM 3 3x3   5988655.1522 2106702.759 37.7639499330102 -122.482445244797 (37.7639499330102, -122.482445244797)
13171 28793 1 12 1419 Silver Ave 1 1 1 1   03/17/2006 12:00:00 AM 3 3X3   6009776.96073 2094487.8719 37.73161661799121 -122.408529172889 (37.7316166179912, -122.408529172889)
13187 106199 2 12 2107 42nd Ave 1 1 1 1 1   4 3x4   5983225.8003 2100763.9337 37.74732624942661 -122.500784246807 (37.7473262494266, -122.500784246807)
13188 28810 3 12 945 Silver Ave 2 1 1 2     10 2X3   6007406.03432 2093542.49389 37.7288877484642 -122.416659008228 (37.7288877484642, -122.416659008228)
13201 86057 3 12 1559 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987436.4387 2104667.1333 37.758289691643796 -122.48651088669399 (37.7582896916438, -122.486510886694)
13207 13370 1 12 900 Mansell St 3 1 1 1   01/28/2003 12:00:00 AM 10 3X50   6009179.45689 2090013.7342599998 37.719298099396894 -122.410279089032 (37.7192980993969, -122.410279089032)
13229 86456 3 12 2270 27th Ave 1 1 1 2   12/28/2006 12:00:00 AM 3 3x3   5987955.8508 2099858.787 37.7451175263471 -122.484361899482 (37.7451175263471, -122.484361899482)
13593 24443 3 12 1900 03rd St 23 1 1 2   03/11/2007 12:00:00 AM 3 3X3   6015653.1254 2106493.0518799997 37.7649076765652 -122.389051837691 (37.7649076765652, -122.389051837691)
14175 21877 3 12 1900 03rd St 19 1 1 2   01/25/1995 12:00:00 AM 3 3X3   6015647.435959999 2106591.54612 37.7651778050355 -122.389078393773 (37.7651778050355, -122.389078393773)
14201 21879 3 12 1900 03rd St 21 1 1 2   01/25/1995 12:00:00 AM 3 3X3   6015650.0093 2106548.41403 37.765059516307296 -122.38906648134599 (37.7650595163073, -122.389066481346)
14273 14873 3 12 1409 McKinnon Ave 1 1 1 2   03/28/2006 12:00:00 AM 12 3X3   6016102.3381 2095358.409 37.734359155897295 -122.386721579123 (37.7343591558973, -122.386721579123)
14304 110654 1 12 500 De Haro St 1 1 1 1 1 04/29/2015 12:00:00 AM 3 3x3   6012037.262709999 2106026.3006599997 37.763424983208 -122.40152545783 (37.763424983208, -122.40152545783)
14321 26558 3 12 360 Bay Shore Blvd 1 1 1 2   01/29/1998 12:00:00 AM 6 3X3   6010529.85553 2098274.12498 37.742054996855394 -122.40619291319099 (37.7420549968554, -122.406192913191)
Powered by Datasette · Query took 39.576ms · Data source: data.sfgov.org