trees
3,888 rows where qSpecies_id = 58 sorted by Police Districts descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
219 | 131064 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1877 Greenwich St | 1 | : | Tree | Private 2 | 3 | Width 4ft | 6003926.06281 | 2119346.70194 | 37.7995435588443 | -122.430529985984 | (37.7995435588443, -122.430529985984) | 13 | 9 | 1 | 57 | 17 | |||
526 | 262229 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1970 Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6002649 | 2114114 | 37.7851034789316 | -122.434574718683 | (37.7851034789316, -122.434574718683) | 13 | 9 | 11 | 29490 | 13 | ||||
1592 | 262226 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1970 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6002649 | 2114114 | 37.7851034789316 | -122.434574718683 | (37.7851034789316, -122.434574718683) | 13 | 9 | 11 | 29490 | 13 | ||||
1913 | 140032 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 855 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005092.0233 | 2111947.5572 | 37.7792933441417 | -122.4259683453 | (37.7792933441417, -122.4259683453) | 7 | 9 | 11 | 28852 | 41 | |||
2222 | 20236 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 1750X Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/1992 12:00:00 AM | 6 | 4X4 | 6002603.6550052 | 2114233.7432168 | 37.7854296891778 | -122.434740163706 | (37.7854296891778, -122.434740163706) | 13 | 9 | 11 | 29490 | 13 | ||
2440 | 79187 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 45 Avila St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2019 12:00:00 AM | 3 | 3x3 | Permit Number 50829 | 6001057.44461 | 2119906.39281 | 37.8009174000823 | -122.440496575066 | (37.8009174000823, -122.440496575066) | 13 | 9 | 1 | 57 | 17 | |
2734 | 9598 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1350 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003113.218 | 2112071.7207 | 37.7795222347306 | -122.43282272297 | (37.7795222347306, -122.43282272297) | 15 | 9 | 11 | 29490 | 41 | |||
4315 | 14730 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 880 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x4 | 6005306.03378 | 2112177.46067 | 37.7799366952092 | -122.425244357372 | (37.7799366952092, -122.425244357372) | 7 | 9 | 11 | 28852 | 41 | |||
4656 | 61810 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 473 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/25/1985 12:00:00 AM | Permit Number 21840 | 6003450.97814623 | 2108943.61336851 | 37.7709523752315 | -122.431430899679 | (37.7709523752315, -122.431430899679) | 15 | 9 | 11 | 29492 | 10 | ||
5322 | 137960 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1500 POST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005080.1263 | 2114432.0028 | 37.7861143449411 | -122.426186425546 | (37.7861143449411, -122.426186425546) | 13 | 9 | 11 | 28858 | 13 | |||
5757 | 66794 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1234 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/1991 12:00:00 AM | 12 | 3x3 | Permit Number 53181 | 6006437.45424 | 2120099.39659 | 37.801752214642 | -122.421893151548 | (37.801752214642, -122.421893151548) | 5 | 9 | 1 | 28858 | 32 | |
6995 | 9735 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 727X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x4 | 6005653.63672 | 2112026.60995 | 37.7795421273786 | -122.424031111893 | (37.7795421273786, -122.424031111893) | 7 | 9 | 11 | 28852 | 41 | |||
7128 | 69366 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 3550 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 8 | 4.5x7.5 | Permit Number 33460 | 6002655.04764 | 2120834.44322 | 37.8035564228445 | -122.435034610952 | (37.8035564228445, -122.435034610952) | 13 | 9 | 1 | 57 | 17 |
7255 | 14729 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 880 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 4x4 | 6005306.03378 | 2112177.46067 | 37.7799366952092 | -122.425244357372 | (37.7799366952092, -122.425244357372) | 7 | 9 | 11 | 28852 | 41 | |||
7499 | 262228 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1970 Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6002649 | 2114114 | 37.7851034789316 | -122.434574718683 | (37.7851034789316, -122.434574718683) | 13 | 9 | 11 | 29490 | 13 | ||||
7541 | 54875 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 300 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/2004 12:00:00 AM | Permit Number 25697 | 6005109.34291576 | 2109921.18465674 | 37.7737303986235 | -122.425764158103 | (37.7737303986235, -122.425764158103) | 7 | 9 | 11 | 28852 | 10 | ||
7892 | 9616 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 1050X Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6002926.42189 | 2111948.31281 | 37.7791727913684 | -122.433460108411 | (37.7791727913684, -122.433460108411) | 15 | 9 | 11 | 29490 | 41 | |||
8346 | 73444 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1353 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6006988.50126 | 2115333.88055 | 37.7886983590984 | -122.419647955393 | (37.7886983590984, -122.419647955393) | 13 | 9 | 10 | 28858 | 21 | |||
8820 | 9599 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1355 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/06/1990 12:00:00 AM | 11 | 3X3 | 6003022.227 | 2112007.7178 | 37.7793413376686 | -122.433132925132 | (37.7793413376686, -122.433132925132) | 15 | 9 | 11 | 29490 | 41 | ||
8955 | 72192 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 81 Rico Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6001247.5968 | 2121479.41106 | 37.80524731558 | -122.439951421335 | (37.80524731558, -122.439951421335) | 13 | 9 | 1 | 57 | 17 | |||
9607 | 53745 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2827 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/1972 12:00:00 AM | 5 | Permit Number 9425 | 6000032.47068 | 2118311.89659 | 37.796480921203 | -122.443928780102 | (37.796480921203, -122.443928780102) | 13 | 9 | 1 | 57 | 17 | ||
10053 | 23735 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 805 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2016 12:00:00 AM | 12 | 4X4 | 6003900.7925 | 2111534.0109 | 37.7780904537405 | -122.430059798517 | (37.7780904537405, -122.430059798517) | 15 | 9 | 11 | 29492 | 41 | ||
10558 | 92080 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2950 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52193 | 6003888.61024 | 2118955.00061 | 37.7984659264214 | -122.430631619281 | (37.7984659264214, -122.430631619281) | 13 | 9 | 1 | 57 | 17 | |
10650 | 94686 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2537 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/2010 12:00:00 AM | 2 | 6000765.04798 | 2118917.47971 | 37.7981854530652 | -122.441437387327 | (37.7981854530652, -122.441437387327) | 13 | 9 | 1 | 57 | 17 | |||
10968 | 26676 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2261 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002690.1285 | 2114739.216 | 37.786822497954 | -122.434477145422 | (37.786822497954, -122.434477145422) | 13 | 9 | 11 | 29490 | 27 | |||
10985 | 244418 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 415 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6003654.6404 | 2109820.0319 | 37.7733703463876 | -122.430788980605 | (37.7733703463876, -122.430788980605) | 15 | 9 | 11 | 29492 | 10 | |||
12202 | 131083 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 3001 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6000959.53151 | 2118732.77484 | 37.7976893798144 | -122.44075116234 | (37.7976893798144, -122.44075116234) | 13 | 9 | 1 | 57 | 17 | |||
12603 | 18228 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1737-1795 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2004 12:00:00 AM | 12 | 3X3 | 6003682.1522 | 2114179.2812 | 37.7853413201744 | -122.431004998109 | (37.7853413201744, -122.431004998109) | 13 | 9 | 11 | 29490 | 13 | ||
12717 | 138544 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1718 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002605.6663 | 2114191.0771 | 37.7853126530384 | -122.434730153147 | (37.7853126530384, -122.434730153147) | 13 | 9 | 11 | 29490 | 13 | |||
12724 | 14708 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 835 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x5 | 6005346.74925 | 2111820.94662 | 37.7789600951073 | -122.425078130411 | (37.7789600951073, -122.425078130411) | 7 | 9 | 11 | 28852 | 41 | |||
13202 | 262227 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1970 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6002649 | 2114114 | 37.7851034789316 | -122.434574718683 | (37.7851034789316, -122.434574718683) | 13 | 9 | 11 | 29490 | 13 | ||||
13530 | 139881 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 880 MCALLISTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004889.3401 | 2111975.2309 | 37.7793578725397 | -122.426671482401 | (37.7793578725397, -122.426671482401) | 7 | 9 | 11 | 28852 | 41 | |||
13750 | 131122 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2656 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6000151.03379 | 2117775.39495 | 37.7950145919074 | -122.443479969847 | (37.7950145919074, -122.443479969847) | 13 | 9 | 1 | 57 | 27 | |||
14132 | 33660 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 511 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | 12 | Permit Number 37748 | 6004957.21005 | 2110733.77461 | 37.7759529745959 | -122.426348276967 | (37.7759529745959, -122.426348276967) | 7 | 9 | 11 | 28852 | 10 | |
14150 | 66359 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2781 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1990 12:00:00 AM | 10 | Permit Number 29480 | 5999713.32348 | 2118077.83983 | 37.7958200535154 | -122.44501626012 | (37.7958200535154, -122.44501626012) | 13 | 9 | 1 | 57 | 17 | ||
14407 | 140024 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 759 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005524.7137 | 2112007.4564 | 37.7794822567875 | -122.424475749442 | (37.7794822567875, -122.424475749442) | 7 | 9 | 11 | 28852 | 41 | |||
14408 | 21578 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1500X Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6005420.25234 | 2114945.14105 | 37.7875425135346 | -122.425046202527 | (37.7875425135346, -122.425046202527) | 13 | 9 | 1 | 28858 | 41 | |||
14876 | 131093 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 700 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6004522.30586 | 2110914.37707 | 37.7764242714957 | -122.427865596041 | (37.7764242714957, -122.427865596041) | 7 | 9 | 11 | 28852 | 10 | |||
15222 | 131123 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2656 Broderick St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6000162.33786 | 2117769.61796 | 37.7949993744696 | -122.443440441045 | (37.7949993744696, -122.443440441045) | 13 | 9 | 1 | 57 | 27 | |||
15959 | 41228 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 3612 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 9 | 6x9 | Permit Number 41934 | 6002627.9328 | 2121021.08355 | 37.8040673483864 | -122.43514180026 | (37.8040673483864, -122.43514180026) | 13 | 9 | 1 | 57 | 17 |
16714 | 9748 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 710X McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 4x4 | 6005653.6676 | 2112008.06895 | 37.7794912200693 | -122.424029686189 | (37.7794912200693, -122.424029686189) | 7 | 9 | 11 | 28852 | 41 | |||
17470 | 2654 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1988 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2005 12:00:00 AM | 12 | 3X3 | 6004003.2237 | 2114978.8425 | 37.7875549020514 | -122.429951242636 | (37.7875549020514, -122.429951242636) | 13 | 9 | 11 | 29490 | 27 | ||
17538 | 62279 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 402 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1985 12:00:00 AM | Permit Number 22417 | 6004194.0150087 | 2109446.81508952 | 37.7723761286117 | -122.42889659515 | (37.7723761286117, -122.42889659515) | 7 | 9 | 11 | 29492 | 10 | ||
18439 | 138559 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1974 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002711.0771 | 2114100.2695 | 37.7850693022372 | -122.434358969608 | (37.7850693022372, -122.434358969608) | 13 | 9 | 11 | 29490 | 13 | |||
18894 | 9449 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 800X Golden Gate Ave | 5 | Front Yard : Yard | Tree | Rec/Park 5 | 12 | 3X3 | 6005556.1262 | 2112420.5622 | 37.780618317973 | -122.424396471178 | (37.780618317973, -122.424396471178) | 7 | 9 | 11 | 28852 | 41 | |||
20007 | 9462 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 800X Golden Gate Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.7806668426278 | -122.423843265886 | (37.7806668426278, -122.423843265886) | 7 | 9 | 11 | 28852 | 41 | |||
20064 | 14734 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 895 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4x4 | 6004929.3578 | 2111921.9134 | 37.7792137381495 | -122.426529246778 | (37.7792137381495, -122.426529246778) | 7 | 9 | 11 | 28852 | 41 | |||
20232 | 9509 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 967 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6004960.77102 | 2112258.50611 | 37.7801397147121 | -122.426444548222 | (37.7801397147121, -122.426444548222) | 7 | 9 | 11 | 28852 | 41 | |||
20392 | 139880 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 880 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004907.5201 | 2111976.7892 | 37.7793631790535 | -122.426608701123 | (37.7793631790535, -122.426608701123) | 7 | 9 | 11 | 28852 | 41 | |||
20405 | 30295 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2752 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1956 12:00:00 AM | 11 | Permit Number 138 | 6003556.8837 | 2117848.90682 | 37.7954100795518 | -122.431700481491 | (37.7954100795518, -122.431700481491) | 13 | 9 | 1 | 29490 | 27 | ||
20505 | 40366 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 2295 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/1999 12:00:00 AM | 3x3 | Permit Number 41481 | 6002535 | 2114717 | 37.7867526914161 | -122.435012263683 | (37.7867526914161, -122.435012263683) | 13 | 9 | 11 | 29490 | 27 | ||
20985 | 244448 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 410 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6003228.1083 | 2109752.0759 | 37.7731595808087 | -122.432259559738 | (37.7731595808087, -122.432259559738) | 15 | 9 | 11 | 29492 | 10 | |||
21028 | 30718 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 241 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 7 | Permit Number 34620 | 6005380.8128 | 2109903.2849 | 37.7736965870607 | -122.424823826582 | (37.7736965870607, -122.424823826582) | 7 | 9 | 11 | 28852 | 10 | |
21178 | 18274 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 1950 Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1991 12:00:00 AM | 6 | 4X4 | 6002841.4044 | 2114121.64086 | 37.7851353792725 | -122.433909606798 | (37.7851353792725, -122.433909606798) | 13 | 9 | 11 | 29490 | 13 | ||
21289 | 9463 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 800X Golden Gate Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.7806668426278 | -122.423843265886 | (37.7806668426278, -122.423843265886) | 7 | 9 | 11 | 28852 | 41 | |||
21292 | 54874 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 307 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/07/1987 12:00:00 AM | Permit Number 10736 | 6005088.85997209 | 2109865.83270132 | 37.773577258091 | -122.425831071144 | (37.773577258091, -122.425831071144) | 7 | 9 | 11 | 28852 | 10 | ||
21489 | 48897 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1300 @ Bush St Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51719 | 6006815.0157 | 2115389.3601 | 37.7888409183322 | -122.420252130458 | (37.7888409183322, -122.420252130458) | 13 | 9 | 10 | 28858 | 21 | |
21961 | 24235 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 200X Willow St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/1997 12:00:00 AM | 12 | 4X4 | 6006547.3507 | 2113418.3192 | 37.7834138390239 | -122.421038210119 | (37.7834138390239, -122.421038210119) | 7 | 9 | 11 | 28858 | 41 | ||
22534 | 35582 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 253 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45051 | 6004161.28149026 | 2109664.11690226 | 37.7729709335188 | -122.42902531943 | (37.7729709335188, -122.42902531943) | 7 | 9 | 11 | 29492 | 10 | ||
23134 | 244941 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 200 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6005560.7116 | 2109988.3721 | 37.7739403752865 | -122.424207580594 | (37.7739403752865, -122.424207580594) | 7 | 9 | 11 | 28852 | 10 | |||
23218 | 14711 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 845 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/1992 12:00:00 AM | 24 | 4x4 | 6005346.74925 | 2111820.94662 | 37.7789600951073 | -122.425078130411 | (37.7789600951073, -122.425078130411) | 7 | 9 | 11 | 28852 | 41 | ||
23642 | 137961 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1500 POST ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005059.7978 | 2114429.2557 | 37.7861056530691 | -122.426256561135 | (37.7861056530691, -122.426256561135) | 13 | 9 | 11 | 28858 | 13 | |||
24383 | 55999 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 445 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/25/1985 12:00:00 AM | Permit Number 22024 | 6003578.95473406 | 2108961.44046203 | 37.7710085763887 | -122.430989497843 | (37.7710085763887, -122.430989497843) | 15 | 9 | 11 | 29492 | 10 | ||
24705 | 61813 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 450 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/25/1985 12:00:00 AM | Permit Number 21843 | 6003535.2156876 | 2109007.84971849 | 37.7711335263844 | -122.431144105514 | (37.7711335263844, -122.431144105514) | 15 | 9 | 11 | 29492 | 10 | ||
24964 | 231526 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 151 Octavia St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6005594.53466 | 2109838.51296 | 37.7735308080253 | -122.424079921455 | (37.7735308080253, -122.424079921455) | 7 | 9 | 11 | 28852 | 10 | |||
26044 | 9456 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 800X Golden Gate Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005442.4 | 2112406.4818 | 37.7805732339777 | -122.424788902821 | (37.7805732339777, -122.424788902821) | 7 | 9 | 11 | 28852 | 41 | ||
26396 | 131141 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1903 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004432.10566 | 2117673.43429 | 37.7949778482947 | -122.428659552606 | (37.7949778482947, -122.428659552606) | 13 | 9 | 1 | 28858 | 27 | |||
26647 | 5929 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1350X Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003988.34928 | 2112887.72554 | 37.7818123765589 | -122.429853491465 | (37.7818123765589, -122.429853491465) | 7 | 9 | 11 | 29490 | 41 | |||
26652 | 67329 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1977 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/1992 12:00:00 AM | 22 | Permit Number 30812 | 6003593.71705 | 2118268.8436 | 37.7965652056786 | -122.431603027358 | (37.7965652056786, -122.431603027358) | 13 | 9 | 1 | 57 | 17 | ||
27012 | 255276 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 263 Willow St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 4ft | 6006404.75096 | 2113360.62408 | 37.7832473828943 | -122.421527451234 | (37.7832473828943, -122.421527451234) | 7 | 9 | 11 | 28858 | 41 | ||||
27262 | 139125 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1625 POST ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004353.1092 | 2114274.515 | 37.7856408039112 | -122.428690480676 | (37.7856408039112, -122.428690480676) | 13 | 9 | 11 | 29490 | 13 | |||
27285 | 28726 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 1570 Post St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2005 12:00:00 AM | 3 | 4X4 | 6004662.4699013 | 2114369.5525339 | 37.7859192566668 | -122.427626954987 | (37.7859192566668, -122.427626954987) | 13 | 9 | 11 | 28858 | 13 | ||
27584 | 231837 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 797 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003553.35396 | 2107702.80426 | 37.7675512175314 | -122.430988207659 | (37.7675512175314, -122.430988207659) | 7 | 9 | 5 | 28862 | 3 | |||
28688 | 106118 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2680 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 6000260.43777 | 2117853.06146 | 37.7952340822301 | -122.443106997597 | (37.7952340822301, -122.443106997597) | 13 | 9 | 1 | 57 | 17 | ||||
28795 | 139826 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 967 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004976.7272 | 2112280.9678 | 37.7802022909589 | -122.426390948236 | (37.7802022909589, -122.426390948236) | 7 | 9 | 11 | 28852 | 41 | |||
29009 | 131109 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2558 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6002485.73146 | 2116135.70249 | 37.7906452879037 | -122.435284237589 | (37.7906452879037, -122.435284237589) | 13 | 9 | 1 | 29490 | 27 | |||
29517 | 69364 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 3530 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1994 12:00:00 AM | 4 | Permit Number 33458 | 6002665.33965 | 2120755.09557 | 37.8033391394608 | -122.43499331679 | (37.8033391394608, -122.43499331679) | 13 | 9 | 1 | 57 | 17 | ||
29756 | 97341 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2211 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6002821.40981 | 2114736.53495 | 37.7868225877557 | -122.434022751483 | (37.7868225877557, -122.434022751483) | 13 | 9 | 11 | 29490 | 27 | ||||
30630 | 65820 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 3712 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/1990 12:00:00 AM | 8 | Permit Number 28809 | 6000193.05574 | 2121032.54213 | 37.8039602472242 | -122.443568660075 | (37.8039602472242, -122.443568660075) | 13 | 9 | 1 | 57 | 17 | |
30890 | 22683 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1391X Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 6003467.4183 | 2112420.8099 | 37.7805008292142 | -122.431622323402 | (37.7805008292142, -122.431622323402) | 15 | 9 | 11 | 29490 | 41 | ||||
30980 | 131133 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2351 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6002884.9513 | 2117123.67323 | 37.7933806649312 | -122.433973611493 | (37.7933806649312, -122.433973611493) | 13 | 9 | 1 | 29490 | 27 | |||
30989 | 14712 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 845 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/27/1993 12:00:00 AM | 8 | 4x4 | 6005208.5684 | 2111961.5273 | 37.779338288494 | -122.425566161521 | (37.779338288494, -122.425566161521) | 7 | 9 | 11 | 28852 | 41 | ||
31014 | 18276 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1950 Post St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002797.4872 | 2114109.7892 | 37.7851003452977 | -122.434060698947 | (37.7851003452977, -122.434060698947) | 13 | 9 | 11 | 29490 | 13 | |||
31062 | 65862 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 3470 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/1990 12:00:00 AM | 11 | Permit Number 28854 | 6000779.81446 | 2120350.83515 | 37.8021219079692 | -122.441489200862 | (37.8021219079692, -122.441489200862) | 13 | 9 | 1 | 57 | 17 | |
31834 | 9468 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 800X Golden Gate Ave | 24 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.7806668426278 | -122.423843265886 | (37.7806668426278, -122.423843265886) | 7 | 9 | 11 | 28852 | 41 | |||
31836 | 231904 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 473 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003459.73272 | 2108948.84711 | 37.7709672419712 | -122.431400991057 | (37.7709672419712, -122.431400991057) | 15 | 9 | 11 | 29492 | 10 | |||
32634 | 249729 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2500 Broderick St | 13 | Front Yard : Yard | Tree | Private 2 | 13 | 6000196.56443 | 2117292.56753 | 37.7936914715225 | -122.443287731662 | (37.7936914715225, -122.443287731662) | 13 | 9 | 1 | 57 | 27 | ||||
33626 | 140547 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1070 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002920.9581 | 2111949.1562 | 37.7791747971165 | -122.433479070172 | (37.7791747971165, -122.433479070172) | 15 | 9 | 11 | 29490 | 41 | |||
33708 | 138478 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1950 POST ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6002838.4954 | 2114119.309 | 37.7851288114946 | -122.433919504283 | (37.7851288114946, -122.433919504283) | 13 | 9 | 11 | 29490 | 13 | |||
33817 | 244498 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 312 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003755.0931 | 2109477.7604 | 37.7724362435631 | -122.430417075147 | (37.7724362435631, -122.430417075147) | 7 | 9 | 11 | 29492 | 10 | |||
34429 | 139420 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1655 POST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004239.614 | 2114256.4501 | 37.7855847783027 | -122.429081852859 | (37.7855847783027, -122.429081852859) | 13 | 9 | 11 | 29490 | 13 | |||
34443 | 14709 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 835 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/25/1995 12:00:00 AM | 12 | 4x4 | 6005346.74925 | 2111820.94662 | 37.7789600951073 | -122.425078130411 | (37.7789600951073, -122.425078130411) | 7 | 9 | 11 | 28852 | 41 | ||
35063 | 14672 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 739 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6005639.1537 | 2112019.7041 | 37.7795223479045 | -122.424080723662 | (37.7795223479045, -122.424080723662) | 7 | 9 | 11 | 28852 | 41 | |||
35101 | 14681 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 759 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 4x4 | 6005346.74925 | 2111820.94662 | 37.7789600951073 | -122.425078130411 | (37.7789600951073, -122.425078130411) | 7 | 9 | 11 | 28852 | 41 | |||
35712 | 131168 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1441 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006656.00707 | 2118345.9557 | 37.7969500318775 | -122.421012287183 | (37.7969500318775, -122.421012287183) | 13 | 9 | 10 | 28858 | 32 | |||
36041 | 255248 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 209x Willow St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006475 | 2113325 | 37.7831535286214 | -122.421281886667 | (37.7831535286214, -122.421281886667) | 7 | 9 | 11 | 28858 | 41 | ||||
36077 | 137872 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1949 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6003353.9315 | 2115440.7821 | 37.7887864788691 | -122.432230665553 | (37.7887864788691, -122.432230665553) | 13 | 9 | 1 | 29490 | 27 | |||
36109 | 139846 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 831 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005666.1543 | 2112377.1207 | 37.7805052508318 | -122.424012740844 | (37.7805052508318, -122.424012740844) | 7 | 9 | 11 | 28852 | 41 | |||
36143 | 231883 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 219 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003751.01313 | 2109121.58389 | 37.7714580388977 | -122.430405770732 | (37.7714580388977, -122.430405770732) | 15 | 9 | 11 | 29492 | 10 | |||
36659 | 131103 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2209 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6003240.49119 | 2116284.65901 | 37.791097117189 | -122.432683457585 | (37.791097117189, -122.432683457585) | 13 | 9 | 1 | 29490 | 27 |
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) );