trees

Custom SQL query returning 30 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
159787 203555 1 65 209 Farallones St 2 Sidewalk: Curb side : Cutout Tree 2     14 Width 2ft   5994968.99544 2088379.28856 37.7140034838548 -122.459280689461 (37.7140034838548, -122.459280689461) 9 8 6 28861 24
1937 78248 1 65 734 Vienna St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   14     6002539.24351 2089283.26415 37.716917933889 -122.433179625239 (37.716917933889, -122.433179625239) 9 7 6 28861 5
21642 38204 1 65 691 Goettingen St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/17/1998 12:00:00 AM 14   Permit Number 40328 6010720.89935 2091470.20831 37.7233835629968 -122.405053372309 (37.7233835629968, -122.405053372309) 10 3 7 309 28
18137 70176 1 65 307 Athens St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   14 3.5x4 to 3.5x7   6004287.81152 2091470.53201 37.7230227297861 -122.42729139329 (37.7230227297861, -122.42729139329) 9 7 6 28861 5
46915 38203 1 65 691 Goettingen St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 07/17/1998 12:00:00 AM 14   Permit Number 40328 6010707.71448 2091513.67595 37.7235021790704 -122.405102009451 (37.7235021790704, -122.405102009451) 10 3 7 309 28
93508 203530 1 65 355 Granada Ave 1 Sidewalk: Curb side : Cutout Tree 2     14 Width 2ft   5995608.47907 2092372.56646 37.7250048247995 -122.457359125149 (37.7250048247995, -122.457359125149) 9 7 4 28861 40
30708 175201 1 65 648 Peru Ave 7 Side Yard : Yard Tree 2     14     6005063.1365 2092591.26253 37.7261438278596 -122.424690937041 (37.7261438278596, -122.424690937041) 9 7 6 28861 5
186585 175207 1 65 9 Athens St 1 Sidewalk: Curb side : Cutout Tree 2     14 Width 2ft   6005359.84242 2093211.49837 37.7278636122004 -122.423709320725 (37.7278636122004, -122.423709320725) 9 7 6 28861 5
46307 203579 1 65 312 Joost Ave 2 Sidewalk: Property side : Yard Tree 2     14 Width 6ft   5999939.25303 2094981.39881 37.7324158679899 -122.44257538767 (37.7324158679899, -122.44257538767) 9 7 4 63 40
135296 221865 1 65 592 Laidley St 2 Sidewalk: Curb side : Cutout Tree 2     14 Width 3ft   6002930.8792 2095923.87336 37.7351737658507 -122.432299929108 (37.7351737658507, -122.432299929108) 2 7 5 63 7
186207 114881 4 65 122 COLLEGE AVE 1 Sidewalk: Curb side : Cutout Tree 2     14 3x3   6004593 2095924 37.7352682180932 -122.426553380791 (37.7352682180932, -122.426553380791) 2 7 5 28861 2
130024 221936 1 65 48 Harper St 1 Sidewalk: Curb side : Cutout Tree 2     14 Width 4ft   6003658.55433 2098021.59816 37.7409748723836 -122.429933678794 (37.7409748723836, -122.429933678794) 2 7 5 63 7
47768 221885 1 65 100 Manchester St 1 Sidewalk: Curb side : Cutout Tree 2     14 Width 3ft   6008227.02437 2099369.61702 37.7449338966774 -122.414232888254 (37.7449338966774, -122.414232888254) 2 7 7 28859 2
159038 221793 1 65 26 Norwich St 1 Sidewalk: Curb side : Cutout Tree 2     14 Width 5ft   6009169.37019 2099491.8572 37.745322428991 -122.410983048655 (37.745322428991, -122.410983048655) 2 7 7 28859 2
43175 38227 1 65 1099 Mississippi St 4 Sidewalk: Curb side : Cutout Tree 2   07/21/1998 12:00:00 AM 14   Permit Number 40351 6014264.01456 2102105.05687 37.7527820922208 -122.393549330162 (37.7527820922208, -122.393549330162) 10 3 8 28856 29
162952 221836 1 65 585 Capp St 1 Sidewalk: Curb side : Cutout Tree 2     14 Width 3ft   6007298.30885 2103900.40234 37.7573221936904 -122.417765313729 (37.7573221936904, -122.417765313729) 2 4 7 28859 19
99508 221835 1 65 585 Capp St 2 Sidewalk: Curb side : Cutout Tree 2     14 Width 3ft   6007295.48201 2103941.69106 37.7574354039359 -122.41777801665 (37.7574354039359, -122.41777801665) 2 4 7 28859 19
41894 221832 1 65 573 Capp St 1 Sidewalk: Curb side : Cutout Tree 2     14 Width 3ft   6007293.28891 2103997.59658 37.7575887842104 -122.417789563935 (37.7575887842104, -122.417789563935) 2 4 7 28859 19
93867 189215 1 65 1400 20th St 2 : Tree 2     14 Width 3ft   6013696.29673 2104791.67795 37.7601274111746 -122.395700842123 (37.7601274111746, -122.395700842123) 10 3 8 28856 29
77208 37072 1 65 1426 43rd Ave 2 Sidewalk: Curb side : Cutout Tree 2 FUF 06/15/1998 12:00:00 AM 14   Permit Number 39847 5982799.9219 2105403.4894 37.7600401558558 -122.502600230953 (37.7600401558558, -122.502600230953) 1 8 3 56 35
130358 247338 1 65 220 Scott St 1 Sidewalk: Curb side : Cutout Tree 2     14 Width 0ft   6002315.9732 2109334.9211 37.7719624169971 -122.435384903619 (37.7719624169971, -122.435384903619) 15 5 11 29492 9
144210 122028 1 65 4200 Fulton St 1 Sidewalk: Curb side : Cutout Tree 2     14 Width 4ft   5990335.88311 2109958.87683 37.7729879776993 -122.476870087567 (37.7729879776993, -122.476870087567) 11 6 2 55 26
92411 244965 1 65 250 Lily St 3 Sidewalk: Curb side : Cutout Tree 2     14 Width 0ft   6005276.5809 2110102.9361 37.7742388930949 -122.42519859053 (37.7742388930949, -122.42519859053) 7 9 11 28852 10
194425 221795 3 65 438 Webster St 1 Sidewalk: Curb side : Cutout Tree 2     14 Width 3ft Permit Number 787981 6004107.34969 2110372.49722 37.7749129194169 -122.42926239785 (37.7749129194169, -122.42926239785) 7 9 11 28852 10
135740 112364 4 65 501X 09TH AVE 1 Sidewalk: Curb side : Cutout Tree 2     14 3x3   5993143 2111731 37.7780161887977 -122.467288887933 (37.7780161887977, -122.467288887933) 11 6 2 54 11
15128 70636 1 65 249 20th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF   14     5989603.89345 2113698.71942 37.7832140576516 -122.479675795688 (37.7832140576516, -122.479675795688) 11 6 2 55 26
99540 124272 1 65 2 03rd Ave 1 Front Yard : Yard Tree 2     14     5994894.05661 2114999.9706 37.787092832167 -122.46146845316 (37.787092832167, -122.46146845316) 11 6 1 54 11
175001 124270 1 65 2 03rd Ave 3 Front Yard : Yard Tree 2     14     5994893.51688 2115041.88961 37.78720789934 -122.461473360648 (37.78720789934, -122.461473360648) 11 6 1 54 11
193967 125548 1 65 1445 Greenwich St 5 Sidewalk: Curb side : Cutout Tree 2     14 Width 4ft   6006007.30583 2119647.97872 37.8004884684307 -122.423349556855 (37.8004884684307, -122.423349556855) 13 9 1 28858 32
164826 66782 1 65 1001 Chestnut St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 09/20/1991 12:00:00 AM 14   Permit Number 30052 6006921.4512 2120474.40868 37.8028091860666 -122.420244926256 (37.8028091860666, -122.420244926256) 5 1 1 28858 32