trees

Custom SQL query returning 31 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
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
38544 14628 7 27 460 McAllister St 1 Sidewalk: Curb side : Cutout Tree 7     20 3X3   6006936.4820313 2112240.9458517 37.7802029857658 -122.419608403425 (37.7802029857658, -122.419608403425) 7 9 9 28852 36
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
55672 23150 7 11 50 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree 7     3 3X3   6007031.8302252 2110521.0652082 37.7754859780082 -122.419156518057 (37.7754859780082, -122.419156518057) 7 9 9 28852 36
56609 9951 7 27 95X Grove St 2 Sidewalk: Curb side : Cutout Tree 7     18 3X3   6007383.306516 2111592.002729 37.7784463030985 -122.418016611499 (37.7784463030985, -122.418016611499) 7 9 9 28852 36
65065 23151 7 11 50 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree 7   08/24/1993 12:00:00 AM 8 3X3   6007030.5326516 2110530.1061031 37.7755107290659 -122.419161648128 (37.7755107290659, -122.419161648128) 7 9 9 28852 36
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
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
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
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
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
102440 14627 7 27 410X McAllister St 2 Sidewalk: Curb side : Cutout Tree 7     35 3X3   6007165.24508 2112272.29684 37.7803019512551 -122.418819229453 (37.7803019512551, -122.418819229453) 7 9 9 28852 36
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
122483 14626 7 148 410X McAllister St 1 Sidewalk: Curb side : Cutout Tree 7   01/05/2001 12:00:00 AM 20 3X3   6007165.24508 2112272.29684 37.7803019512551 -122.418819229453 (37.7803019512551, -122.418819229453) 7 9 9 28852 36
125734 26896 7 27 460 McAllister St 2 Sidewalk: Curb side : Cutout Tree 7     20 3X3   6006936.4820313 2112240.9458517 37.7802029857658 -122.419608403425 (37.7802029857658, -122.419608403425) 7 9 9 28852 36
128940 23156 7 11 50 Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree 7   08/24/1993 12:00:00 AM 18 3X3   6007006.484382 2110627.274272 37.7757761752428 -122.419251731369 (37.7757761752428, -122.419251731369) 7 9 9 28852 36
133044 9953 7 27 95X Grove St 4 Sidewalk: Curb side : Cutout Tree 7   12/17/2009 12:00:00 AM 12 3X3   6007383.306516 2111592.002729 37.7784463030985 -122.418016611499 (37.7784463030985, -122.418016611499) 7 9 9 28852 36
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
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
165205 9950 7 27 95X Grove St 1 Sidewalk: Curb side : Cutout Tree 7     18 3X3   6007383.306516 2111592.002729 37.7784463030985 -122.418016611499 (37.7784463030985, -122.418016611499) 7 9 9 28852 36
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
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