trees

Custom SQL query returning 26 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
80081 655 1 97 3255X 24th St 3 Sidewalk: Curb side : Cutout Tree 7   06/02/1992 12:00:00 AM 12 3x4   6007319.73993 2102042.10408 37.7522209377659 -122.417559493969 (37.7522209377659, -122.417559493969) 2 4 7 28859 19
79503 656 1 97 3255X 24th St 4 Sidewalk: Curb side : Cutout Tree 7     12 4x4   6007336.00672 2102041.77073 37.7522209377618 -122.417503217111 (37.7522209377618, -122.417503217111) 2 4 7 28859 19
156055 653 1 53 3255X 24th St 1 Sidewalk: Curb side : Cutout Tree 7     3 4x4   6007260.4251 2102038.7621 37.7522084236972 -122.417764377532 (37.7522084236972, -122.417764377532) 2 4 7 28859 19
1244 27591 7 78 2100X San Bruno Ave 4 Sidewalk: Curb side : Cutout Tree 7   06/21/2001 12:00:00 AM 3 3x3   6009789.2811665 2096218.949435 37.7363704769246 -122.408608649696 (37.7363704769246, -122.408608649696) 10 7 7 309 2
76183 27589 7 78 2100X San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree 7   06/21/2001 12:00:00 AM 3 3X3   6009789.2811665 2096218.949435 37.7363704769246 -122.408608649696 (37.7363704769246, -122.408608649696) 10 7 7 309 2
88124 27588 7 78 2100X San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree 7   06/21/2001 12:00:00 AM 3 3X3   6009789.2811665 2096218.949435 37.7363704769246 -122.408608649696 (37.7363704769246, -122.408608649696) 10 7 7 309 2
159213 27590 7 78 2100X San Bruno Ave 3 Sidewalk: Curb side : Cutout Tree 7   06/21/2001 12:00:00 AM 3 3X3   6009789.2811665 2096218.949435 37.7363704769246 -122.408608649696 (37.7363704769246, -122.408608649696) 10 7 7 309 2
166245 27592 7 78 2100X San Bruno Ave 5 Sidewalk: Curb side : Cutout Tree 7   06/21/2001 12:00:00 AM 3 3X3   6009789.2811665 2096218.949435 37.7363704769246 -122.408608649696 (37.7363704769246, -122.408608649696) 10 7 7 309 2
1137 24844 7 173 200X Alemany Blvd 22 Sidewalk: Curb side : Cutout Tree 7   01/12/1996 12:00:00 AM 20 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
29792 24841 7 304 200X Alemany Blvd 19 Sidewalk: Curb side : Cutout Tree 7   01/12/1996 12:00:00 AM 8 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
45261 24827 7 26 200X Alemany Blvd 5 Sidewalk: Curb side : Cutout Tree 7   01/29/1998 12:00:00 AM 20 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
48101 24845 7 26 200X Alemany Blvd 23 Sidewalk: Curb side : Cutout Tree 7   01/29/1998 12:00:00 AM 25 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
49822 24833 7 122 200X Alemany Blvd 11 Sidewalk: Curb side : Cutout Tree 7   01/12/1996 12:00:00 AM 25 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
65777 24837 7 16 200X Alemany Blvd 15 Sidewalk: Curb side : Cutout Tree 7   01/12/1996 12:00:00 AM 8 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
67462 24840 7 16 200X Alemany Blvd 18 Sidewalk: Curb side : Cutout Tree 7   01/12/1996 12:00:00 AM 18 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
77805 24832 7 9 200X Alemany Blvd 10 Sidewalk: Curb side : Cutout Tree 7   01/12/1996 12:00:00 AM 6 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
87182 24843 7 16 200X Alemany Blvd 21 Sidewalk: Curb side : Cutout Tree 7   01/12/1996 12:00:00 AM 6 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
99123 24831 7 9 200X Alemany Blvd 9 Sidewalk: Curb side : Cutout Tree 7   01/12/1996 12:00:00 AM 6 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
101528 24842 7 75 200X Alemany Blvd 20 Sidewalk: Curb side : Cutout Tree 7   01/12/1996 12:00:00 AM 3 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
112402 24830 7 9 200X Alemany Blvd 8 Sidewalk: Curb side : Cutout Tree 7   01/12/1996 12:00:00 AM 6 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
116587 24836 7 16 200X Alemany Blvd 14 Sidewalk: Curb side : Cutout Tree 7   01/12/1996 12:00:00 AM 18 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
145085 24838 7 75 200X Alemany Blvd 16 Sidewalk: Curb side : Cutout Tree 7   01/12/1996 12:00:00 AM 6 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
152434 24828 7 173 200X Alemany Blvd 6 Sidewalk: Curb side : Cutout Tree 7   01/12/1996 12:00:00 AM 18 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
154722 24846 7 75 200X Alemany Blvd 24 Sidewalk: Curb side : Cutout Tree 7   01/29/1998 12:00:00 AM 3 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
186752 24839 7 173 200X Alemany Blvd 17 Sidewalk: Curb side : Cutout Tree 7   01/12/1996 12:00:00 AM 30 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
91118 24820 1 122 400X Alemany Blvd 12 Sidewalk: Curb side : Cutout Tree 7   05/22/2008 12:00:00 AM 12 3x3   6007910.58435 2094958.48618 37.7328041215156 -122.415014921609 (37.7328041215156, -122.415014921609) 2 7 7 28859 2