trees

Custom SQL query returning 21 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
4021 218797 1 272 215 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree 2     31 Width 4ft   5994944.25592 2100553.85526 37.7474304587646 -122.460247733165 (37.7474304587646, -122.460247733165) 1 8 4 29491 40
8444 103091 5 272 1540 Jones St 1 Sidewalk: Curb side : Cutout Tree 2   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008424.20559 2117797.21945 37.7955428518875 -122.414855023041 (37.7955428518875, -122.414855023041) 5 1 10 308 21
9912 103092 5 272 1540 Jones St 2 Sidewalk: Curb side : Cutout Tree 2   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008422.05981 2117808.63756 37.7955740826282 -122.414863256344 (37.7955740826282, -122.414863256344) 5 1 10 308 21
10996 103096 5 272 1540 Jones St 6 Sidewalk: Curb side : Cutout Tree 2   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008414.12252 2117870.41106 37.7957432514055 -122.414895095058 (37.7957432514055, -122.414895095058) 5 1 10 308 21
14679 103093 5 272 1540 Jones St 3 Sidewalk: Curb side : Cutout Tree 2   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008420.39916 2117820.52002 37.7956066156178 -122.414869843894 (37.7956066156178, -122.414869843894) 5 1 10 308 21
17667 103095 5 272 1540 Jones St 5 Sidewalk: Curb side : Cutout Tree 2   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008416.42419 2117851.09099 37.7956903325975 -122.414885762773 (37.7956903325975, -122.414885762773) 5 1 10 308 21
18706 103094 5 272 1540 Jones St 4 Sidewalk: Curb side : Cutout Tree 2   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008418.50881 2117836.67229 37.7956508595435 -122.414877528601 (37.7956508595435, -122.414877528601) 5 1 10 308 21
19455 218798 1 272 215 Magellan Ave 2 Sidewalk: Curb side : Cutout Tree 2     32 Width 4ft   5994966.43153 2100574.6456 37.7474888193606 -122.460172557931 (37.7474888193606, -122.460172557931) 1 8 4 29491 40
27211 126608 1 272 2770 Lombard St 4 Sidewalk: Property side : Yard Tree 2     2     5999116.02879 2119093.57703 37.7985748882819 -122.447156139343 (37.7985748882819, -122.447156139343) 13 9 1 57 17
50624 123542 1 272 37 05th Ave 2 Sidewalk: Curb side : Yard Tree 2     3 Width 5ft   5994230.38734 2115336.74336 37.7879792973558 -122.463789037794 (37.7879792973558, -122.463789037794) 11 6 1 54 11
51138 102048 4 272 213 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree 2           5994976.9 2100573.4 37.7474860013873 -122.46013626866 (37.7474860013873, -122.46013626866) 1 8 4 29491 40
61806 123541 1 272 33 05th Ave 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 3ft   5994226.49475 2115389.59393 37.7881241862842 -122.463806342918 (37.7881241862842, -122.463806342918) 11 6 1 54 11
84750 218796 1 272 303 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree 2     1 Width 4ft   5994310.29727 2099950.16252 37.7457363842197 -122.462396123591 (37.7457363842197, -122.462396123591) 1 8 4 29491 40
99560 186354 1 272 1801 Sunset Blvd 21 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984834.846 2102662.3098 37.7526330064509 -122.495360347454 (37.7526330064509, -122.495360347454) 1 8 3 56 35
103546 113379 8 272 140 CASTENADA AVE 1 Front Yard : Yard Tree 2     50     5994437 2101097 37.7488926059174 -122.462041158848 (37.7488926059174, -122.462041158848) 1 8 4 29491 40
120621 101625 8 272 64 Levant St 1 Front Yard : Cutout Tree 2         Permit Number 769362 6000275.9 2106473.5 37.7639895997076 -122.442236202383 (37.7639895997076, -122.442236202383) 15 5 5 28862 3
141107 249656 1 272 2401 Lyon St 8 Front Yard : Yard Tree 2     3 Width 10ft   5999224.17872 2117231.23359 37.7934675682154 -122.446647842529 (37.7934675682154, -122.446647842529) 11   1 57 30
151146 102049 4 272 213 Magellan Ave 2 Sidewalk: Curb side : Cutout Tree 2           5994976.9 2100573.4 37.7474860013873 -122.46013626866 (37.7474860013873, -122.46013626866) 1 8 4 29491 40
156934 126607 1 272 2770 Lombard St 3 Sidewalk: Property side : Yard Tree 2     3 Width 8ft   5999174.46407 2119100.33558 37.7985967840741 -122.446954422315 (37.7985967840741, -122.446954422315) 13 9 1 57 17
186695 13297 1 272 2770 Lombard St 2 Sidewalk: Curb side : Cutout Tree 1     24 3X3 Permit Number 770074 5999236.74018 2119108.91044 37.798623886028 -122.446739545491 (37.798623886028, -122.446739545491) 13 9 1 57 17
188439 126609 1 272 1183 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 3ft   6008435.25063 2117910.57891 37.7958547295674 -122.414824831928 (37.7958547295674, -122.414824831928) 5 1 10 308 21