sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
19325 25154 3 100 50X Dolores St 2 11 1 2     90 20   6004786.45589 2107937.0696900003 37.7682642477152 -122.42673975183901 (37.7682642477152, -122.426739751839)
19333 24968 3 100 100 Dolores St 9 11 1 2     90 20   6004810.58196 2107534.1310400004 37.767159239034704 -122.426627605497 (37.7671592390347, -122.426627605497)
19334 24962 3 100 100 Dolores St 3 11 1 2   04/21/2005 12:00:00 AM 30 20   6004805.8872 2107667.07109 37.76752399506629 -122.42665331171999 (37.7675239950663, -122.42665331172)
19402 25141 3 100 1750X Dolores St 7 11 1 2     70 20   6005346.329580001 2097965.45382 37.740916150253604 -122.424093974258 (37.7409161502536, -122.424093974258)
19415 25531 3 100 2300X Market St 6 11 1 2   04/01/1993 12:00:00 AM 36 10   6002640.0878 2106231.2379 37.763458864653295 -122.434041867896 (37.7634588646533, -122.434041867896)
19480 25039 3 100 800X Dolores St 3 11 1 2     90 20   6005035.06937 2103531.66337 37.756182099743 -122.42556624900801 (37.756182099743, -122.425566249008)
19492 25148 3 100 2X Dolores St 1 11 1 2     80 20   6004781.85822 2108123.31219 37.7687753648286 -122.426768919571 (37.7687753648286, -122.426768919571)
19585 24338 3 100 2020X Market St 1 11 1 2   05/07/1993 12:00:00 AM 36 8   6004443.4589 2107950.1478 37.76828075872071 -122.42792707731 (37.7682807587207, -122.42792707731)
19587 25088 3 100 1250X Dolores St 3 11 1 2     90 20   6005178.85274 2100929.77786 37.7490460494561 -122.424883892899 (37.7490460494561, -122.424883892899)
19629 25032 3 100 750X Dolores St 7 11 1 2     70 20   6005021.65336 2103769.84125 37.756835322312604 -122.42562959723 (37.7568353223126, -122.42562959723)
19687 25091 3 100 1350 Dolores St 1 11 1 2     80 20   6005204.68058 2100428.03656 37.7476698420965 -122.42475889070299 (37.7476698420965, -122.424758890703)
19785 25785 1 100 500X The Embarcadero 4 11 1 9   08/30/1996 12:00:00 AM 36 10   6013445.7547399 2119056.6213273997 37.7992817461076 -122.39756784649201 (37.7992817461076, -122.397567846492)
19826 24965 3 100 100 Dolores St 6 11 1 2     90 20   6004804.04595 2107595.6918 37.767327900586 -122.42665459683799 (37.767327900586, -122.426654596838)
19946 25514 3 100 2100X Market St 1 11 1 2   04/01/1993 12:00:00 AM 36 10   6004037.0875 2107573.3112 37.7672230586461 -122.429305801661 (37.7672230586461, -122.429305801661)
19960 25156 3 100 50X Dolores St 4 11 1 2     90 20   6004792.45266 2107880.8578 37.768110242434204 -122.426715006093 (37.7681102424342, -122.426715006093)
19989 25018 3 100 750X Dolores St 3 11 1 2     70 20   6005012.95019 2103889.3731400003 37.757163037054 -122.42566820334 (37.757163037054, -122.42566820334)
20060 25500 3 100 1745X Market St 5 11 1 2   04/01/1993 12:00:00 AM 24 20   6005964.12554 2109421.56816 37.7724068380339 -122.422771813485 (37.7724068380339, -122.422771813485)
20149 25149 3 100 2X Dolores St 2 11 1 2     90 20x10   6004775.29887 2108114.09165 37.768749676587205 -122.42679095116002 (37.7687496765872, -122.42679095116)
20169 24997 3 100 400X Dolores St 2 11 1 2   10/04/1999 12:00:00 AM 70 20   6004897.70828 2105945.4375400003 37.7628019913498 -122.426213130441 (37.7628019913498, -122.426213130441)
20197 25001 3 100 400X Dolores St 6 11 1 2     90 20   6004908.3831400005 2105867.13213 37.7625875866685 -122.426170634793 (37.7625875866685, -122.426170634793)
20270 25000 3 100 450X Dolores St 5 11 1 2     90 20   6004920.85287 2105575.60223 37.761787819564205 -122.42610675143801 (37.7617878195642, -122.426106751438)
20326 25115 3 100 1550X Dolores St 2 11 1 2     90 20   6005272.16967 2099229.32207 37.7443822579348 -122.424440267208 (37.7443822579348, -122.424440267208)
20343 25533 3 100 2300X Market St 8 11 1 2   04/01/1993 12:00:00 AM 36 10   6002574.775 2106170.8945 37.7632894694666 -122.43426344933201 (37.7632894694666, -122.434263449332)
20414 25529 3 100 2300X Market St 4 11 1 2   04/01/1993 12:00:00 AM 36 10   6002679.8435 2106267.4439 37.7635605336875 -122.43390695394699 (37.7635605336875, -122.433906953947)
20422 24978 3 100 270 Dolores St 5 11 1 2     90 20   6004857.55515 2106727.96369 37.764948352008 -122.42640772573601 (37.764948352008, -122.426407725736)
20452 24966 3 100 100 Dolores St 7 11 1 2     90 20   6004812.73188 2107584.41194 37.76729741985871 -122.426623750096 (37.7672974198587, -122.426623750096)
20599 25518 3 100 2100X Market St 5 11 1 2   04/01/1993 12:00:00 AM 36 10   6003909.9867 2107446.2105 37.7668668744555 -122.429736358347 (37.7668668744555, -122.429736358347)
20628 25499 3 100 1745X Market St 4 11 1 2   04/01/1993 12:00:00 AM 24 20   6005915.63153 2109374.76445 37.772275590069796 -122.42293623203999 (37.7722755900698, -122.42293623204)
20630 24974 3 100 200 Dolores St 1 11 1 2     90 20   6004833.67989 2107139.93189 37.7660781684855 -122.426519640982 (37.7660781684855, -122.426519640982)
20678 25137 3 100 1700X Dolores St 3 11 1 2     90 20   6005325.6404800005 2098301.13362 37.7418366828201 -122.424189377061 (37.7418366828201, -122.424189377061)
20697 24979 3 100 270 Dolores St 6 11 1 2     90 20   6004857.886419999 2106701.08852 37.7648745779366 -122.426404666261 (37.7648745779366, -122.426404666261)
20703 24999 3 100 400X Dolores St 4 11 1 2     90 20   6004906.6428 2105904.72298 37.7626907038434 -122.42617933032899 (37.7626907038434, -122.426179330329)
20710 24340 3 100 2000X Market St 4 11 1 2   05/07/1993 12:00:00 AM 36 8   6004586.5088 2108095.7522 37.7686886449818 -122.42744265544201 (37.7686886449818, -122.427442655442)
20716 25082 3 100 1200X Dolores St 2 11 1 2     90 20   6005158.72228 2101250.83835 37.7499264704292 -122.424976344106 (37.7499264704292, -122.424976344106)
20762 25074 3 100 1100X Dolores St 5 11 1 2     70 20   6005132.37065 2101712.1567700002 37.751191655576 -122.425100289545 (37.751191655576, -122.425100289545)
20790 25095 3 100 1300 Dolores St 5 11 1 2     80 20   6005196.77931 2100544.39428 37.7479888873864 -122.424794489489 (37.7479888873864, -122.424794489489)
20817 25112 3 100 1450 Dolores St 5 11 1 2     90 20   6005235.506709999 2099747.61613 37.7458033045753 -122.42460390154699 (37.7458033045753, -122.424603901547)
20879 25092 3 100 1300 Dolores St 2 11 1 2     80 20   6005189.02223 2100681.47449 37.7483648399821 -122.424831064022 (37.7483648399821, -122.424831064022)
20892 25110 3 100 1450 Dolores St 3 11 1 2     90 20   6005236.31225 2099800.23492 37.7459478292265 -122.42460485845301 (37.7459478292265, -122.424604858453)
20929 25087 3 100 1250X Dolores St 2 11 1 2     90 20   6005179.035519999 2100967.22192 37.7491488725392 -122.42488592444401 (37.7491488725392, -122.424885924444)
20953 25048 3 100 900X Dolores St 3 11 1 2     30 20   6005066.31799 2102985.06573 37.7546830360144 -122.425419283594 (37.7546830360144, -122.425419283594)
21135 25089 3 100 1250X Dolores St 4 11 1 2     90 20   6005180.26353 2100884.10883 37.748920732509 -122.424875765702 (37.748920732509, -122.424875765702)
21187 25519 3 100 2100X Market St 6 11 1 2   04/01/1993 12:00:00 AM 36 10   6003894.4866 2107428.3854 37.7668170533219 -122.42978869913401 (37.7668170533219, -122.429788699134)
21311 25022 3 100 700X Dolores St 7 11 1 2     70 20   6004995.79572 2104126.38242 37.75781283950229 -122.425744399279 (37.7578128395023, -122.425744399279)
21387 25517 3 100 2190X Market St 4 11 1 2   04/01/1993 12:00:00 AM 36 10   6003660.4353 2107205.9591 37.7661930680529 -122.43058237071199 (37.7661930680529, -122.430582370712)
21388 25107 3 100 1400X Dolores St 7 11 1 2     70 20   6005229.6240300005 2099972.88313 37.7464215039571 -122.424640264758 (37.7464215039571, -122.424640264758)
21419 25138 3 100 1700X Dolores St 4 11 1 2     90 20   6005319.278030001 2098285.9295200002 37.7417945765605 -122.424210295287 (37.7417945765605, -122.424210295287)
21421 25497 3 100 1745X Market St 2 11 1 2   04/01/1993 12:00:00 AM 24 20   6005883.25661 2109339.92737 37.7721781089695 -122.42304574337099 (37.7721781089695, -122.423045743371)
21445 25496 3 100 1745X Market St 1 11 1 2   04/01/1993 12:00:00 AM 24 20   6005866.13841 2109325.7941099997 37.772138336447 -122.42310395199499 (37.772138336447, -122.423103951995)
21453 25004 3 100 400X Dolores St 10 11 1 2     60 20   6004910.30478 2105777.27345 37.762340964691504 -122.42615759100599 (37.7623409646915, -122.426157591006)
21462 25153 3 100 50X Dolores St 1 11 1 2     90 20   6004788.48534 2107965.7019599997 37.768342979778204 -122.426734771418 (37.7683429797782, -122.426734771418)
21503 25093 3 100 1300 Dolores St 3 11 1 2     80 20   6005193.32199 2100633.40551 37.7482330964805 -122.424812776293 (37.7482330964805, -122.424812776293)
21512 25120 3 100 1550 Dolores St 1 11 1 2     90 20   6005269.99247 2099258.02767 37.744460954018 -122.424449836913 (37.744460954018, -122.424449836913)
21602 25126 3 100 1650X Dolores St 2 11 1 2     40 20   6005303.102530001 2098649.37036 37.7427915892743 -122.424292067924 (37.7427915892743, -122.424292067924)
21632 25036 3 100 750X Dolores St 5 11 1 2     90 20   6005017.04415 2103831.36773 37.7570039991458 -122.42564991650801 (37.7570039991458, -122.425649916508)
21636 24991 3 100 340 Dolores St 2 11 1 2     90 20   6004880.84753 2106292.81252 37.763754847342206 -122.42629617923299 (37.7637548473422, -122.426296179233)
21721 25072 3 100 1100X Dolores St 3 11 1 2     80 20   6005130.36391 2101800.2565200003 37.751433443721 -122.425113497011 (37.751433443721, -122.425113497011)
21723 25536 3 100 2200X Market St 2 11 1 2   04/01/1993 12:00:00 AM 36 20   6003342.0906 2106904.3991 37.7653470177984 -122.43166193058599 (37.7653470177984, -122.431661930586)
21747 25537 3 100 2200X Market St 3 11 1 2   04/01/1993 12:00:00 AM 36 20   6003301.0095 2106860.3121 37.7652236369165 -122.43180087233601 (37.7652236369165, -122.431800872336)
21757 25064 3 100 1000X Dolores St 7 11 1 2     40 20   6005102.4225699995 2102227.07793 37.7526038178156 -122.425240490271 (37.7526038178156, -122.425240490271)
21853 25535 3 100 2200X Market St 1 11 1 2   04/01/1993 12:00:00 AM 36 20   6003362.1302 2106920.4307 37.765392172561796 -122.431593762963 (37.7653921725618, -122.431593762963)
21855 25111 3 100 1450 Dolores St 4 11 1 2     90 20   6005242.59316 2099769.2409599996 37.745863081619895 -122.424580935573 (37.7458630816199, -122.424580935573)
21891 25037 3 100 800X Dolores St 1 11 1 2     90 20   6005031.31461 2103614.04185 37.7564080795924 -122.425585096976 (37.7564080795924, -122.425585096976)
21915 25502 3 100 1900X Market St 2 11 1 2   04/01/1993 12:00:00 AM 36 8   6005183.0311 2108665.831 37.7702876647003 -122.425419904307 (37.7702876647003, -122.425419904307)
21959 25083 3 100 1200X Dolores St 3 11 1 2     90 20   6005162.35719 2101213.31575 37.74982364735521 -122.424961105075 (37.7498236473552, -122.424961105075)
21974 25530 3 100 2300X Market St 5 11 1 2   04/01/1993 12:00:00 AM 36 10   6002661.3855 2106250.4058 37.7635127037236 -122.433969576289 (37.7635127037236, -122.433969576289)
21980 27480 3 100 400X Dolores St 9 11 1 2   10/04/1999 12:00:00 AM 70 20   6004900.72353 2105815.65161 37.7624458004571 -122.426193461385 (37.7624458004571, -122.426193461385)
21986 25118 3 100 1500X Dolores St 5 11 1 2     90 20   6005257.61936 2099436.85892 37.74495128509079 -122.42450533857 (37.7449512850908, -122.42450533857)
22009 24961 3 100 100 Dolores St 1 11 1 2   04/21/2005 12:00:00 AM 90 20   6004800.95891 2107734.51921 37.76770891277079 -122.42667516163999 (37.7677089127708, -122.42667516164)
22015 25539 3 100 2200X Market St 5 11 1 2   04/01/1993 12:00:00 AM 36 20   6003230.8711 2106796.1855 37.7650435846647 -122.432038884515 (37.7650435846647, -122.432038884515)
22048 25106 3 100 1450X Dolores St 6 11 1 2     90 20   6005241.17775 2099713.8788799997 37.74571099007721 -122.424581892451 (37.7457109900772, -122.424581892451)
22064 25150 3 100 50X Dolores St 3 11 1 2     12 20   6004790.11345 2107911.6189 37.7681945727608 -122.42672528803699 (37.7681945727608, -122.426725288037)
22145 25515 3 100 2100X Market St 2 11 1 2   04/01/1993 12:00:00 AM 36 10   6004020.8124 2107556.2611 37.767175321793 -122.429360878869 (37.767175321793, -122.429360878869)
22227 25067 3 100 1000X Dolores St 10 11 1 2     40 20   6005110.57075 2102123.34784 37.7523194593995 -122.425204931964 (37.7523194593995, -122.425204931964)
24559 246349 3 100 2190x Market St 1 11 1 2     31 Width 0ft   6003723.2107 2107266.4094 37.766362606026796 -122.430369556243 (37.7663626060268, -122.430369556243)
24676 25027 3 100 740X Dolores St 2 11 1 2     80 20   6004958.5167563 2104022.9997464 37.75752686832129 -122.425865966748 (37.7575268683213, -122.425865966748)
25198 246342 3 100 2020x Market St 4 11 1 2     30 Width 0ft   6004356.6072 2107872.2367 37.7680619198287 -122.42822193571301 (37.7680619198287, -122.428221935713)
27176 24980 3 100 292 Dolores St 7 11 1 2     90 20   6004817.953366901 2106647.0197827998 37.7647238606763 -122.42653893424699 (37.7647238606763, -122.426538934247)
30035 194392 3 100 860x Jamestown Ave 5 11 1 2     17 Width 5ft   6014755.052209999 2089115.5775900001 37.7171429037943 -122.39094345187799 (37.7171429037943, -122.390943451878)
32439 194391 3 100 828x Jamestown Ave 4 11 1 2     19 Width 5ft   6014866.8225 2088973.5540099998 37.7167591360948 -122.39054719349899 (37.7167591360948, -122.390547193499)
36176 246402 3 100 2000x Market St 1 11 1 2     30 Width 0ft   6004659.311000001 2108158.3365 37.7688646036969 -122.42719529666901 (37.7688646036969, -122.427195296669)
38993 248619 3 100 1801x Market St 1 11 1 2     25 Width 0ft   6005765.0052 2109117.0426 37.7715594473913 -122.42343893750099 (37.7715594473913, -122.423438937501)
41784 194394 3 100 920x Jamestown Ave 4 11 1 2     19 Width 5ft   6014490.42947 2089308.0420799998 37.717656686497506 -122.39187158462799 (37.7176566864975, -122.391871584628)
44570 27941 1 100 699 The Embarcadero 2 11 1 9   02/01/2001 12:00:00 AM 24     6012787.5534626 2119857.700218 37.801444644335106 -122.399901749617 (37.8014446443351, -122.399901749617)
54798 246348 3 100 2150x Market St 1 11 1 2     32 Width 0ft   6003809.2361 2107348.5599 37.766593043924 -122.430077871393 (37.766593043924, -122.430077871393)
58367 132070 3 100 1000x The Embarcadero 1 11 1 2     23 Width 5ft   6013297.802519999 2119184.84583 37.7996255806051 -122.39808881644501 (37.7996255806051, -122.398088816445)
64559 246403 3 100 2000x Market St 2 11 1 2     25 Width 0ft   6004628.6575 2108127.683 37.7687787030374 -122.427299141169 (37.7687787030374, -122.427299141169)
69271 25030 3 100 740X Dolores St 5 11 1 2     70 20   6004958.5167563 2104022.9997464 37.75752686832129 -122.425865966748 (37.7575268683213, -122.425865966748)
69372 25749 1 100 1301X The Embarcadero 2 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
76295 246340 3 100 2020x Market St 6 11 1 2     32 Width 0ft   6004296.5773 2107812.2068 37.767893695460295 -122.428425293549 (37.7678936954603, -122.428425293549)
76348 27944 1 100 999 The Embarcadero 1 11 1 9     24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
77513 27958 1 100 307X The Embarcadero 2 11 1 9   02/05/2001 12:00:00 AM 18     6013768.7522982005 2118400.6344275 37.7974985415834 -122.396404150152 (37.7974985415834, -122.396404150152)
77825 25016 3 100 710X Dolores St 1 11 1 2     70 20   6004949.2547318 2104210.5607702998 37.758041343361796 -122.425911349448 (37.7580413433618, -122.425911349448)
77877 28025 1 100 100 The Embarcadero 5 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014170.25601 2117873.24701 37.796072794607895 -122.39497787369301 (37.7960727946079, -122.394977873693)
78155 25795 1 100 800X The Embarcadero 9 11 1 9   08/30/1996 12:00:00 AM 36 10   6012764.87501 2119980.6770099998 37.80178104459689 -122.39998886869199 (37.8017810445969, -122.399988868692)
78230 27930 1 100 799 The Embarcadero 2 11 1 9   02/01/2001 12:00:00 AM 24 10   6012635.1983488 2120084.4698961005 37.8020588041016 -122.400444907677 (37.8020588041016, -122.400444907677)
78381 23674 3 100 319 Virginia Ave 3 11 1 2     3 12   6006936.2458165 2098250.5638735 37.741788638281996 -122.418616833275 (37.741788638282, -122.418616833275)
78576 25731 1 100 501X The Embarcadero 1 11 1 9   08/15/1996 12:00:00 AM 16 10   6013387.7643744005 2119020.8269614 37.799180234142106 -122.39776600258999 (37.7991802341421, -122.39776600259)
78636 28030 1 100 100 The Embarcadero 10 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014322.16601 2117689.8700099997 37.795577730351205 -122.39443938464899 (37.7955777303512, -122.394439384649)
78875 27848 1 100 100 The Embarcadero 3 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015938.91901 2112416.43301 37.7811878161514 -122.388476823036 (37.7811878161514, -122.388476823036)
78913 25684 1 100 100 The Embarcadero 2 11 1 9   12/18/2000 12:00:00 AM 12 3X3   6015953.02501 2112484.79201 37.781376296324 -122.388432795571 (37.781376296324, -122.388432795571)
Powered by Datasette · Query took 9.518ms · Data source: data.sfgov.org