trees

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
408 109629 4 16 200X GELLERT DR 30 Median : Cutout Tree 1       30x200   5985380 2094516.3 37.730298158605 -122.492875173009 (37.730298158605, -122.492875173009) 1 8 4 64 35
932 111099 4 15 480X LAKESHORE DR 20 Median : Cutout Tree 1       30x200   5984942 2095282 37.7323749444343 -122.494445798495 (37.7323749444343, -122.494445798495) 1 8 4 64 35
1229 264907 4 1 259 Clara St 5 Sidewalk: Curb side : Cutout Tree 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
1232 264776 4 76 90x Guy Pl 10 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
1376 263620 4 59 900 Beach St 3 Side Yard : Yard Tree 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
2258 264781 4 127 90x Guy Pl 15 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
2913 264905 4 1 259 Clara St 3 Median : Cutout Tree 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
3022 264768 4 76 90x Guy Pl 2 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
3144 113684 4 27 500X THE EMBARCADERO 18 Sidewalk: Curb side : Cutout Tree 1       3x3   6013440 2119057 37.7992824654164 -122.3975877866 (37.7992824654164, -122.3975877866) 3 1 10 28860 6
3197 261564 4 15 1801 25th St 9 Sidewalk: Property side : Yard Tree 1       3x3   6013134 2101730 37.751689413587 -122.397430852298 (37.751689413587, -122.397430852298) 10 3 8 28856 29
4232 264908 4 1 259 Clara St 6 Sidewalk: Curb side : Cutout Tree 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
4280 264767 4 44 90x Guy Pl 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
4323 264887 4 44 99x South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6007378 2109480 37.7726469495053 -122.417885217611 (37.7726469495053, -122.417885217611) 8 2 9 28853 19
4382 264774 4 76 90x Guy Pl 8 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
4589 261026 4 65 758 20th Ave 1 Sidewalk: Curb side : Cutout Tree 1   11/18/2019 12:00:00 AM   3x3   5989802 2110189 37.7735888483109 -122.478733667362 (37.7735888483109, -122.478733667362) 11 6 2 55 26
5493 264903 4 1 259 Clara St 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
5495 260381 4 50 1924 Jennings St 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6015697 2093053 37.7280065148754 -122.387962157958 (37.7280065148754, -122.387962157958) 10 3 8 58 1
6639 261563 4 42 1801 25th St 8 Sidewalk: Property side : Yard Tree 1       3x3   6013134 2101730 37.751689413587 -122.397430852298 (37.751689413587, -122.397430852298) 10 3 8 28856 29
6742 264909 4 1 259 Clara St 7 Sidewalk: Curb side : Cutout Tree 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
7713 264772 4 76 90x Guy Pl 6 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
7972 264777 4 76 90x Guy Pl 11 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
8504 109669 4 155 200X GELLERT DR 33 Median : Cutout Tree 1   02/26/2015 01:37:00 PM 3 30x200   5985380 2094516.3 37.730298158605 -122.492875173009 (37.730298158605, -122.492875173009) 1 8 4 64 35
8638 116994 4 75 600M Divisadero St 1 Median : Cutout Tree 1     3     6001630.0135 2110553.7073 37.7752699186497 -122.43784499429 (37.7752699186497, -122.43784499429) 15 5 11 29492 10
9068 74830 4 27 493 Broadway 2 Sidewalk: Curb side : Cutout Tree 1   02/27/2013 12:00:00 AM   6x6 Permit Number 769961 6011188.26118785 2118621.30079081 37.7979605016561 -122.405348925503 (37.7979605016561, -122.405348925503) 3 1 10 308 23
9425 264770 4 76 90x Guy Pl 4 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
10029 260896 4 155 866 Kansas St 1 Front Yard : Cutout Tree 1 Private     3x3   6011543 2104306 37.7586738299336 -122.403113948893 (37.7586738299336, -122.403113948893) 10 3 8 28856 29
10225 263619 4 59 900 Beach St 2 Side Yard : Yard Tree 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
10489 102839 4 63 1101X Portola Dr 2 Sidewalk: Property side : Yard Tree 1                              
10516 102842 4 16 1101X Portola Dr 8 Sidewalk: Property side : Yard Tree 1                              
10567 263621 4 59 900 Beach St 4 Side Yard : Yard Tree 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
10663 264778 4 76 90x Guy Pl 12 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
10966 109166 4 31 51x OCTAVIA ST 5 Median : Cutout Tree 1       3x20   6005650.4 2109419.7 37.772384002649 -122.423856888434 (37.772384002649, -122.423856888434) 7 9 11 28852 10
11694 263618 4 59 900 Beach St 1 Side Yard : Yard Tree 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
11719 264769 4 76 90x Guy Pl 3 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
11739 264780 4 76 90x Guy Pl 14 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
12086 264891 4 44 99x South Van Ness Ave 5 Sidewalk: Curb side : Cutout Tree 1       3x3   6007378 2109480 37.7726469495053 -122.417885217611 (37.7726469495053, -122.417885217611) 8 2 9 28853 19
12194 261567 4 52 1299 Wisconsin St 12 Sidewalk: Property side : Yard Tree 1       3x3   6013134 2101730 37.751689413587 -122.397430852298 (37.751689413587, -122.397430852298) 10 3 8 28856 29
12634 264775 4 127 90x Guy Pl 9 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
12651 261028 4 6 743 20th Ave 1 Sidewalk: Curb side : Cutout Tree 1   11/18/2019 12:00:00 AM 3 3x3   5989712 2110287 37.7738527032106 -122.479052157213 (37.7738527032106, -122.479052157213) 11 6 2 55 26
12733 102843 4 70 1101X Portola Dr 10 Sidewalk: Property side : Yard Tree 1                              
12931 264773 4 76 90x Guy Pl 7 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
13415 264888 4 44 99x South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree 1       3x3   6007378 2109480 37.7726469495053 -122.417885217611 (37.7726469495053, -122.417885217611) 8 2 9 28853 19
13665 109201 4 127 2401x CASTRO ST 4 Median : Yard Tree 1           6002698 2098487 37.7421983129634 -122.433288166914 (37.7421983129634, -122.433288166914) 2 7 5 63 7
13700 104171 4 64 2607 DIAMOND ST 2 Sidewalk: Curb side : Cutout Tree 1     28 3x3   6002306 2096613 37.7370304975493 -122.434509617625 (37.7370304975493, -122.434509617625) 2 7 5 63 7
14967 108631 4 11 501 ELLIS ST 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6008465.6 2113811.6 37.7846016393538 -122.4144296353 (37.7846016393538, -122.4144296353) 7 10 9 28852 36
14985 113673 4 27 500X THE EMBARCADERO 7 Sidewalk: Curb side : Cutout Tree 1       3x3   6013440 2119057 37.7992824654164 -122.3975877866 (37.7992824654164, -122.3975877866) 3 1 10 28860 6
15033 261569 4 42 1299x Wisconsin St 2 Sidewalk: Property side : Yard Tree 1       3x3   6013134 2101730 37.751689413587 -122.397430852298 (37.751689413587, -122.397430852298) 10 3 8 28856 29
15114 264890 4 44 99x South Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree 1       3x3   6007378 2109480 37.7726469495053 -122.417885217611 (37.7726469495053, -122.417885217611) 8 2 9 28853 19
15154 102838 4 15 1101X Portola Dr 1 Sidewalk: Property side : Yard Tree 1                              
15329 264906 4 1 259 Clara St 4 Sidewalk: Curb side : Cutout Tree 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
15616 264771 4 76 90x Guy Pl 5 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
16338 261024 4 6 751 20th Ave 1 Sidewalk: Curb side : Cutout Tree 1   11/18/2019 12:00:00 AM   3x3   5989703 2110237 37.773714894321 -122.479079631213 (37.773714894321, -122.479079631213) 11 6 2 55 26
16732 262211 4 11 2162 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree 1       3x3   5999946 2089791 37.7181646124566 -122.4421796072 (37.7181646124566, -122.4421796072) 9 7 6 28861 25
17002 264889 4 44 99x South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree 1       3x3   6007378 2109480 37.7726469495053 -122.417885217611 (37.7726469495053, -122.417885217611) 8 2 9 28853 19
17686 261568 4 42 1299 Wisconsin St 1 Sidewalk: Property side : Yard Tree 1       3x3   6013134 2101730 37.751689413587 -122.397430852298 (37.751689413587, -122.397430852298) 10 3 8 28856 29
17933 264904 4 1 259 Clara St 2 Sidewalk: Curb side : Cutout Tree 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
17999 264779 4 76 90x Guy Pl 13 Sidewalk: Curb side : Cutout Tree 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
18337 113889 4 52 1x STORRIE ST 2 Sidewalk: Property side : Yard Tree 1     90     6000722 2105303 37.7608011093363 -122.440609317727 (37.7608011093363, -122.440609317727) 15 4 5 28862 3
18389 264893 4 44 99x South Van Ness Ave 6 Sidewalk: Curb side : Cutout Tree 1       3x3   6007378 2109480 37.7726469495053 -122.417885217611 (37.7726469495053, -122.417885217611) 8 2 9 28853 19
18714 111970 4 262 1x STORRIE ST 25 Sidewalk: Curb side : Cutout Tree 1     70 3x3   6000722 2105303 37.7608011093363 -122.440609317727 (37.7608011093363, -122.440609317727) 15 4 5 28862 3
19473 261023 4 10 631 32nd Ave 1 Sidewalk: Curb side : Cutout Tree 1   11/18/2019 12:00:00 AM   3x3   5985931 2111585 37.7771963436428 -122.492226661995 (37.7771963436428, -122.492226661995) 11 6 2 55 26
19544 261022 4 65 393 30th Ave 1 Sidewalk: Curb side : Cutout Tree 1   11/18/2019 12:00:00 AM   3x3   5986499 2113341 37.7820510072297 -122.490391009154 (37.7820510072297, -122.490391009154) 11 6 2 55 26
21767 109635 4 15 2X GENEVA AVE 4 Median : Cutout Tree 1       3x3   5997165.4 2091482.5 37.7226502134341 -122.451912865332 (37.7226502134341, -122.451912865332) 9 8 6 28861 24
25125 109198 4 127 2401x CASTRO ST 2 Median : Yard Tree 1           6002698 2098487 37.7421983129634 -122.433288166914 (37.7421983129634, -122.433288166914) 2 7 5 63 7
25439 98708 4 122 105X Ord St 2 Sidewalk: Curb side : Cutout Tree 1           6000883.6 2105740.8 37.7620124016568 -122.440081810476 (37.7620124016568, -122.440081810476) 15 5 5 28862 3
26355 256053 4 27 200 The Embarcadero 2 Sidewalk: Curb side : Cutout Tree 1       3x3   6015452 2116243 37.7916677028969 -122.390428783846 (37.7916677028969, -122.390428783846) 6 2 9 28855 6
27591 113681 4 27 500X THE EMBARCADERO 15 Sidewalk: Curb side : Cutout Tree 1       3x3   6013440 2119057 37.7992824654164 -122.3975877866 (37.7992824654164, -122.3975877866) 3 1 10 28860 6
28184 109638 4 16 1X Geneva Ave 2 Median : Cutout Tree 1       3x3   6001799 2091822 37.723846713797 -122.435919833731 (37.723846713797, -122.435919833731) 9 7 6 28861 25
30323 122488 4 15 69x Bonview St 4 Sidewalk: Curb side : Cutout Tree 1       3x3   6007716 2099172 37.7443625662885 -122.415985930063 (37.7443625662885, -122.415985930063) 2 7 7 28859 2
30889 254841 4 11 71 06th Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF 03/29/2018 12:00:00 AM 3 3x3   5993910 2115089 37.7872805943627 -122.464879512834 (37.7872805943627, -122.464879512834) 11 6 1 54 11
31232 111969 4 262 1x STORRIE ST 16 Sidewalk: Curb side : Cutout Tree 1       3x3   6000722 2105303 37.7608011093363 -122.440609317727 (37.7608011093363, -122.440609317727) 15 4 5 28862 3
32665 104357 4 11 14 VALENCIA ST 1 Sidewalk: Curb side : Cutout Tree 1     10 3x3   6005933 2109228 37.7718735901627 -122.42286572041 (37.7718735901627, -122.42286572041) 8 2 9 28853 19
34104 113688 4 27 500X THE EMBARCADERO 23 Sidewalk: Curb side : Cutout Tree 1       3x3   6013440 2119057 37.7992824654164 -122.3975877866 (37.7992824654164, -122.3975877866) 3 1 10 28860 6
34378 109203 4 127 2401x CASTRO ST 9 Median : Yard Tree 1           6002698 2098487 37.7421983129634 -122.433288166914 (37.7421983129634, -122.433288166914) 2 7 5 63 7
34560 255265 4 27 1599x Market St 6 Sidewalk: Curb side : Cutout Tree 1       3x3   6006908 2110080 37.7742679442705 -122.419553577666 (37.7742679442705, -122.419553577666) 8 2 9 28853 19
36097 115453 4 84 300 Octavia St Frontage East 4 Sidewalk: Curb side : Cutout Tree 1       4x4   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
37182 109162 4 31 51x OCTAVIA ST 1 Median : Cutout Tree 1     6 3x20   6005650.4 2109419.7 37.772384002649 -122.423856888434 (37.772384002649, -122.423856888434) 7 9 11 28852 10
37461 73302 4 27 900x Divisadero St 1 Sidewalk: Curb side : Cutout Tree 1   07/24/1999 12:00:00 AM   5x5   6001563 2111524 37.7779302874148 -122.438146331007 (37.7779302874148, -122.438146331007) 15 5 11 29490 41
38688 113686 4 27 500X THE EMBARCADERO 20 Sidewalk: Curb side : Cutout Tree 1       3x3   6013440 2119057 37.7992824654164 -122.3975877866 (37.7992824654164, -122.3975877866) 3 1 10 28860 6
42029 254843 4 8 1814 Anza St 1 Sidewalk: Curb side : Cutout Tree 1 FUF     3x3   5993025 2112122 37.7790829564028 -122.467725532477 (37.7790829564028, -122.467725532477) 11 6 2 54 11
42181 103514 4 44 1205 04th Ave 1 Sidewalk: Curb side : Cutout Tree 1   04/16/2015 02:38:00 PM 3 5x9 415-564-3245 marykittner@att.net 5994830.1 2107339.6 37.7660558096286 -122.461134258867 (37.7660558096286, -122.461134258867) 15 5 11 56 12
44865 256049 4 27 200 The Embarcadero 6 Sidewalk: Curb side : Cutout Tree 1       3x3   6015452 2116243 37.7916677028969 -122.390428783846 (37.7916677028969, -122.390428783846) 6 2 9 28855 6
45998 112547 4 29 462 BROADWAY 2 Sidewalk: Curb side : Cutout Tree 1       3x3   6011324 2118723 37.798247331278 -122.404886391926 (37.798247331278, -122.404886391926) 3 1 10 308 23
47204 108591 4 27 400x 06TH ST 1 Sidewalk: Curb side : Cutout Tree 1     18 3x3   6011386 2111037 37.7771468605476 -122.404130641378 (37.7771468605476, -122.404130641378) 14 2 9 28853 34
47310 255326 4 76 1003x Turk St 1 Sidewalk: Property side : Cutout Tree 1       3x3   6005211 2112640 37.7812013451486 -122.425606050794 (37.7812013451486, -122.425606050794) 7 9 11 28852 41
48053 111053 4 27 2059X MARKET ST 2 Sidewalk: Curb side : Cutout Tree 1       3x3   6004434 2107851 37.7680079876693 -122.427952728751 (37.7680079876693, -122.427952728751) 8 4 5 28862 3
48117 254837 4 8 130 11th Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF     3x3   5992465 2114587 37.7858188208387 -122.469842298582 (37.7858188208387, -122.469842298582) 11 6 2 54 11
50067 109632 4 16 2X GENEVA AVE 1 Median : Cutout Tree 1       3x3   5997165.4 2091482.5 37.7226502134341 -122.451912865332 (37.7226502134341, -122.451912865332) 9 8 6 28861 24
50541 122733 4 27 3203 Cesar Chavez St 2 Sidewalk: Curb side : Cutout Tree 1       3x3   6008384 2100540 37.7481563241105 -122.41377286403 (37.7481563241105, -122.41377286403) 2 4 7 28859 2
53785 255261 4 27 1599x Market St 2 Sidewalk: Curb side : Cutout Tree 1       3x3   6006908 2110080 37.7742679442705 -122.419553577666 (37.7742679442705, -122.419553577666) 8 2 9 28853 19
54207 109202 4 127 2401x CASTRO ST 6 Median : Yard Tree 1           6002698 2098487 37.7421983129634 -122.433288166914 (37.7421983129634, -122.433288166914) 2 7 5 63 7
55368 109658 4 41 800X BROTHERHOOD WAY 29 Median : Cutout Tree 1           5990271.4 2088582.7 37.7142908027957 -122.475532030318 (37.7142908027957, -122.475532030318) 1 8 4 64 14
55889 109250 4 11 200x BAKER ST 7 Sidewalk: Curb side : Cutout Tree 1       3x3   6000999 2109836 37.773263372988 -122.439976336261 (37.773263372988, -122.439976336261) 15 5 11 29492 10
56525 122494 4 41 69x Bonview St 10 Sidewalk: Curb side : Cutout Tree 1       3x3   6007716 2099172 37.7443625662885 -122.415985930063 (37.7443625662885, -122.415985930063) 2 7 7 28859 2
59753 104427 4 42 1000x GILMAN AVE 1 Sidewalk: Curb side : Cutout Tree 1     20 4x4   6015570 2089525 37.71831228448 -122.3881550967 (37.71831228448, -122.3881550967) 10 3 8 58 1
59848 112528 4 29 459 BROADWAY 2 Sidewalk: Curb side : Cutout Tree 1       3x3   6011361 2118561 37.797804586609 -122.404746949234 (37.797804586609, -122.404746949234) 3 1 10 308 23
60634 113685 4 27 500X THE EMBARCADERO 19 Sidewalk: Curb side : Cutout Tree 1       3x3   6013440 2119057 37.7992824654164 -122.3975877866 (37.7992824654164, -122.3975877866) 3 1 10 28860 6
62237 122492 4 11 69x Bonview St 8 Sidewalk: Curb side : Cutout Tree 1       3x3   6007716 2099172 37.7443625662885 -122.415985930063 (37.7443625662885, -122.415985930063) 2 7 7 28859 2
63160 109199 4 127 2401x CASTRO ST 7 Median : Yard Tree 1           6002698 2098487 37.7421983129634 -122.433288166914 (37.7421983129634, -122.433288166914) 2 7 5 63 7
63499 122489 4 96 69x Bonview St 5 Sidewalk: Curb side : Cutout Tree 1       3x3   6007716 2099172 37.7443625662885 -122.415985930063 (37.7443625662885, -122.415985930063) 2 7 7 28859 2
65097 110683 4 286 1 EDDY ST 1 Median : Cutout Tree 1       3x3   6010419 2113787 37.7846436353836 -122.40766976216 (37.7846436353836, -122.40766976216) 14 10 10 28852 36