trees
3,247 rows where qSpecies_id = 22 sorted by qSiteInfo
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 174415 | 190420 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 16 | : | Tree | Private 2 | 6 | Width 3ft | 6017827.78919 | 2096970.13088 | 37.7388800015007 | -122.380868079005 | (37.7388800015007, -122.380868079005) | 10 | 3 | 8 | 58 | 1 | |||
| 177880 | 190433 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 32 | : | Tree | Private 2 | 3 | Width 3ft | 6017527.81682 | 2097194.77168 | 37.7394802593972 | -122.381920875742 | (37.7394802593972, -122.381920875742) | 10 | 3 | 8 | 58 | 1 | |||
| 180276 | 190422 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 18 | : | Tree | Private 2 | 5 | Width 3ft | 6017797.18223 | 2096994.03226 | 37.7389439406012 | -122.380975565973 | (37.7389439406012, -122.380975565973) | 10 | 3 | 8 | 58 | 1 | |||
| 180713 | 192437 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 106 Langton St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6010237.3697 | 2110691.53515 | 37.7761340485805 | -122.408079765481 | (37.7761340485805, -122.408079765481) | 8 | 2 | 9 | 28853 | 34 | |||
| 183852 | 192441 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 10 McLea Ct | 5 | : | Tree | Private 2 | 2 | Width 3ft | 6010051.80213 | 2109236.00979 | 37.7721271227961 | -122.408618994484 | (37.7721271227961, -122.408618994484) | 14 | 2 | 9 | 28853 | 34 | |||
| 184515 | 190426 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 24 | : | Tree | Private 2 | 2 | Width 3ft | 6017676.69292 | 2097082.96184 | 37.7391814722423 | -122.381398348955 | (37.7391814722423, -122.381398348955) | 10 | 3 | 8 | 58 | 1 | |||
| 184629 | 192440 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 10 McLea Ct | 3 | : | Tree | Private 2 | 2 | Width 3ft | 6010071.61086 | 2109254.18785 | 37.7721781449322 | -122.408551756678 | (37.7721781449322, -122.408551756678) | 14 | 2 | 9 | 28853 | 34 | |||
| 184906 | 192439 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 8 McLea Ct | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6010092.24423 | 2109274.67228 | 37.772235545969 | -122.408481828984 | (37.772235545969, -122.408481828984) | 14 | 2 | 9 | 28853 | 34 | |||
| 185585 | 190448 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1498 Evans Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6016474.94651 | 2097978.89323 | 37.7415750988015 | -122.385615909472 | (37.7415750988015, -122.385615909472) | 10 | 3 | 8 | 58 | 1 | |||
| 186877 | 190424 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 22 | : | Tree | Private 2 | 1 | Width 3ft | 6017710.59589 | 2097057.73864 | 37.7391140860314 | -122.381279373169 | (37.7391140860314, -122.381279373169) | 10 | 3 | 8 | 58 | 1 | |||
| 189583 | 190447 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1201 Evans Ave | 5 | : | Tree | Private 2 | 3 | Width 3ft | 6017726.41303 | 2096927.8119 | 37.7387582063175 | -122.381215652579 | (37.7387582063175, -122.381215652579) | 10 | 3 | 8 | 58 | 1 | |||
| 189680 | 190400 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 9 | : | Tree | Private 2 | 2 | Width 3ft | 6012170.1171 | 2100910.58495 | 37.7493857629599 | -122.400706546863 | (37.7493857629599, -122.400706546863) | 10 | 3 | 8 | 58 | 1 | |||
| 191635 | 225986 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 68 McCoppin St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6006193.46964 | 2109164.47862 | 37.7717138690364 | -122.421960222999 | (37.7717138690364, -122.421960222999) | 8 | 2 | 9 | 28853 | 19 | |||
| 53372 | 87302 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 4 | Back Yard : Cutout | Tree | Private 2 | 1 | Permit Number 50312 | 6011942.20762 | 2100900.73993 | 37.7493460165275 | -122.401493976188 | (37.7493460165275, -122.401493976188) | 10 | 3 | 8 | 58 | 1 | |||
| 16438 | 87300 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 2 | Back Yard : Yard | Tree | DPW 1 | 6 | Permit Number 50312 | 6011877.98748 | 2100898.05147 | 37.749335051069 | -122.401715863223 | (37.749335051069, -122.401715863223) | 10 | 3 | 8 | 58 | 1 | |||
| 41458 | 87301 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 3 | Back Yard : Yard | Tree | DPW 1 | 5 | Permit Number 50312 | 6011915.6161 | 2100899.61614 | 37.7493414470685 | -122.401585851825 | (37.7493414470685, -122.401585851825) | 10 | 3 | 8 | 58 | 1 | |||
| 127414 | 87299 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 1 | Back Yard : Yard | Tree | DPW 1 | 4 | Permit Number 50312 | 6011851.38946 | 2100896.59511 | 37.7493295679091 | -122.401807737936 | (37.7493295679091, -122.401807737936) | 10 | 3 | 8 | 58 | 1 | |||
| 135121 | 98310 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 1499@Newhall Evans Ave | 2 | Front Yard : | Tree | Private 2 | 01/25/2012 12:00:00 AM | 4 | Permit Number 768575 | 6016248.7932 | 2098029.27381 | 37.7417009175609 | -122.386401389915 | (37.7417009175609, -122.386401389915) | 10 | 3 | 8 | 58 | 1 | ||
| 62 | 264980 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 222 Winfield St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6006740 | 2098205 | 37.7416524795013 | -122.419292156581 | (37.7416524795013, -122.419292156581) | 2 | 7 | 7 | 28859 | 2 | ||||
| 48619 | 253373 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 78 Peralta Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6010457 | 2100357 | 37.7477700431666 | -122.406591570174 | (37.7477700431666, -122.406591570174) | 2 | 7 | 7 | 28859 | 2 | ||||
| 68370 | 249647 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2460 Lyon St | 7 | Front Yard : Yard | Tree | Private 2 | 18 | Width 10ft | 5999284.57219 | 2117293.77828 | 37.7936427489551 | -122.446443378971 | (37.7936427489551, -122.446443378971) | 13 | 9 | 1 | 57 | 27 | |||
| 89341 | 249650 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2401 Lyon St | 2 | Front Yard : Yard | Tree | Private 2 | 3 | Width 10ft | 5999216.24829 | 2117285.03492 | 37.7936148393952 | -122.446679155136 | (37.7936148393952, -122.446679155136) | 11 | 1 | 57 | 30 | ||||
| 92572 | 226043 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 San Jose Ave | 6 | Front Yard : Yard | Tree | Private 2 | 6 | 6003683.45226 | 2095797.63784 | 37.7348697950059 | -122.429689011034 | (37.7348697950059, -122.429689011034) | 2 | 7 | 5 | 63 | 7 | ||||
| 101940 | 88446 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1629 Green St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | 3x3 | Permit Number 51411 | 6005229.98772 | 2118491.64787 | 37.7972695780743 | -122.425957034113 | (37.7972695780743, -122.425957034113) | 13 | 9 | 1 | 57 | 17 | ||
| 105614 | 226042 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 200 Eugenia Ave | 4 | Front Yard : Yard | Tree | Private 2 | 2 | 6006560.74599 | 2098108.17356 | 37.7413765186154 | -122.419905088663 | (37.7413765186154, -122.419905088663) | 2 | 7 | 7 | 28859 | 2 | ||||
| 160602 | 250211 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 212 Union St | 7 | Front Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6011741.8662 | 2119796.92436 | 37.80121941579 | -122.40351603796 | (37.80121941579, -122.40351603796) | 3 | 1 | 10 | 308 | 23 | |||
| 169676 | 226041 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 200 Eugenia Ave | 3 | Front Yard : Yard | Tree | Private 2 | 1 | 6006552.18069 | 2098105.68452 | 37.7413692017157 | -122.419934527956 | (37.7413692017157, -122.419934527956) | 2 | 7 | 7 | 28859 | 2 | ||||
| 80363 | 23919 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1700X Webster St | 1 | Median : Cutout | Tree | DPW 1 | 18 | 6x6 | 6003523.3584 | 2114587.3577 | 37.7864527963196 | -122.431583520291 | (37.7864527963196, -122.431583520291) | 13 | 9 | 11 | 29490 | 27 | |||
| 150412 | 3757 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1056 Carolina St | 2 | Median : Cutout | Tree | DPW 1 | 3 | 18 | 6012452.0863519 | 2103047.5184298 | 37.7552690413169 | -122.399881522302 | (37.7552690413169, -122.399881522302) | 10 | 3 | 8 | 28856 | 29 | |||
| 162522 | 3756 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1056 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 3 | 18 | 6012452.0863519 | 2103047.5184298 | 37.7552690413169 | -122.399881522302 | (37.7552690413169, -122.399881522302) | 10 | 3 | 8 | 28856 | 29 | |||
| 130429 | 190390 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1750 22nd St | 2 | Side Yard : Yard | Tree | Private 2 | 1 | 6012854.72935 | 2103804.17493 | 37.7573690942352 | -122.398542146717 | (37.7573690942352, -122.398542146717) | 10 | 3 | 8 | 28856 | 29 | ||||
| 23797 | 94990 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 48 Leland Ave | 1 | Sidewalk: Curb side : | Tree | Private 2 | 3 | 6010713.1186 | 2087200.5157 | 37.7116594240627 | -122.404779818423 | (37.7116594240627, -122.404779818423) | 9 | 7 | 8 | 309 | 39 | ||||
| 61024 | 94991 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 48 Leland Ave | 2 | Sidewalk: Curb side : | Tree | Private 2 | 3 | 6010722.4 | 2087213.8 | 37.7116964188451 | -122.404748673867 | (37.7116964188451, -122.404748673867) | 9 | 7 | 8 | 309 | 39 | ||||
| 38 | 167409 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 4 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781788 | 6001979.94285 | 2107686.90453 | 37.7674182815445 | -122.436429284105 | (37.7674182815445, -122.436429284105) | 15 | 5 | 5 | 29492 | 3 | |
| 56 | 124 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1032 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781788 | 6002037.12702 | 2107659.05322 | 37.7673450578674 | -122.436229498819 | (37.7673450578674, -122.436229498819) | 15 | 5 | 5 | 29492 | 3 | |
| 288 | 125298 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 822 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010056.95509 | 2118170.07703 | 37.7966582351325 | -122.409231726859 | (37.7966582351325, -122.409231726859) | 3 | 1 | 10 | 308 | 4 | |||
| 321 | 219060 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 221 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6000072.85251 | 2094491.10418 | 37.731077247812 | -122.442078323383 | (37.731077247812, -122.442078323383) | 9 | 7 | 4 | 63 | 40 | |||
| 692 | 61241 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3970 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/1984 12:00:00 AM | Permit Number 21113 | 6003879.55901956 | 2104241.51200503 | 37.7580658175007 | -122.429613020503 | (37.7580658175007, -122.429613020503) | 2 | 4 | 5 | 28862 | 3 | ||
| 757 | 226221 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 901 Alabama St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009154.30275 | 2103871.8716 | 37.7573481256189 | -122.411344516752 | (37.7573481256189, -122.411344516752) | 2 | 4 | 7 | 28859 | 19 | |||
| 796 | 36869 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 881 | 254388 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 990 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | 3x3 | 6009377.71563 | 2118076.93343 | 37.7963644085284 | -122.411575473026 | (37.7963644085284, -122.411575473026) | 3 | 1 | 10 | 308 | 4 | ||
| 1069 | 49087 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 692 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2003 12:00:00 AM | Permit Number 46237 | 6012085.19773634 | 2105185.1896517 | 37.7611181541392 | -122.401300553818 | (37.7611181541392, -122.401300553818) | 10 | 3 | 8 | 28856 | 29 | |||
| 1198 | 225665 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 300x Highland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006874 | 2096520 | 37.7370333899893 | -122.418709361786 | (37.7370333899893, -122.418709361786) | 2 | 7 | 7 | 28859 | 2 | |||
| 1246 | 160377 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 824 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 0ft | 6001767.32645 | 2089068.63157 | 37.7162847814869 | -122.435832414836 | (37.7162847814869, -122.435832414836) | 9 | 7 | 6 | 28861 | 5 | ||
| 1277 | 220672 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 25 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6005444.88154 | 2104573.79472 | 37.759066695887 | -122.424223091727 | (37.759066695887, -122.424223091727) | 2 | 4 | 5 | 28859 | 19 | |||
| 1506 | 70618 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1557 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6007346.38924 | 2116443.24691 | 37.7917645589423 | -122.418488407316 | (37.7917645589423, -122.418488407316) | 5 | 1 | 10 | 28858 | 21 | |||
| 1594 | 264718 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 6012426 | 2106899 | 37.7658429041656 | -122.400242229593 | (37.7658429041656, -122.400242229593) | 14 | 3 | 8 | 28856 | 20 | |||
| 1608 | 32205 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1697 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | 8 | Permit Number 35528 | 6009341.58261 | 2099615.8477 | 37.7456725350783 | -122.410396317437 | (37.7456725350783, -122.410396317437) | 2 | 7 | 7 | 28859 | 2 | |
| 1649 | 92526 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 275 10th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2009 12:00:00 AM | 3x3 | Permit Number 52874 | 6008743 | 2109634 | 37.7731465224788 | -122.413174412357 | (37.7731465224788, -122.413174412357) | 8 | 2 | 9 | 28853 | 34 | ||
| 1669 | 35520 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 90 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41442 | 6005793.71652674 | 2102887.49607432 | 37.7544562030797 | -122.422896805421 | (37.7544562030797, -122.422896805421) | 2 | 4 | 5 | 28859 | 19 | ||
| 1686 | 225676 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 700X Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008816.88964 | 2096900.69924 | 37.7381879057352 | -122.412018790637 | (37.7381879057352, -122.412018790637) | 10 | 7 | 7 | 28859 | 2 | |||
| 1811 | 258532 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1565 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2019 12:00:00 AM | 3 | 3x3 | Permit Number 777683 | 6006695.00356 | 2117330.6469 | 37.7941644464503 | -122.420805231935 | (37.7941644464503, -122.420805231935) | 13 | 9 | 10 | 28858 | 32 | |
| 1918 | 262485 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 500X Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6009406 | 2087980 | 37.7137265813857 | -122.409352565386 | (37.7137265813857, -122.409352565386) | 9 | 7 | 8 | 309 | 39 | |||
| 1952 | 129457 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 822 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010137.05679 | 2118184.23209 | 37.7967015887668 | -122.408955554965 | (37.7967015887668, -122.408955554965) | 3 | 1 | 10 | 308 | 4 | |||
| 2060 | 150281 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Wisconsin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012538.7082 | 2106843.10365 | 37.7656957093017 | -122.399848467747 | (37.7656957093017, -122.399848467747) | 14 | 3 | 8 | 28856 | 20 | |||
| 2109 | 71599 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 130 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5994726.40181 | 2086320.41636 | 37.7083363538073 | -122.459970121431 | (37.7083363538073, -122.459970121431) | 9 | 8 | 6 | 28861 | 25 | |||
| 2312 | 71328 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 228 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6004151.95998 | 2089814.42795 | 37.7184677472758 | -122.427643069565 | (37.7184677472758, -122.427643069565) | 9 | 7 | 6 | 28861 | 5 | |||
| 2367 | 226104 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 269 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005509.798 | 2107472.48259 | 37.7670294722636 | -122.424204733868 | (37.7670294722636, -122.424204733868) | 8 | 4 | 5 | 28853 | 19 | |||
| 2409 | 225663 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 79 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006114.92527 | 2097621.73369 | 37.7400157373359 | -122.421412046638 | (37.7400157373359, -122.421412046638) | 2 | 7 | 7 | 28859 | 2 | |||
| 2416 | 192496 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Kansas St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011473.84765 | 2106919.34293 | 37.765845622699 | -122.403536974176 | (37.765845622699, -122.403536974176) | 8 | 3 | 8 | 28853 | 20 | |||
| 2444 | 187616 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 Hawthorne St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/03/2013 12:00:00 AM | 3x3 | 6013035 | 2114021 | 37.78543223702 | -122.398635644163 | (37.78543223702, -122.398635644163) | 6 | 2 | 9 | 28855 | 6 | ||
| 2467 | 5648 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/1997 12:00:00 AM | 12 | 3x3 | 6005228.5165 | 2100736.64221 | 37.748518548493 | -122.424698417605 | (37.748518548493, -122.424698417605) | 2 | 4 | 5 | 28859 | 19 | ||
| 2577 | 31869 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 166 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 1 | Permit Number 35311 | 6000215.42905 | 2104900.21847 | 37.759666310759 | -122.442332399837 | (37.759666310759, -122.442332399837) | 2 | 4 | 5 | 28862 | 3 | |
| 2637 | 262319 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1616 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011556 | 2107033 | 37.7661622878471 | -122.403260820888 | (37.7661622878471, -122.403260820888) | 8 | 2 | 8 | 28853 | 20 | ||||
| 2645 | 137669 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1927 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6000327.0363 | 2111629.9151 | 37.7781507333481 | -122.442429558556 | (37.7781507333481, -122.442429558556) | 15 | 5 | 11 | 29490 | 16 | |||
| 2803 | 39877 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41173 | 6015620.67363669 | 2114221.43610992 | 37.786126305998 | -122.389703911477 | (37.786126305998, -122.389703911477) | 6 | 2 | 9 | 28855 | 6 | |||
| 2836 | 219119 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Brompton Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002030.49307 | 2095074.13161 | 37.7327894760326 | -122.435352122012 | (37.7327894760326, -122.435352122012) | 9 | 7 | 5 | 63 | 40 | |||
| 2843 | 243848 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2976 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2017 12:00:00 AM | 3 | Width 3ft | 6009037.26284 | 2102182.62574 | 37.7527032720445 | -122.411629937289 | (37.7527032720445, -122.411629937289) | 2 | 4 | 7 | 28859 | 19 | ||
| 3016 | 190529 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 21 Clarence Pl | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6014722.79424 | 2111890.37318 | 37.7796759079438 | -122.392647234607 | (37.7796759079438, -122.392647234607) | 6 | 2 | 9 | 28856 | 6 | |||
| 3134 | 190600 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015217.08572 | 2107526.40267 | 37.7677208521577 | -122.390632216307 | (37.7677208521577, -122.390632216307) | 14 | 3 | 9 | 310 | 20 | |||
| 3143 | 46360 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 514 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2002 12:00:00 AM | 2 | Permit Number 44598 | 5988790.17087 | 2111781.31969 | 37.7779021128043 | -122.482350384801 | (37.7779021128043, -122.482350384801) | 11 | 6 | 2 | 55 | 26 | |
| 3155 | 171861 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 600 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009150.18336 | 2091330.30171 | 37.722911477365 | -122.410473193303 | (37.722911477365, -122.410473193303) | 9 | 3 | 7 | 309 | 28 | |||
| 3333 | 66070 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 517 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1990 12:00:00 AM | 7 | Permit Number 29111 | 6014120.17951 | 2104674.3104 | 37.7598287157536 | -122.39422660508 | (37.7598287157536, -122.39422660508) | 10 | 3 | 8 | 28856 | 29 | |
| 3402 | 81722 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 998 Indiana St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6014944.17963 | 2104119.9743 | 37.758352394954 | -122.391338017739 | (37.758352394954, -122.391338017739) | 10 | 3 | 8 | 28856 | 29 | |||
| 3435 | 226185 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 160 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008635.20088 | 2097780.05534 | 37.7405922297483 | -122.412709130925 | (37.7405922297483, -122.412709130925) | 10 | 7 | 7 | 28859 | 2 | |||
| 3516 | 92206 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 443 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775730 | 6002885.09645 | 2091274.76844 | 37.7224057768794 | -122.432126318576 | (37.7224057768794, -122.432126318576) | 9 | 7 | 6 | 28861 | 5 | |
| 3595 | 219121 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Brompton Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002025.50342 | 2095049.38545 | 37.7327212453836 | -122.435367602937 | (37.7327212453836, -122.435367602937) | 9 | 7 | 5 | 63 | 40 | |||
| 3597 | 93954 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1 Hawthorne St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53397 | 6012934.64989 | 2114104.90951 | 37.7856570416874 | -122.398988719454 | (37.7856570416874, -122.398988719454) | 6 | 2 | 9 | 28855 | 6 | |
| 3744 | 39401 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
| 3762 | 159863 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 31 Ruth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781524 | 6001585.86798 | 2091604.37779 | 37.7232370625303 | -122.436641024974 | (37.7232370625303, -122.436641024974) | 9 | 7 | 6 | 28861 | 25 | |
| 3819 | 6627 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1415 Evans Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/24/1998 12:00:00 AM | 6 | 3x3 | 6016607.54293 | 2097762.50213 | 37.7409882686849 | -122.385142357926 | (37.7409882686849, -122.385142357926) | 10 | 3 | 8 | 58 | 1 | ||
| 3874 | 171862 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 600 Dartmouth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009157.70808 | 2091305.98211 | 37.722845122689 | -122.410445465398 | (37.722845122689, -122.410445465398) | 9 | 3 | 7 | 309 | 28 | |||
| 3930 | 225746 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 492 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003162.34102 | 2103320.8798 | 37.7554973442542 | -122.432027724994 | (37.7554973442542, -122.432027724994) | 2 | 4 | 5 | 28862 | 22 | |||
| 4067 | 37077 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1278 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 6 | Permit Number 39679 | 5982458.52457533 | 2106416.34966851 | 37.7628011138985 | -122.503855957317 | (37.7628011138985, -122.503855957317) | 1 | 8 | 3 | 56 | 35 | |
| 4074 | 264716 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 6012426 | 2106899 | 37.7658429041656 | -122.400242229593 | (37.7658429041656, -122.400242229593) | 14 | 3 | 8 | 28856 | 20 | |||
| 4169 | 56472 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1 Massasoit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/03/2014 12:00:00 AM | 3 | Permit Number 773427 | 6010126.92776078 | 2099291.06805198 | 37.7448247552135 | -122.40765780266 | (37.7448247552135, -122.40765780266) | 2 | 7 | 7 | 28859 | 2 | ||
| 4230 | 25991 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1821 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | 3 | 3X3 | 6013865.62853 | 2096292.13024 | 37.7367988747247 | -122.394520028611 | (37.7367988747247, -122.394520028611) | 10 | 3 | 8 | 58 | 1 | ||
| 4259 | 33111 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 2626 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2020 12:00:00 AM | 3 | 4x4 | Permit Number 769981 | 6000363.34088 | 2118561.77591 | 37.7971858916671 | -122.442801853125 | (37.7971858916671, -122.442801853125) | 13 | 9 | 1 | 57 | 17 | |
| 4261 | 224651 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 157 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2020 12:00:00 AM | 3 | 5x9 | Permit Number 781922 | 6006794.80583 | 2098578.82638 | 37.7426820095795 | -122.419129166176 | (37.7426820095795, -122.419129166176) | 2 | 7 | 7 | 28859 | 2 | |
| 4360 | 71812 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 340 Spruce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5997177.69428 | 2115152.46792 | 37.787642723191 | -122.453578628865 | (37.787642723191, -122.453578628865) | 11 | 6 | 1 | 54 | 31 | |||
| 4392 | 264717 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 6012426 | 2106899 | 37.7658429041656 | -122.400242229593 | (37.7658429041656, -122.400242229593) | 14 | 3 | 8 | 28856 | 20 | |||
| 4469 | 224678 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 904 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:09:00 PM | 3 | Width 3ft | 6007360.84858 | 2102028.60298 | 37.7521861798641 | -122.417416376772 | (37.7521861798641, -122.417416376772) | 2 | 4 | 7 | 28859 | 19 | ||
| 4481 | 83152 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1499 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 3x3 | 6016214.02655 | 2098054.96896 | 37.741769546638 | -122.386523393735 | (37.741769546638, -122.386523393735) | 10 | 3 | 8 | 58 | 1 | ||
| 4508 | 260546 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 3400 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006333.00148 | 2102621.91378 | 37.753757389911 | -122.421012959005 | (37.753757389911, -122.421012959005) | 2 | 4 | 5 | 28859 | 19 | |
| 4635 | 51506 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3641 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2005 12:00:00 AM | 4 | Permit Number 47816 | 5997376.74864 | 2115377.3985 | 37.7882717315077 | -122.452906185094 | (37.7882717315077, -122.452906185094) | 11 | 6 | 1 | 54 | 31 | ||
| 4701 | 78630 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 675-677 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6011847.3509 | 2105245.39121 | 37.7612701814803 | -122.40212740108 | (37.7612701814803, -122.40212740108) | 10 | 3 | 8 | 28856 | 29 | |||
| 4819 | 226206 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 597 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6007961.05461 | 2097012.3504 | 37.7384464203683 | -122.414985752093 | (37.7384464203683, -122.414985752093) | 2 | 7 | 7 | 28859 | 2 | |||
| 5007 | 30714 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 111 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 2 | Permit Number 34618 | 6005877.6805 | 2109983.4249 | 37.7739446835862 | -122.423110779148 | (37.7739446835862, -122.423110779148) | 7 | 9 | 11 | 28852 | 10 | |
| 5009 | 47117 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 111X Kingston St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | 3 | 3x3 | Permit Number 45100 | 6005877.48531462 | 2098254.931079 | 37.7417409646574 | -122.422277993643 | (37.7417409646574, -122.422277993643) | 2 | 7 | 7 | 28859 | 2 |
| 5079 | 244070 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 405 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5997422 | 2109143 | 37.7711562992209 | -122.452299584321 | (37.7711562992209, -122.452299584321) | 15 | 5 | 11 | 29492 | 9 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );