trees

Custom SQL query returning 51 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
2761 199857 1 54 2511 Keith St 6 Sidewalk: Curb side : Cutout Tree 2     9 Width 0ft   6014147.0563 2092057.1756 37.725186191812 -122.393250745752 (37.725186191812, -122.393250745752) 10 3 8 58 1
5364 245472 7 54 2700 24th St 4 Sidewalk: Curb side : Cutout Tree 2     19 Width 0ft   6010432.7166 2102259.7859 37.7529933156944 -122.406809623625 (37.7529933156944, -122.406809623625) 10 4 7 28859 19
6447 38608 1 54 1570 Revere Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/15/2002 12:00:00 AM 6   Permit Number 45423 6015284.7491 2094285.2369 37.7313671428977 -122.389473352601 (37.7313671428977, -122.389473352601) 10 3 8 58 1
7684 245413 7 54 2726 24th St 1 Sidewalk: Curb side : Cutout Tree 2     20 Width 0ft   6010382.82 2102257.4918 37.7529842245941 -122.406982014782 (37.7529842245941, -122.406982014782) 10 4 7 28859 19
7692 199749 1 54 1555 Yosemite Ave 4 Sidewalk: Curb side : Cutout Tree 2     6 Width 0ft   6014744.6664 2092522.7122 37.7264976449454 -122.391217378098 (37.7264976449454, -122.391217378098) 10 3 8 58 1
11681 245470 1 54 2700 24th St 2 Sidewalk: Curb side : Cutout Tree 1     21 Width 0ft   6010486.0542 2102262.08 37.7530025990603 -122.406625332729 (37.7530025990603, -122.406625332729) 10 4 7 28859 19
12248 245414 1 54 2736 24th St 1 Sidewalk: Curb side : Cutout Tree 1     23 Width 0ft   6010338.0852 2102254.0506 37.7529722724302 -122.40713647447 (37.7529722724302, -122.40713647447) 10 4 7 28859 19
22206 199853 1 54 2503 Keith St 2 Sidewalk: Curb side : Cutout Tree 2     8 Width 0ft   6014209.1818 2092155.2364 37.7254588983374 -122.393042840565 (37.7254588983374, -122.393042840565) 10 3 8 58 1
23493 199735 1 54 1500 Armstrong Ave 9 Sidewalk: Curb side : Cutout Tree 2     9 Width 0ft   6014648.3519 2092320.2341 37.7259363350419 -122.391536186534 (37.7259363350419, -122.391536186534) 10 3 8 58 1
23864 38611 1 54 1570 Revere Ave 4 Sidewalk: Curb side : Cutout Tree 2 FUF 09/17/1998 12:00:00 AM 6   Permit Number 40556 6015254.5205 2094308.8703 37.7314303593885 -122.389579509324 (37.7314303593885, -122.389579509324) 10 3 8 58 1
42028 97242 1 54 1300X Keith St 1 Sidewalk: Curb side : Cutout Tree 2     18 3x3   6016235.0824 2094868.9009 37.7330224130953 -122.386228519291 (37.7330224130953, -122.386228519291) 10 3 8 58 1
42630 199741 1 54 2399 Keith St 2 Sidewalk: Curb side : Cutout Tree 2     6 Width 0ft   6014513.885 2092478.0086 37.7263620876399 -122.392012061617 (37.7263620876399, -122.392012061617) 10 3 8 58 1
44260 199854 1 54 2505 Keith St 3 Sidewalk: Curb side : Cutout Tree 2     9 Width 0ft   6014200.0457 2092143.0549 37.7254249428706 -122.393073571548 (37.7254249428706, -122.393073571548) 10 3 8 58 1
46647 494 1 54 2749X 24th St 4 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6010448.7752 2102218.4922 37.7528808308555 -122.406751179708 (37.7528808308555, -122.406751179708) 10 4 7 28859 19
57000 199732 1 54 1500 Armstrong Ave 4 Sidewalk: Curb side : Cutout Tree 2     6 Width 0ft   6014820.4695 2092191.1459 37.7255914365754 -122.390932164611 (37.7255914365754, -122.390932164611) 10 3 8 58 1
57901 492 1 54 2749X 24th St 2 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6010397.1581 2102215.0511 37.7528684941587 -122.406929439613 (37.7528684941587, -122.406929439613) 10 4 7 28859 19
61537 487 1 54 2718 24th St 1 Sidewalk: Curb side : Cutout Tree 1     18 3x3   6010403.4669 2102258.6388 37.7529885293488 -122.406910694342 (37.7529885293488, -122.406910694342) 10 4 7 28859 19
62896 199856 1 54 2509 Keith St 5 Sidewalk: Curb side : Cutout Tree 2     9 Width 0ft   6014162.2831 2092076.0569 37.7252388819994 -122.393199428445 (37.7252388819994, -122.393199428445) 10 3 8 58 1
64608 245471 1 54 2700 24th St 3 Sidewalk: Curb side : Cutout Tree 2     20 Width 0ft   6010463.1133 2102261.5065 37.7529997408326 -122.406704626743 (37.7529997408326, -122.406704626743) 10 4 7 28859 19
65580 199722 1 54 2300 Jennings St 2 Sidewalk: Curb side : Cutout Tree 2     9 Width 0ft   6015093.5789 2092222.3792 37.72569234746 -122.38999022092 (37.72569234746, -122.38999022092) 10 3 8 58 1
65948 497 1 54 2749X 24th St 7 Sidewalk: Curb side : Cutout Tree 1     20 3X3   6010516.451 2102220.2128 37.7528893415843 -122.406517264254 (37.7528893415843, -122.406517264254) 10 4 7 28859 19
70044 38609 1 54 1570 Revere Ave 2 Sidewalk: Curb side : Cutout Tree 2 FUF 05/15/2002 12:00:00 AM 6   Permit Number 45423 6015273.2073 2094293.4811 37.7313891398709 -122.38951383063 (37.7313891398709, -122.38951383063) 10 3 8 58 1
75827 38610 1 54 1570 Revere Ave 3 Sidewalk: Curb side : Cutout Tree 2 FUF 05/15/2002 12:00:00 AM 6   Permit Number 45423 6015263.8639 2094301.7253 37.7314112587254 -122.389546708337 (37.7314112587254, -122.389546708337) 10 3 8 58 1
80537 199852 1 54 2501 Keith St 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 0ft   6014213.4453 2092166.8088 37.7254909106612 -122.393028911239 (37.7254909106612, -122.393028911239) 10 3 8 58 1
80916 481 1 54 2700 24th St 1 Sidewalk: Curb side : Cutout Tree 1     18 3x3   6010503.8335 2102264.9476 37.7530114675552 -122.406564050249 (37.7530114675552, -122.406564050249) 10 4 7 28859 19
82719 200689 1 54 4705 03rd St 5 Sidewalk: Curb side : Cutout Tree 2     14 Width 0ft   6015031.9275 2095672.1834 37.7351613961063 -122.390444284047 (37.7351613961063, -122.390444284047) 10 3 8 58 1
84858 199734 1 54 1500 Armstrong Ave 7 Sidewalk: Curb side : Cutout Tree 2     6 Width 0ft   6014741.5822 2092253.0007 37.725756899909 -122.391209195431 (37.725756899909, -122.391209195431) 10 3 8 58 1
85967 199730 1 54 1500 Armstrong Ave 2 Sidewalk: Curb side : Cutout Tree 2     7 Width 0ft   6014897.5638 2092133.7733 37.725438180339 -122.390661646389 (37.725438180339, -122.390661646389) 10 3 8 58 1
86084 199739 1 54 1500 Armstrong Ave 13 Sidewalk: Curb side : Cutout Tree 2     8 Width 0ft   6014497.7489 2092432.2899 37.7262356573725 -122.392064648003 (37.7262356573725, -122.392064648003) 10 3 8 58 1
86641 199738 1 54 1500 Armstrong Ave 12 Sidewalk: Curb side : Cutout Tree 2     10 Width 0ft   6014531.8139 2092406.2929 37.7261661660829 -122.39194506905 (37.7261661660829, -122.39194506905) 10 3 8 58 1
88983 200684 1 54 1618 Oakdale Ave 4 Sidewalk: Curb side : Cutout Tree 2     16 Width 0ft   6015017.6376 2095531.4827 37.7347742678836 -122.390483861704 (37.7347742678836, -122.390483861704) 10 3 8 58 1
95718 97243 1 54 1300X Keith St 2 Sidewalk: Curb side : Cutout Tree 2     18 3x3   6016226.9194 2094855.7145 37.7329857540551 -122.386255822187 (37.7329857540551, -122.386255822187) 10 3 8 58 1
105727 199855 1 54 2507 Keith St 4 Sidewalk: Curb side : Cutout Tree 2     8 Width 0ft   6014175.0737 2092094.9381 37.7252914365514 -122.393156532831 (37.7252914365514, -122.393156532831) 10 3 8 58 1
108876 199858 1 54 2513 Keith St 7 Sidewalk: Curb side : Cutout Tree 2     8 Width 0ft   6014132.4385 2092038.2943 37.7251335354362 -122.393299957721 (37.7251335354362, -122.393299957721) 10 3 8 58 1
109427 199728 1 54 2300 Jennings St 8 Sidewalk: Curb side : Cutout Tree 2     6 Width 0ft   6014985.6871 2092077.3996 37.725288278052 -122.390353072543 (37.725288278052, -122.390353072543) 10 3 8 58 1
113982 97244 1 54 1300X Keith St 3 Sidewalk: Curb side : Cutout Tree 2     18 3x3   6016216.2447 2094842.5281 37.7329489559822 -122.386291808735 (37.7329489559822, -122.386291808735) 10 3 8 58 1
122068 200196 1 54 1124 Fitzgerald Ave 2 Sidewalk: Curb side : Yard Tree 2     20 Width 0ft   6015063.1024 2090263.455 37.720311838731 -122.389958798873 (37.720311838731, -122.389958798873) 10 3 8 58 1
122091 493 1 54 2749X 24th St 3 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6010421.2461 2102217.9187 37.7528777158138 -122.406846340514 (37.7528777158138, -122.406846340514) 10 4 7 28859 19
122229 496 1 54 2749X 24th St 6 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6010495.2306 2102220.2128 37.7528881543902 -122.406590648723 (37.7528881543902, -122.406590648723) 10 4 7 28859 19
133221 199982 1 54 1081 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 0ft   6018036.5838 2092513.2332 37.7266537566215 -122.379836574534 (37.7266537566215, -122.379836574534) 10 3 8 58 1
139603 32290 1 54 1400 Egbert Ave 1 Sidewalk: Curb side : Cutout Tree 2   08/15/1996 12:00:00 AM 13   Permit Number 36872 6014301.1518 2091179.5011 37.7227848326743 -122.392656680249 (37.7227848326743, -122.392656680249) 10 3 8 58 1
141408 199975 1 54 1233 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 0ft   6016858.7319 2092693.7716 37.7270844364031 -122.383920974413 (37.7270844364031, -122.383920974413) 10 3 8 58 1
146069 199726 1 54 2300 Jennings St 6 Sidewalk: Curb side : Cutout Tree 2     6 Width 0ft   6015013.7839 2092118.9829 37.7254040160333 -122.390258847729 (37.7254040160333, -122.390258847729) 10 3 8 58 1
157672 199724 1 54 2300 Jennings St 4 Sidewalk: Curb side : Cutout Tree 2     8 Width 0ft   6015054.2433 2092170.681 37.7255482128528 -122.390122592124 (37.7255482128528, -122.390122592124) 10 3 8 58 1
160447 489 1 54 2730 24th St 1 Sidewalk: Curb side : Cutout Tree 2     18 3X3   6010359.8791 2102254.6242 37.7529750670361 -122.407061147073 (37.7529750670361, -122.407061147073) 10 4 7 28859 19
163064 199721 1 54 2300 Jennings St 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 0ft   6015103.6937 2092236.9895 37.7257330254006 -122.389956274684 (37.7257330254006, -122.389956274684) 10 3 8 58 1
165455 199757 1 54 1555 Yosemite Ave 12 Sidewalk: Curb side : Cutout Tree 2     6 Width 0ft   6015056.6652 2092285.8367 37.7258645418149 -122.390122260939 (37.7258645418149, -122.390122260939) 10 3 8 58 1
165518 32291 1 54 1400 Egbert Ave 2 Sidewalk: Curb side : Cutout Tree 2   08/15/1996 12:00:00 AM 7   Permit Number 36872 6014236.59 2091225.7906 37.7229083485403 -122.3928830953 (37.7229083485403, -122.3928830953) 10 3 8 58 1
170076 199769 1 54 1197 Thomas Ave 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 0ft   6016909.41 2092306.5247 37.7260239336289 -122.383718829233 (37.7260239336289, -122.383718829233) 10 3 8 58 1
178727 199743 1 54 2351 Keith St 2 Sidewalk: Curb side : Cutout Tree 2     7 Width 0ft   6014556.9144 2092538.9669 37.7265318557922 -122.391867570434 (37.7265318557922, -122.391867570434) 10 3 8 58 1
183288 491 1 54 2749X 24th St 1 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6010371.9231 2102214.4775 37.7528655070754 -122.407016666927 (37.7528655070754, -122.407016666927) 10 4 7 28859 19