trees
3,247 rows where qSpecies_id = 22
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12188 | 102373 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 870 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 5983890.73069 | 2109977.48147 | 37.7726630776505 | -122.499165683617 | (37.7726630776505, -122.499165683617) | 11 | 6 | 2 | 55 | 26 | ||||
| 12208 | 190492 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 541 Delancey St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6015312.24709 | 2113599.76666 | 37.7844022356283 | -122.390727534552 | (37.7844022356283, -122.390727534552) | 6 | 2 | 9 | 28856 | 6 | |||
| 12292 | 74182 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 138 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5994679.00139 | 2086362.08429 | 37.7084480379267 | -122.46013695827 | (37.7084480379267, -122.46013695827) | 9 | 8 | 6 | 28861 | 25 | |||
| 12414 | 225687 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 26 Samoset St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009954.93782 | 2099199.55423 | 37.7445638490343 | -122.408246060928 | (37.7445638490343, -122.408246060928) | 2 | 7 | 7 | 28859 | 2 | |||
| 12449 | 80636 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 261-263 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6013774.02904 | 2105871.68608 | 37.7630972009925 | -122.395507666864 | (37.7630972009925, -122.395507666864) | 14 | 3 | 8 | 28856 | 29 | |||
| 12479 | 66411 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 217 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2009 12:00:00 AM | 3x3 | Permit Number 52018 | 6006829.83812508 | 2097883.34846014 | 37.7407743554357 | -122.418958717737 | (37.7407743554357, -122.418958717737) | 2 | 7 | 7 | 28859 | 2 | ||
| 12559 | 30713 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 111 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 3 | Permit Number 34618 | 6005868.3438 | 2109981.6465 | 37.7739392736408 | -122.42314294996 | (37.7739392736408, -122.42314294996) | 7 | 9 | 11 | 28852 | 10 | |
| 12704 | 72671 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 203 04th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5994585.61762 | 2114114.79768 | 37.7846446297113 | -122.462471346717 | (37.7846446297113, -122.462471346717) | 11 | 6 | 2 | 54 | 11 | |||
| 12711 | 190451 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1498 Evans Ave | 8 | : | Tree | Private 2 | 3 | Width 3ft | 6016356.86171 | 2098066.94132 | 37.7418103263734 | -122.386030346736 | (37.7418103263734, -122.386030346736) | 10 | 3 | 8 | 58 | 1 | |||
| 12736 | 219124 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 70 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6001597.50006 | 2094955.90851 | 37.7324402629898 | -122.436840624998 | (37.7324402629898, -122.436840624998) | 9 | 7 | 5 | 63 | 40 | |||
| 12788 | 84750 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 170 King St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | Permit No. 49304 | 6014851 | 2111791 | 37.7794101710037 | -122.392196759897 | (37.7794101710037, -122.392196759897) | 6 | 2 | 9 | 28856 | 6 | |||
| 12820 | 226199 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 701X Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008874.37746 | 2096929.55374 | 37.7382703591781 | -122.411822063942 | (37.7382703591781, -122.411822063942) | 10 | 7 | 7 | 28859 | 2 | |||
| 12826 | 19801 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 STAIRWAY21 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
| 12858 | 128984 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6006377.26428 | 2110951.50272 | 37.7766309716791 | -122.421451397362 | (37.7766309716791, -122.421451397362) | 7 | 9 | 11 | 28852 | 10 | |||
| 12872 | 225999 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 700 Duboce Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002335.19401 | 2108315.06979 | 37.7691632487104 | -122.435245457027 | (37.7691632487104, -122.435245457027) | 15 | 5 | 5 | 29492 | 9 | |||
| 12946 | 192425 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 187 Clara St | 6 | : | Tree | Private 2 | 1 | Width 2ft | 6011952.39777 | 2111919.37561 | 37.7796012912124 | -122.402233334018 | (37.7796012912124, -122.402233334018) | 6 | 2 | 9 | 28856 | 34 | |||
| 12981 | 150277 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | Width 4ft | 6012531.20718 | 2106963.7474 | 37.7660265519105 | -122.399882884798 | (37.7660265519105, -122.399882884798) | 14 | 3 | 8 | 28856 | 20 | ||
| 12989 | 139211 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2031 Post St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002368.8281 | 2113997.6031 | 37.7847679739293 | -122.435535694505 | (37.7847679739293, -122.435535694505) | 13 | 6 | 11 | 29490 | 13 | |||
| 13047 | 70677 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 110 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6010274.94764 | 2110617.18135 | 37.7759319943133 | -122.407944528121 | (37.7759319943133, -122.407944528121) | 8 | 2 | 9 | 28853 | 34 | |||
| 13115 | 51970 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1563 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2005 12:00:00 AM | Permit Number 48189 | 5999092.74097418 | 2109030.13425564 | 37.7709419701081 | -122.446512330156 | (37.7709419701081, -122.446512330156) | 15 | 5 | 11 | 29492 | 9 | |||
| 13165 | 152981 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 3400 23rd St | 1 | 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 | |
| 13172 | 264709 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1315 Carolina St | 1 | 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 | |||
| 13275 | 225677 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 600X Jarboe Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008676.00847 | 2096910.24517 | 37.7382062114413 | -122.412506564025 | (37.7382062114413, -122.412506564025) | 10 | 7 | 7 | 28859 | 2 | |||
| 13295 | 72207 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 528 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6010331.0847 | 2120296.9733 | 37.8025135249949 | -122.40843327331 | (37.8025135249949, -122.40843327331) | 3 | 1 | 10 | 308 | 23 | |||
| 13302 | 231498 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2516 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2020 02:05:00 PM | 3 | Width 3ft | 6011317.42279 | 2101858.91316 | 37.7519420696849 | -122.403721918837 | (37.7519420696849, -122.403721918837) | 10 | 4 | 8 | 28859 | 19 | ||
| 13365 | 225615 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 53 Wilder St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002593.03805 | 2095538.61045 | 37.73409676026 | -122.43344044482 | (37.73409676026, -122.43344044482) | 2 | 7 | 5 | 63 | 7 | |||
| 13446 | 226197 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 801x Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009034.07414 | 2096916.87656 | 37.7382445081807 | -122.411269014179 | (37.7382445081807, -122.411269014179) | 10 | 7 | 7 | 28859 | 2 | |||
| 13460 | 190428 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 26 | : | Tree | Private 2 | 1 | Width 3ft | 6017641.63274 | 2097108.43991 | 37.7392494942632 | -122.381521343831 | (37.7392494942632, -122.381521343831) | 10 | 3 | 8 | 58 | 1 | |||
| 13502 | 225668 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 200X Ogden Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007886.44005 | 2096099.07772 | 37.7359345806165 | -122.415179104548 | (37.7359345806165, -122.415179104548) | 2 | 7 | 7 | 28859 | 2 | |||
| 13555 | 226201 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 701X Jarboe Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008833.56872 | 2096933.18629 | 37.7382780438907 | -122.411963417589 | (37.7382780438907, -122.411963417589) | 10 | 7 | 7 | 28859 | 2 | |||
| 13578 | 253069 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 420 Innes Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.00752 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | 10 | 3 | 8 | 58 | 1 | ||
| 13610 | 247805 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 488 30th St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6003450.91279 | 2098365.25645 | 37.7419067175277 | -122.430676143802 | (37.7419067175277, -122.430676143802) | 2 | 7 | 5 | 63 | 22 | |||
| 13942 | 192464 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 797 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015635.55835 | 2103917.93744 | 37.7578359916633 | -122.388932798913 | (37.7578359916633, -122.388932798913) | 10 | 3 | 8 | 28856 | 29 | |||
| 13947 | 109612 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
| 13965 | 225680 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 901X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007829.14315 | 2097739.40397 | 37.7404353358322 | -122.415493298878 | (37.7404353358322, -122.415493298878) | 2 | 7 | 7 | 28859 | 2 | |||
| 14001 | 49817 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1226 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46608 | 6012208.77564 | 2102677.65266 | 37.7542399031726 | -122.400696986204 | (37.7542399031726, -122.400696986204) | 10 | 3 | 8 | 28856 | 29 |
| 14020 | 225632 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100X Powhattan Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007685.38755 | 2098160.84073 | 37.7415844265716 | -122.416020188286 | (37.7415844265716, -122.416020188286) | 2 | 7 | 7 | 28859 | 2 | |||
| 14023 | 226231 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2831 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009237.08939 | 2103907.61142 | 37.7574509019423 | -122.411060731168 | (37.7574509019423, -122.411060731168) | 2 | 4 | 7 | 28859 | 19 | |||
| 14048 | 19740 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 STAIRWAY15 | -50 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 1OST | |||||||||||||
| 14185 | 75407 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 194X Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 5x5 | 6010525.12192 | 2111307.03338 | 37.7778401704149 | -122.407127744063 | (37.7778401704149, -122.407127744063) | 14 | 2 | 9 | 28853 | 34 | |||
| 14371 | 1412 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 87 Ardath Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017443.0312922 | 2095232.0493547 | 37.7340863325513 | -122.382077533105 | (37.7340863325513, -122.382077533105) | 10 | 3 | 8 | 58 | 1 | ||
| 14392 | 128960 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 270 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6007843 | 2112396 | 37.7806797483911 | -122.416483319824 | (37.7806797483911, -122.416483319824) | 7 | 10 | 9 | 28852 | 36 | |||
| 14461 | 62082 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 526 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1985 12:00:00 AM | 5 | Permit Number 22166 | 6013236.0728 | 2104376.01067 | 37.7589604679833 | -122.397263399784 | (37.7589604679833, -122.397263399784) | 10 | 3 | 8 | 28856 | 29 | |
| 14479 | 260995 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1639 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999105 | 2109358 | 37.771842906315 | -122.446493517614 | (37.771842906315, -122.446493517614) | 15 | 5 | 11 | 29492 | 9 | ||||
| 14531 | 84257 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 894 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5988243.88098 | 2109914.2292 | 37.7727438112406 | -122.484103215339 | (37.7727438112406, -122.484103215339) | 11 | 6 | 2 | 55 | 26 | |||
| 14644 | 128956 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 190 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008324.7013 | 2112452.543 | 37.7808620795531 | -122.414820881171 | (37.7808620795531, -122.414820881171) | 7 | 10 | 9 | 28852 | 36 | |||
| 14739 | 226064 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3400 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005624.89593 | 2103166.13242 | 37.7552117465446 | -122.423500439705 | (37.7552117465446, -122.423500439705) | 2 | 4 | 5 | 28859 | 19 | |||
| 14792 | 226083 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1681 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009334.76318 | 2099698.46458 | 37.7458990005447 | -122.410425730686 | (37.7458990005447, -122.410425730686) | 2 | 7 | 7 | 28859 | 2 | |||
| 14813 | 190494 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 541 Delancey St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6015224.29962 | 2113700.39003 | 37.7846736447102 | -122.391038840285 | (37.7846736447102, -122.391038840285) | 6 | 2 | 9 | 28856 | 6 | |||
| 14814 | 50011 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 99@ 20TH ST Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2003 12:00:00 AM | Permit Number 46742 | |||||||||||||
| 14821 | 226044 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3548 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005910.57761 | 2105523.0579 | 37.7616994342103 | -122.422679949545 | (37.7616994342103, -122.422679949545) | 8 | 4 | 5 | 28859 | 19 | |||
| 14850 | 98281 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 66 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2012 12:00:00 AM | 3 | Permit Number 58649 | 6008165.69574 | 2110879.12634 | 37.7765329177037 | -122.415259547114 | (37.7765329177037, -122.415259547114) | 8 | 2 | 9 | 28853 | 34 | ||
| 14854 | 74616 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2350 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5991316.62714 | 2112033.26872 | 37.7787405344574 | -122.473628955238 | (37.7787405344574, -122.473628955238) | 11 | 6 | 2 | 54 | 26 | |||
| 15326 | 30913 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 183 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34734 | 5995612.81318116 | 2091099.78305051 | 37.7215103139917 | -122.457252110286 | (37.7215103139917, -122.457252110286) | 9 | 8 | 6 | 28861 | 24 | ||
| 15361 | 36968 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 118 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/1998 12:00:00 AM | 5 | Permit Number 39595 | 5993987.97624 | 2114726.89582 | 37.786290850626 | -122.464583430573 | (37.786290850626, -122.464583430573) | 11 | 6 | 1 | 54 | 11 | ||
| 15486 | 81720 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 998 Indiana St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014948.39032 | 2104075.36829 | 37.7582301501175 | -122.39132033706 | (37.7582301501175, -122.39132033706) | 10 | 3 | 8 | 28856 | 29 | |||
| 15540 | 124027 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 201 Funston Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5991798.47727 | 2113998.77869 | 37.7841651786362 | -122.47210536759 | (37.7841651786362, -122.47210536759) | 11 | 6 | 2 | 54 | 11 | |||
| 15552 | 149669 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1701 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6011308.34689 | 2106942.89259 | 37.765901038939 | -122.404111067171 | (37.765901038939, -122.404111067171) | 8 | 3 | 8 | 28853 | 20 | |||
| 15610 | 78628 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 695 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6011848.41815 | 2105223.54822 | 37.7612102650599 | -122.402122174202 | (37.7612102650599, -122.402122174202) | 10 | 3 | 8 | 28856 | 29 | |||
| 15669 | 226292 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 537 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1991 12:00:00 AM | 3 | Width 2ft | Permit Number 29820 | 6003335.67331 | 2095877.19361 | 37.7350685379825 | -122.430897079359 | (37.7350685379825, -122.430897079359) | 2 | 7 | 5 | 63 | 7 | |
| 15719 | 7346 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2225 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/1980 12:00:00 AM | 1 | 3X3 | 6002798.59801 | 2115979.15257 | 37.7902332041481 | -122.43419054146 | (37.7902332041481, -122.43419054146) | 13 | 9 | 1 | 29490 | 27 | ||
| 15826 | 83441 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 325 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 6014074.06894 | 2105534.94834 | 37.7621892769404 | -122.394446342739 | (37.7621892769404, -122.394446342739) | 10 | 3 | 8 | 28856 | 29 | ||
| 15859 | 228223 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 176 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000130.83227 | 2104896.01094 | 37.7596499359143 | -122.442624675007 | (37.7596499359143, -122.442624675007) | 2 | 4 | 5 | 28862 | 3 | |||
| 15866 | 87230 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2575X JUDAH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2015 12:00:00 AM | 3x3 | Permit Number 776165 | 5986584.2 | 2105636.2 | 37.7609007669433 | -122.489529520217 | (37.7609007669433, -122.489529520217) | 1 | 8 | 3 | 56 | 35 | ||
| 15898 | 36871 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 15910 | 226183 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 330 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008608.53672 | 2097126.22235 | 37.7387954508426 | -122.412755113274 | (37.7387954508426, -122.412755113274) | 10 | 7 | 7 | 28859 | 2 | |||
| 15922 | 62857 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 179 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/18/1986 12:00:00 AM | Permit Number 23225 | 6008674.53760188 | 2097751.18669018 | 37.7405151705193 | -122.412571078994 | (37.7405151705193, -122.412571078994) | 10 | 7 | 7 | 28859 | 2 | ||
| 15997 | 225696 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3342 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 6x9 | 6006072.97895 | 2103191.31452 | 37.7553061717546 | -122.421952622821 | (37.7553061717546, -122.421952622821) | 2 | 4 | 5 | 28859 | 19 | |||
| 16071 | 202049 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 Exeter St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6012555.81447 | 2090941.8893 | 37.7220353110641 | -122.398673311925 | (37.7220353110641, -122.398673311925) | 10 | 3 | 8 | 58 | 1 | |||
| 16074 | 128922 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2101 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004454.93777 | 2116689.88617 | 37.7922785673477 | -122.428510409935 | (37.7922785673477, -122.428510409935) | 13 | 9 | 1 | 28858 | 27 | |||
| 16077 | 201863 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1220 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6009514.9493 | 2110197.5964 | 37.7747373334401 | -122.410543934579 | (37.7747373334401, -122.410543934579) | 8 | 2 | 9 | 28853 | 34 | |||
| 16108 | 264710 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1315 Carolina St | 2 | 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 | |||
| 16234 | 226133 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 454 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002986.00239 | 2098632.64023 | 37.74261454154 | -122.432302743977 | (37.74261454154, -122.432302743977) | 2 | 7 | 5 | 63 | 22 | |||
| 16240 | 219098 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 446 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992878.03249 | 2103928.21125 | 37.7565765019208 | -122.467637894993 | (37.7565765019208, -122.467637894993) | 1 | 8 | 4 | 56 | 12 | |||
| 16265 | 83806 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1401 Jones St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 4x4 | 6008439.24535 | 2117330.37578 | 37.794261859346 | -122.414769927392 | (37.794261859346, -122.414769927392) | 5 | 1 | 10 | 28858 | 21 | ||
| 16311 | 71600 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 136 Wilson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994689.24707 | 2086354.84413 | 37.7084287474492 | -122.460101024051 | (37.7084287474492, -122.460101024051) | 9 | 8 | 6 | 28861 | 25 | |||
| 16322 | 41156 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 455 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2004 12:00:00 AM | Permit Number 47674 | 6009883.81375688 | 2109165.06157558 | 37.7719229056173 | -122.409195075279 | (37.7719229056173, -122.409195075279) | 14 | 2 | 9 | 28853 | 34 | |||
| 16333 | 128995 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1414 Jones St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 3ft | 6008424.44271 | 2117443.95005 | 37.7945728745903 | -122.41482918821 | (37.7945728745903, -122.41482918821) | 5 | 1 | 10 | 28858 | 21 | |||
| 16336 | 36872 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 16371 | 260999 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 77 Belgrave Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/12/2019 12:00:00 AM | 3 | 6x6 | Permit Number 781419 | 5998149.61527 | 2104897.27011 | 37.7595402565853 | -122.449476776674 | (37.7595402565853, -122.449476776674) | 15 | 5 | 11 | 28862 | 12 | |
| 16377 | 94114 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 200X Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006339.5 | 2111012.4 | 37.7767960515681 | -122.421586361388 | (37.7767960515681, -122.421586361388) | 7 | 9 | 11 | 28852 | 10 | |
| 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 | |||
| 16453 | 260924 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 47 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2019 12:00:00 AM | 3 | 5990807.95481 | 2114868.4417 | 37.7864956605801 | -122.475595709543 | (37.7864956605801, -122.475595709543) | 11 | 6 | 1 | 54 | 33 | |||
| 16572 | 19741 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 STAIRWAY15 | -14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 1OST | |||||||||||||
| 16626 | 140766 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1998 ELLIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6001378.7458 | 2112872.6658 | 37.7816229009646 | -122.438880402789 | (37.7816229009646, -122.438880402789) | 15 | 5 | 11 | 29490 | 41 | |||
| 16653 | 156578 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 327 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782340 | 6006945.39069 | 2096312.28481 | 37.7364670691931 | -122.41844780742 | (37.7364670691931, -122.41844780742) | 2 | 7 | 7 | 28859 | 2 | |
| 16691 | 94109 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 311X Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006347.81272 | 2111083.22258 | 37.7769909819764 | -122.421562636328 | (37.7769909819764, -122.421562636328) | 7 | 9 | 11 | 28852 | 10 | |
| 16697 | 5176 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 364 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1993 12:00:00 AM | 3 | 3x3 | 6001777.7698 | 2109730.6414 | 37.7730183862506 | -122.437274925638 | (37.7730183862506, -122.437274925638) | 15 | 5 | 11 | 29492 | 9 | ||
| 16796 | 70557 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 20 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6004148.34946 | 2093373.6236 | 37.7282403094269 | -122.42790902788 | (37.7282403094269, -122.42790902788) | 9 | 7 | 6 | 28861 | 5 | |||
| 16825 | 117127 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 699X 07TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x9 | 5993787 | 2111075 | 37.7762521443456 | -122.465013423988 | (37.7762521443456, -122.465013423988) | 11 | 6 | 2 | 54 | 11 | |||
| 16899 | 225631 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100X Powhattan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007671.81203 | 2098162.40951 | 37.741587970818 | -122.416067239037 | (37.741587970818, -122.416067239037) | 2 | 7 | 7 | 28859 | 2 | |||
| 16941 | 85025 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 344 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2007 12:00:00 AM | 3x3 | Permit Number 49376 | 6007036 | 2096264 | 37.7363395901899 | -122.418131109854 | (37.7363395901899, -122.418131109854) | 2 | 7 | 7 | 28859 | 2 | ||
| 16968 | 190389 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 707 Wisconsin St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6012743.00891 | 2104201.32754 | 37.7584533636396 | -122.398956396938 | (37.7584533636396, -122.398956396938) | 10 | 3 | 8 | 28856 | 29 | |||
| 17051 | 219086 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1330 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994278.3823 | 2106435.21824 | 37.7635408482476 | -122.462976903978 | (37.7635408482476, -122.462976903978) | 1 | 5 | 11 | 56 | 12 | |||
| 17073 | 177097 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 86 San Gabriel Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2020 12:08:00 PM | 3 | 3x3 | Permit Number 780184 | 6000986.95239 | 2093579.83618 | 37.7286271663089 | -122.438852851774 | (37.7286271663089, -122.438852851774) | 9 | 7 | 6 | 28861 | 25 | |
| 17138 | 84246 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 583 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51830 | 5988110.57341 | 2112018.88919 | 37.7785148566216 | -122.484718753523 | (37.7785148566216, -122.484718753523) | 11 | 6 | 2 | 55 | 26 | |
| 17186 | 110519 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
| 17226 | 225679 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 590X Jarboe Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008562.94043 | 2096925.54945 | 37.7382418875511 | -122.412898580305 | (37.7382418875511, -122.412898580305) | 10 | 7 | 7 | 28859 | 2 | |||
| 17276 | 72565 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 270 Brannan St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 4x4 | Permit Number 770847 | 6015158 | 2112983 | 37.7827001752808 | -122.391218053322 | (37.7827001752808, -122.391218053322) | 6 | 2 | 9 | 28856 | 6 | ||
| 17303 | 201604 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 570 Innes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6021044.33252 | 2093135.00772 | 37.7285264880895 | -122.369481698744 | (37.7285264880895, -122.369481698744) | 10 | 3 | 8 | 58 | 1 |
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) );