trees

Custom SQL query returning 20 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
174521 258525 6 95 50 Hermann St 1 Sidewalk: Property side : Cutout Tree 2           6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10
60900 103616 6 95 201X Haight St 1 Sidewalk: Property side : Yard Tree 2           6004725 2109149 37.7715884407354 -122.427038651796 (37.7715884407354, -122.427038651796) 7 9 11 28852 10
128687 62278 7 95 391 Haight St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22416 6004275.31529715 2109405.62927883 37.7722676437754 -122.428612433422 (37.7722676437754, -122.428612433422) 7 9 11 28852 10
11806 233511 1 95 301 Haight St 1 Sidewalk: Curb side : Cutout Tree 2   06/08/2018 12:00:00 AM 3 Width 3ft Permit Number 782005 6004633.78606 2109456.48744 37.7724275683009 -122.427376074351 (37.7724275683009, -122.427376074351) 7 9 11 28852 10
121551 30727 7 95 45 Rose St 3 Sidewalk: Curb side : Cutout Tree 2 FUF 01/31/1995 12:00:00 AM     Permit Number 34624 6006303.86733164 2109861.47838862 37.7736338888904 -122.421627862373 (37.7736338888904, -122.421627862373) 7 9 11 28852 10
77613 66110 7 95 124 Page St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 08/15/1990 12:00:00 AM     Permit Number 29164 6005954.05152204 2110038.74835026 37.7741008978737 -122.422850531283 (37.7741008978737, -122.422850531283) 7 9 11 28852 10
113409 92745 7 95 65 Lily St 1 Sidewalk: Curb side : Cutout Tree 2   10/02/2009 12:00:00 AM     Permit Number 52969 6006237.3 2110147.2 37.7744146578956 -122.42187842919 (37.7744146578956, -122.42187842919) 7 9 11 28852 10
77554 115072 4 95 65 LILY ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6006230 2110204 37.7745702053319 -122.421907716929 (37.7745702053319, -122.421907716929) 7 9 11 28852 10
126757 233595 1 95 65 Lily St 2 Sidewalk: Curb side : Cutout Tree 2     4 Width 4ft   6006199.44 2110210.42189 37.7745861147813 -122.422013886425 (37.7745861147813, -122.422013886425) 7 9 11 28852 10
27505 233596 1 95 44 Franklin St 1 Sidewalk: Curb side : Cutout Tree 2     14 Width 4ft   6006549.90248 2110330.35444 37.7749351803449 -122.420810081832 (37.7749351803449, -122.420810081832) 7 9 11 28852 10
121967 233509 1 95 599 Buchanan St 3 Sidewalk: Curb side : Yard Tree 2     2 Width 6ft   6004544.20196 2110431.59381 37.7750999055671 -122.427755444356 (37.7750999055671, -122.427755444356) 7 9 11 28852 10
127438 6957 1 95 627 Fell St 1 Sidewalk: Curb side : Cutout Tree 2     12 3X3   6004338.3385 2110455.1046 37.7751528130593 -122.428469247762 (37.7751528130593, -122.428469247762) 7 9 11 28852 10
158702 16839 1 95 97X Oak St 1 Sidewalk: Curb side : Cutout Tree 1   11/17/1999 12:00:00 AM 75 3X3   6006555.51402 2110416.39536 37.7751717443167 -122.420796779971 (37.7751717443167, -122.420796779971) 7 9 11 28852 10
118036 7723 1 95 175X Fell St 1 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6006514.1274 2110757.9768 37.7761073119325 -122.420964203399 (37.7761073119325, -122.420964203399) 7 9 11 28852 10
53952 233597 1 95 197 Fell St 1 Sidewalk: Curb side : Cutout Tree 2     12 Width 4ft   6006526.51025 2110764.29313 37.776125353047 -122.420921816282 (37.776125353047, -122.420921816282) 7 9 11 28852 10
66091 100771 6 95 450 Hayes St 2 Back Yard : Yard Tree 2         Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
100606 100772 6 95 450 Hayes St 3 Back Yard : Yard Tree 2         Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
147643 100770 6 95 450 Hayes St 1 Back Yard : Yard Tree 2         Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
48151 98950 6 95 401 Grove St 10 Front Yard : Yard Tree 2           6005778.2 2111279 37.7774964045324 -122.423547027313 (37.7774964045324, -122.423547027313) 7 9 11 28852 10
69454 98948 6 95 401 Grove St 8 Front Yard : Yard Tree 2           6005778.2 2111279 37.7774964045324 -122.423547027313 (37.7774964045324, -122.423547027313) 7 9 11 28852 10