trees

Custom SQL query returning 34 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
6411 136695 1 86 1200 Greenwich St 1 Sidewalk: Curb side : Yard Tree 2     31     6007098.70591 2119850.28744 37.8011054932745 -122.419587225988 (37.8011054932745, -122.419587225988) 5 1 1 28858 32
21329 136680 1 86 1369 Hyde St 5 Sidewalk: Property side : Yard Tree 2     5 Width 2ft   6007505.03866 2117018.90394 37.7933541007707 -122.417980305661 (37.7933541007707, -122.417980305661) 5 1 10 28858 32
29197 136662 1 86 1307 Bay St 4 : Tree 2     1 Width 1ft   6004522.84241 2120815.90939 37.8036114118857 -122.428569697738 (37.8036114118857, -122.428569697738) 13 9 1 28858 17
31433 136684 1 86 57 Russell St 1 Sidewalk: Property side : Yard Tree 2     12 Width 2ft   6007021.76535 2118934.77129 37.7985873825495 -122.41978847538 (37.7985873825495, -122.41978847538) 5 1 10 28858 32
34212 136690 1 86 1101 Green St 3 Sidewalk: Property side : Yard Tree 2     3 Width 2ft   6007706.55666 2118838.72504 37.7983622165993 -122.417412065427 (37.7983622165993, -122.417412065427) 5 1 10 28858 32
43003 136693 1 86 2164 Hyde St 5 Sidewalk: Property side : Yard Tree 2     6 Width 5ft   6007181.34298 2119779.01061 37.8009144395066 -122.41929620626 (37.8009144395066, -122.41929620626) 5 1 1 28858 32
53129 136663 1 86 3109 Franklin St 1 : Tree 2     7 Width 3ft   6005049.76701 2120690.58566 37.8032971105329 -122.426737318298 (37.8032971105329, -122.426737318298) 13 9 1 28858 17
53739 136691 1 86 1101 Green St 4 Sidewalk: Property side : Yard Tree 2     3 Width 2ft   6007718.23454 2118839.56071 37.7983651681777 -122.417371715557 (37.7983651681777, -122.417371715557) 5 1 10 28858 32
67917 87249 7 86 236323 Larkin St 8 Sidewalk: Property side : Cutout Tree 2       3x3   6006714 2119291 37.7995481543168 -122.420878746938 (37.7995481543168, -122.420878746938) 5 9 1 28858 32
71160 136681 1 86 1369 Hyde St 8 Sidewalk: Property side : Yard Tree 2     5 Width 2ft   6007511.08374 2116974.21798 37.7932317444123 -122.41795622 (37.7932317444123, -122.41795622) 5 1 10 28858 32
71235 98244 6 86 901 Bay St 1 Front Yard : Yard Tree 2     5     6006420.63185 2121080.7781 37.8044458892203 -122.422021121489 (37.8044458892203, -122.422021121489) 5 1 1 28858 32
75958 136705 1 86 1120 Greenwich St 3 Front Yard : Yard Tree 2     14     6007496.45618 2119889.74411 37.8012362277192 -122.418213633845 (37.8012362277192, -122.418213633845) 5 1 1 28858 32
77632 136687 1 86 915 Bay St 2 Sidewalk: Property side : Yard Tree 2     8 Width 2ft   6006389.37934 2121076.02461 37.8044310746876 -122.422128935803 (37.8044310746876, -122.422128935803) 5 1 1 28858 32
81024 113456 1 86 6X Leroy Pl 1 Sidewalk: Curb side : Cutout Tree 2     6 3x3   6008347.73797 2116436.02263 37.7918010435277 -122.415023221461 (37.7918010435277, -122.415023221461) 5 1 10 28858 21
82501 136685 1 86 929 Bay St 1 Sidewalk: Property side : Yard Tree 2     5 Width 2ft   6006311.09024 2121067.4414 37.8044030913911 -122.422399252223 (37.8044030913911, -122.422399252223) 5 1 1 28858 32
84969 136678 1 86 1369 Hyde St 1 Sidewalk: Property side : Yard Tree 2     6 Width 2ft   6007492.70889 2117096.59509 37.7935667274799 -122.418028477839 (37.7935667274799, -122.418028477839) 5 1 10 28858 32
93014 136664 1 86 3109 Franklin St 2 : Tree 2     7 Width 3ft   6005052.80958 2120674.99367 37.8032544709705 -122.42672567836 (37.8032544709705, -122.42672567836) 13 9 1 28858 17
98485 104833 1 86 901 Bay St 2 Sidewalk: Curb side : Cutout Tree 2     6     6006442.50157 2121083.02679 37.8044532969577 -122.421945599118 (37.8044532969577, -122.421945599118) 5 1 1 28858 32
100716 136692 1 86 1101 Green St 5 Sidewalk: Property side : Yard Tree 2     8 Width 2ft   6007731.45393 2118841.87046 37.7983722539254 -122.417326136092 (37.7983722539254, -122.417326136092) 5 1 10 28858 32
105016 136696 1 86 1063 Lombard St 1 Sidewalk: Property side : Yard Tree 2     20 Width 6ft   6007280.02976 2120167.28303 37.8019860950362 -122.418982261931 (37.8019860950362, -122.418982261931) 5 1 1 28858 32
121616 136698 1 86 1047 Lombard St 3 Sidewalk: Property side : Yard Tree 2     9 Width 6ft   6007369.77523 2120178.57084 37.802022141674 -122.418672500363 (37.802022141674, -122.418672500363) 5 1 1 28858 32
128853 136661 1 86 1307 Bay St 3 : Tree 2     4 Width 1ft   6004511.51487 2120814.19666 37.8036060681264 -122.428608775088 (37.8036060681264, -122.428608775088) 13 9 1 28858 17
132265 87248 7 86 236323 Larkin St 7 Sidewalk: Curb side : Cutout Tree 2   02/19/2008 12:00:00 AM   3x3 Permit Number 50274 6006714 2119291 37.7995481543168 -122.420878746938 (37.7995481543168, -122.420878746938) 5 9 1 28858 32
132805 136694 1 86 1201 Greenwich St 3 Sidewalk: Curb side : Cutout Tree 2     6 Width 3ft   6007018.29249 2119785.88696 37.8009241359937 -122.41986091934 (37.8009241359937, -122.41986091934) 5 1 1 28858 32
133349 136697 1 86 1047 Lombard St 2 Sidewalk: Property side : Yard Tree 2     10 Width 6ft   6007352.71781 2120177.3681 37.80201787889 -122.418731441927 (37.80201787889, -122.418731441927) 5 1 1 28858 32
134836 99719 1 86 2164 Hyde St 1 Sidewalk: Curb side : Cutout Tree 2     10 3x3   6007186.17673 2119740.01598 37.8008076423232 -122.419276711652 (37.8008076423232, -122.419276711652) 5 1 1 28858 32
146664 87250 7 86 236323 Larkin St 8 Sidewalk: Property side : Cutout Tree 2   02/19/2008 12:00:00 AM   3x3 Permit Number 50274 6006714 2119291 37.7995481543168 -122.420878746938 (37.7995481543168, -122.420878746938) 5 9 1 28858 32
159941 136686 1 86 915 Bay St 1 Sidewalk: Property side : Yard Tree 2     7 Width 2ft   6006372.4804 2121073.97355 37.8044244898475 -122.42218727034 (37.8044244898475, -122.42218727034) 5 1 1 28858 32
168686 136707 1 86 1155 Greenwich St 3 Sidewalk: Property side : Yard Tree 2     5 Width 2ft   6007381.61519 2119835.37419 37.8010804768418 -122.418607177199 (37.8010804768418, -122.418607177199) 5 1 1 28858 32
169155 136706 1 86 1155 Greenwich St 2 Sidewalk: Property side : Yard Tree 2     5 Width 3ft   6007368.03811 2119831.84665 37.8010700267201 -122.418653909561 (37.8010700267201, -122.418653909561) 5 1 1 28858 32
175671 67619 1 86 1101 Green St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/14/1992 12:00:00 AM 11   Permit Number 31202 6007683.17057 2118835.54867 37.7983521792584 -122.417492763389 (37.7983521792584, -122.417492763389) 5 1 10 28858 32
185017 136688 1 86 777 Bay St 1 Sidewalk: Property side : Yard Tree 2     5 Width 2ft   6007087.93893 2121181.13167 37.8047590475447 -122.419718966771 (37.8047590475447, -122.419718966771) 5 1 1 28858 32
191106 136679 1 86 1369 Hyde St 4 Sidewalk: Property side : Yard Tree 2     4 Width 2ft   6007499.46397 2117047.73589 37.7934329524128 -122.41800163939 (37.7934329524128, -122.41800163939) 5 1 10 28858 32
192961 136689 1 86 1101 Green St 2 Sidewalk: Property side : Yard Tree 2     3 Width 2ft   6007697.4603 2118837.4061 37.7983580833179 -122.41744344816 (37.7983580833179, -122.41744344816) 5 1 10 28858 32