trees

Custom SQL query returning 33 rows (hide)

Query parameters

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
19904 107842 4 173 407 09TH ST 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6009856.3 2109387.9 37.7725332267653 -122.409305976048 (37.7725332267653, -122.409305976048) 14 2 9 28853 34
20892 98486 7 173 531X Franconia St 11 Sidewalk: Curb side : Cutout Tree 1     9 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
50644 82681 7 173 1 Ignacio Ave 2 Sidewalk: Curb side : Cutout Tree 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52489 6015442.02605155 2088342.25147664 37.7150575952078 -122.388514940902 (37.7150575952078, -122.388514940902) 10 3 8 58 1
52187 202057 1 173 1249 Jamestown Ave 7 Sidewalk: Property side : Yard Tree 2     8     6012780.62954 2090484.81642 37.7207928041369 -122.397864130747 (37.7207928041369, -122.397864130747) 10 3 8 58 1
60895 36135 7 173 1708 Irving St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 04/29/1998 12:00:00 AM     Permit Number 39228 5990464.01756752 2106564.28679839 37.7636747855938 -122.47617887015 (37.7636747855938, -122.47617887015) 11 8 3 56 12
64573 107843 4 173 407 09TH ST 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6009856.3 2109387.9 37.7725332267653 -122.409305976048 (37.7725332267653, -122.409305976048) 14 2 9 28853 34
66051 82678 7 173 1 Ignacio Ave 5 Sidewalk: Curb side : Cutout Tree 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52489 6015442.02605155 2088342.25147664 37.7150575952078 -122.388514940902 (37.7150575952078, -122.388514940902) 10 3 8 58 1
71967 82680 7 173 1 Ignacio Ave 3 Sidewalk: Curb side : Cutout Tree 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52489 6015442.02605155 2088342.25147664 37.7150575952078 -122.388514940902 (37.7150575952078, -122.388514940902) 10 3 8 58 1
72412 98474 7 173 531X Franconia St 1 Sidewalk: Curb side : Cutout Tree 1     12 6x6   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
73564 202058 1 173 1249 Jamestown Ave 8 Sidewalk: Property side : Yard Tree 2     13     6012815.62965 2090457.48814 37.7207197153194 -122.397741229389 (37.7207197153194, -122.397741229389) 10 3 8 58 1
98108 82682 7 173 1 Ignacio Ave 1 Sidewalk: Curb side : Cutout Tree 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52489 6015442.02605155 2088342.25147664 37.7150575952078 -122.388514940902 (37.7150575952078, -122.388514940902) 10 3 8 58 1
102541 36134 7 173 1708 Irving St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 04/29/1998 12:00:00 AM     Permit Number 39228 5990464.01756752 2106564.28679839 37.7636747855938 -122.47617887015 (37.7636747855938, -122.47617887015) 11 8 3 56 12
109610 49956 7 173 541@ ALVARADO Diamond St 1 Sidewalk: Curb side : Cutout Tree 2   07/03/2003 12:00:00 AM     Permit Number 46710 6001870.95362569 2102681.92847846 37.7536696397315 -122.43644800428 (37.7536696397315, -122.43644800428) 2 4 5 28862 22
110766 107841 1 173 407 09th St 2 Sidewalk: Curb side : Cutout Tree 2     17 3x3   6009830.23681 2109237.43291 37.7721186188114 -122.40938551093 (37.7721186188114, -122.40938551093) 14 2 9 28853 34
113087 112151 4 173 299x SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree 5     10 3x3   6007772 2106483 37.7644400562771 -122.416310015149 (37.7644400562771, -122.416310015149) 8 4 7 28859 19
114676 98482 7 173 531X Franconia St 7 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
118106 82679 7 173 1 Ignacio Ave 4 Sidewalk: Curb side : Cutout Tree 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52489 6015442.02605155 2088342.25147664 37.7150575952078 -122.388514940902 (37.7150575952078, -122.388514940902) 10 3 8 58 1
124653 107845 4 173 407 09TH ST 6 Sidewalk: Curb side : Cutout Tree 2       3x3   6009856.3 2109387.9 37.7725332267653 -122.409305976048 (37.7725332267653, -122.409305976048) 14 2 9 28853 34
131874 82706 7 173 728 Jamestown Ave 2 Sidewalk: Curb side : Cutout Tree 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52492 6015281.34869038 2088403.74887582 37.7152175495908 -122.389074606621 (37.7152175495908, -122.389074606621) 10 3 8 58 1
148605 107846 1 173 407 09th St 7 Sidewalk: Curb side : Cutout Tree 2     12 3x3   6009780.079 2109294.20341 37.7722716870121 -122.409563019144 (37.7722716870121, -122.409563019144) 14 2 9 28853 34
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
159959 98480 7 173 531X Franconia St 5 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
160396 82709 7 173 9 Ignacio Ave 5 Sidewalk: Curb side : Cutout Tree 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52491 6015428.30253867 2088370.80983531 37.7151352504121 -122.388564367914 (37.7151352504121, -122.388564367914) 10 3 8 58 1
173628 107840 1 173 407 09th St 1 Sidewalk: Curb side : Cutout Tree 2     14 3x3   6009841.61073 2109223.26408 37.7720803517525 -122.409345167358 (37.7720803517525, -122.409345167358) 14 2 9 28853 34
178220 107844 4 173 407 09TH ST 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6009856.3 2109387.9 37.7725332267653 -122.409305976048 (37.7725332267653, -122.409305976048) 14 2 9 28853 34
179653 97035 8 173 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
183148 112154 4 173 299x SHOTWELL ST 4 Sidewalk: Curb side : Cutout Tree 5       3x3   6007772 2106483 37.7644400562771 -122.416310015149 (37.7644400562771, -122.416310015149) 8 4 7 28859 19
183621 98476 7 173 531X Franconia St 3 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 10 7 7 28859 2
184860 112153 4 173 299x SHOTWELL ST 3 Sidewalk: Curb side : Cutout Tree 5       3x3   6007772 2106483 37.7644400562771 -122.416310015149 (37.7644400562771, -122.416310015149) 8 4 7 28859 19
185188 98484 7 173 531X Franconia St 9 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514) 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
194057 107847 1 173 407 09th St 8 Sidewalk: Curb side : Cutout Tree 2     16 3x3   6009772.46475 2109302.10129 37.7722929460963 -122.409589915155 (37.7722929460963, -122.409589915155) 14 2 9 28853 34