trees

Custom SQL query returning 23 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
133197 51064 7 68 10 South Van Ness Ave 5 Sidewalk: Curb side : Cutout Tree 2   07/14/2004 12:00:00 AM     Permit Number 47529 6006972.51081745 2110293.55168859 37.7748579396097 -122.419345575047 (37.7748579396097, -122.419345575047) 8 2 9 28853 19
133845 49367 7 68 1328@ 4th & 5t Anza St 1 Sidewalk: Curb side : Cutout Tree 2   04/29/2005 12:00:00 AM     Permit Number 47977 5994585.78557071 2112147.74022661 37.7792436288989 -122.462328048371 (37.7792436288989, -122.462328048371) 11 6 2 54 11
138611 237972 1 68 400 Prospect Ave 14 Sidewalk: Property side : Yard Tree 2     11     6006214.1673 2097605.70169 37.7399773120135 -122.421067769962 (37.7399773120135, -122.421067769962) 2 7 7 28859 2
139351 96677 7 68 1701 21st Ave 2 Sidewalk: Curb side : Cutout Tree 2         Permit Number 767971 5989644.3 2103769.9 37.7559545815884 -122.478809598698 (37.7559545815884, -122.478809598698) 1 8 3 56 35
139368 50308 7 68 701 (REVISED) Grafton Ave 1 Sidewalk: Curb side : Cutout Tree 2   12/30/2003 12:00:00 AM     Permit Number 47019 5994734.51143453 2090549.74162157 37.7199495485694 -122.460248307265 (37.7199495485694, -122.460248307265) 9 8 6 28861 24
151000 51061 7 68 10 South Van Ness Ave 8 Sidewalk: Curb side : Cutout Tree 2   07/14/2004 12:00:00 AM     Permit Number 47529 6006972.51081745 2110293.55168859 37.7748579396097 -122.419345575047 (37.7748579396097, -122.419345575047) 8 2 9 28853 19
154500 213704 1 68 635 Mangels Ave 1 Sidewalk: Property side : Yard Tree 2     15     5997206.92035 2095245.84356 37.7329858403205 -122.452040726125 (37.7329858403205, -122.452040726125) 9 7 4 59 40
154514 109243 7 68 755 Buena Vista Ave 2 Sidewalk: Curb side : Cutout Tree 2     4     5999798.5 2108081.7 37.7683780948237 -122.444002941237 (37.7683780948237, -122.444002941237) 15 5 11 29492 9
163037 136022 1 68 60 MacOndray Ln 2 Sidewalk: Property side : Yard Tree 2     6     6008402.81482 2119144.69077 37.7992414720639 -122.415024460715 (37.7992414720639, -122.415024460715) 5 1 10 308 32
166835 196065 1 68 602 Arthur Ave 28 Front Yard : Yard Tree 2     3     6015745.27894 2099859.59173 37.7466987082831 -122.388270101098 (37.7466987082831, -122.388270101098)   3 8 58 1
172665 179165 1 68 671 London St 1 Sidewalk: Curb side : Yard Tree 2     3     6001067.99101 2089902.67343 37.7185351226768 -122.438309369006 (37.7185351226768, -122.438309369006) 9 7 6 28861 5
172948 51060 7 68 10 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree 2   07/14/2004 12:00:00 AM     Permit Number 47529 6006972.51081745 2110293.55168859 37.7748579396097 -122.419345575047 (37.7748579396097, -122.419345575047) 8 2 9 28853 19
173341 51063 7 68 10 South Van Ness Ave 6 Sidewalk: Curb side : Cutout Tree 2   07/14/2004 12:00:00 AM     Permit Number 47529 6006972.51081745 2110293.55168859 37.7748579396097 -122.419345575047 (37.7748579396097, -122.419345575047) 8 2 9 28853 19
173631 96998 6 68 2451X Griffith St   Sidewalk: Property side : Cutout Tree 15 FUF         6015858.3 2090034.7 37.7197277910807 -122.387194089236 (37.7197277910807, -122.387194089236) 10 3 8 58 1
174186 105781 1 68 1631 MCALLISTER ST 1 Sidewalk: Curb side : Cutout Tree 2   03/03/2014 12:00:00 AM     Permit Number 772613 6001347.6 2111440.1 37.7776876665107 -122.43888545994 (37.7776876665107, -122.43888545994) 15 5 11 29492 41
174316 50441 7 68 1539 Funston Ave 5 Sidewalk: Curb side : Cutout Tree 2   10/09/2003 12:00:00 AM     Permit Number 47091 5992108.98793904 2104967.81344644 37.7593865436509 -122.47037320979 (37.7593865436509, -122.47037320979) 1 8 4 56 12
174947 50443 7 68 1539 Funston Ave 2 Sidewalk: Curb side : Cutout Tree 2   10/09/2003 12:00:00 AM     Permit Number 47091 5992108.98793904 2104967.81344644 37.7593865436509 -122.47037320979 (37.7593865436509, -122.47037320979) 1 8 4 56 12
190293 136023 1 68 60 MacOndray Ln 3 Sidewalk: Property side : Yard Tree 2     3     6008389.23117 2119145.89275 37.7992440090735 -122.415071550105 (37.7992440090735, -122.415071550105) 5 1 10 308 32
190691 196373 1 68 1900 19th St 2 Front Yard : Yard Tree 2     1     6012066.64129 2105141.25616 37.760996487211 -122.401361645431 (37.760996487211, -122.401361645431) 10 3 8 28856 29
191512 40428 7 68 29 Colby St 1 Sidewalk: Curb side : Cutout Tree 2   06/03/1999 12:00:00 AM     Permit Number 41523 6007969.10251409 2094049.49213596 37.7303115087504 -122.414748301777 (37.7303115087504, -122.414748301777) 9 3 7 309 28
191781 196068 1 68 1700 Armstrong Ave 9 Side Yard : Yard Tree 2     3     6013885.20395 2092887.61216 37.7274518522042 -122.394214063144 (37.7274518522042, -122.394214063144) 10 3 8 58 1
191979 196066 1 68 602 Arthur Ave 29 Front Yard : Yard Tree 2     3     6015729.65904 2099863.28866 37.7467079937826 -122.38832437159 (37.7467079937826, -122.38832437159)   3 8 58 1
193278 50442 7 68 1539 Funston Ave 3 Sidewalk: Curb side : Cutout Tree 2   10/09/2003 12:00:00 AM     Permit Number 47091 5992108.98793904 2104967.81344644 37.7593865436509 -122.47037320979 (37.7593865436509, -122.47037320979) 1 8 4 56 12