Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87727 | 87727 | 65566 | Permitted Site 1 | Tree(s) :: 17 | 340 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/1990 12:00:00 AM | Permit Number 28465 | 6022030.55852908 | 2122617.11164597 | 37.8095323316173 | -122.368107024455 | (37.8095323316173, -122.368107024455) | |||
| 143067 | 143067 | 65565 | Permitted Site 1 | Tree(s) :: 17 | 282 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/1990 12:00:00 AM | Permit Number 28464 | 6022001.13211196 | 2122805.77301993 | 37.8100487398864 | -122.368221901586 | (37.8100487398864, -122.368221901586) | |||
| 90246 | 90246 | 65563 | Permitted Site 1 | Tree(s) :: 17 | 255 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/1990 12:00:00 AM | Permit Number 28462 | 6021766.42970205 | 2122905.90070123 | 37.8103107984086 | -122.36904110347099 | (37.8103107984086, -122.369041103471) | |||
| 93209 | 93209 | 65564 | Permitted Site 1 | Tree(s) :: 17 | 228 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/1990 12:00:00 AM | Permit Number 28463 | 6021524.08705829 | 2122941.38889516 | 37.8103949467147 | -122.36988228287599 | (37.8103949467147, -122.369882282876) | |||
| 2371 | 2371 | 253059 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 421 Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.8080000002 | 37.728495991679296 | -122.368425863032 | (37.7284959916793, -122.368425863032) | ||
| 2385 | 2385 | 253058 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 421 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.8080000002 | 37.728495991679296 | -122.368425863032 | (37.7284959916793, -122.368425863032) | ||
| 2395 | 2395 | 253061 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 421 Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.8080000002 | 37.728495991679296 | -122.368425863032 | (37.7284959916793, -122.368425863032) | ||
| 2462 | 2462 | 253060 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 421 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.8080000002 | 37.728495991679296 | -122.368425863032 | (37.7284959916793, -122.368425863032) | ||
| 2365 | 2365 | 253069 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 2380 | 2380 | 253068 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 2382 | 2382 | 253067 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 2384 | 2384 | 253066 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 2373 | 2373 | 253062 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 451 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770412 | 6021215.947000001 | 2093217.369 | 37.728762049698204 | -122.36889409743 | (37.7287620496982, -122.36889409743) | ||
| 2421 | 2421 | 253064 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 451 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770412 | 6021215.947000001 | 2093217.369 | 37.728762049698204 | -122.36889409743 | (37.7287620496982, -122.36889409743) | ||
| 2431 | 2431 | 253063 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 451 Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770412 | 6021215.947000001 | 2093217.369 | 37.728762049698204 | -122.36889409743 | (37.7287620496982, -122.36889409743) | ||
| 2405 | 2405 | 201816 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021143.08428 | 2093327.21502 | 37.729059670062206 | -122.36915357747299 | (37.7290596700622, -122.369153577473) | ||
| 2369 | 2369 | 201815 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021129.2467 | 2093308.19399 | 37.7290066829092 | -122.369200102111 | (37.7290066829092, -122.369200102111) | ||
| 2391 | 2391 | 201814 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021112.10587 | 2093285.4865 | 37.728943392223 | -122.36925779181699 | (37.728943392223, -122.369257791817) | ||
| 2466 | 2466 | 201813 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021086.18405 | 2093254.37787 | 37.728856551886395 | -122.369345258092 | (37.7288565518864, -122.369345258092) | ||
| 2367 | 2367 | 253057 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6021055.26176 | 2093480.52839 | 37.729475822337605 | -122.36946777993099 | (37.7294758223376, -122.369467779931) | |
| 2386 | 2386 | 201590 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6021055.26176 | 2093480.52839 | 37.729475822337605 | -122.36946777993099 | (37.7294758223376, -122.369467779931) | |
| 2455 | 2455 | 201589 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6021039.89306 | 2093459.94557 | 37.729418462686894 | -122.369519490027 | (37.7294184626869, -122.369519490027) | |
| 2374 | 2374 | 201588 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6021025.00287 | 2093440.1386 | 37.7293632596022 | -122.369569599359 | (37.7293632596022, -122.369569599359) | |
| 2389 | 2389 | 201587 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6021008.9496 | 2093419.1731599998 | 37.729304811746104 | -122.36962364951799 | (37.7293048117461, -122.369623649518) | |
| 2403 | 2403 | 201586 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020998.06283 | 2093403.93478 | 37.729262372745794 | -122.36966023392799 | (37.7292623727458, -122.369660233928) | |
| 2460 | 2460 | 201825 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 232 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020928.29141 | 2093111.1924700001 | 37.7284547293849 | -122.36988121894899 | (37.7284547293849, -122.369881218949) | |
| 2433 | 2433 | 201610 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 599 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770566 | 6020924.70462 | 2093166.9470099998 | 37.7286076240414 | -122.36989747059201 | (37.7286076240414, -122.369897470592) | |
| 2422 | 2422 | 201585 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020918.10936 | 2093291.5638700002 | 37.728949436562 | -122.36992888032302 | (37.728949436562, -122.369928880323) | |
| 2435 | 2435 | 201826 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 250 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020898.42083 | 2093071.04954 | 37.7283428654122 | -122.369981710984 | (37.7283428654122, -122.369981710984) | |
| 2446 | 2446 | 201827 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 258 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020879.65439 | 2093047.83852 | 37.7282781025329 | -122.370044984594 | (37.7282781025329, -122.370044984594) | |
| 2392 | 2392 | 253051 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2397 | 2397 | 253052 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2413 | 2413 | 253048 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2414 | 2414 | 253049 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2448 | 2448 | 253050 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2464 | 2464 | 253053 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2444 | 2444 | 201828 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 268 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020862.97624 | 2093021.3694799999 | 37.728204508308 | -122.3701008136 | (37.728204508308, -122.3701008136) | |
| 2406 | 2406 | 201829 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 284 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020846.41585 | 2093000.7945400001 | 37.7281471046068 | -122.37015664263399 | (37.7281471046068, -122.370156642634) | |
| 2412 | 2412 | 201597 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020830.52372 | 2093183.4296400002 | 37.728647714022 | -122.37022420239201 | (37.728647714022, -122.370224202392) | |
| 2423 | 2423 | 201830 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 292 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020827.60649 | 2092975.44043 | 37.7280764547545 | -122.370219916224 | (37.7280764547545, -122.370219916224) | |
| 2415 | 2415 | 201596 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020816.91369 | 2093164.12057 | 37.7285939480275 | -122.370269919443 | (37.7285939480275, -122.370269919443) | |
| 2376 | 2376 | 201595 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020802.701169999 | 2093144.94147 | 37.7285405058214 | -122.370317728275 | (37.7285405058214, -122.370317728275) | |
| 2377 | 2377 | 201594 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020788.86166 | 2093125.8535099998 | 37.7284873343211 | -122.370364253806 | (37.7284873343211, -122.370364253806) | |
| 2447 | 2447 | 201593 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020771.25022 | 2093102.78815 | 37.72842303458621 | -122.370423544329 | (37.7284230345862, -122.370423544329) | |
| 2411 | 2411 | 201831 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020768.36275 | 2092897.8842900002 | 37.7278602487283 | -122.37041936696698 | (37.7278602487283, -122.370419366967) | |
| 2393 | 2393 | 201592 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020757.80811 | 2093085.24603 | 37.7283741294404 | -122.370468802689 | (37.7283741294404, -122.370468802689) | |
| 2390 | 2390 | 201832 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020752.62591 | 2092874.74971 | 37.727795861786205 | -122.370472171548 | (37.7277958617862, -122.370472171548) | |
| 2437 | 2437 | 201591 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020744.06411 | 2093067.1780599998 | 37.7283237638216 | -122.37051506831001 | (37.7283237638216, -122.37051506831) | |
| 2454 | 2454 | 201833 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020733.63229 | 2092847.8779900002 | 37.727721034575296 | -122.370535976659 | (37.7277210345753, -122.370535976659) | |
| 2362 | 2362 | 201584 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020732.46705 | 2093049.56763 | 37.7282747723482 | -122.370553943333 | (37.7282747723482, -122.370553943333) | |
| 2461 | 2461 | 201834 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020718.56969 | 2092826.63123 | 37.7276618681873 | -122.37058658062 | (37.7276618681873, -122.37058658062) | |
| 2419 | 2419 | 201835 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020706.7385 | 2092807.85492 | 37.72760966254629 | -122.370626184075 | (37.7276096625463, -122.370626184075) | |
| 2372 | 2372 | 201583 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020706.31037 | 2093011.12913 | 37.7281677917075 | -122.370641712658 | (37.7281677917075, -122.370641712658) | |
| 2453 | 2453 | 201836 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020688.4191 | 2092782.87071 | 37.7275400550072 | -122.370687788509 | (37.7275400550072, -122.370687788509) | |
| 2452 | 2452 | 201837 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020676.58787 | 2092764.09442 | 37.7274878493838 | -122.370727391967 | (37.7274878493838, -122.370727391967) | |
| 2400 | 2400 | 201838 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020663.4716 | 2092744.71005 | 37.7274339035298 | -122.37077139578501 | (37.7274339035298, -122.370771395785) | |
| 2456 | 2456 | 201598 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020624.74965 | 2092745.3424200001 | 37.7274335141325 | -122.370905303063 | (37.7274335141325, -122.370905303063) | |
| 2441 | 2441 | 201599 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020607.895690001 | 2092757.2128700002 | 37.72746518285071 | -122.37096438849899 | (37.7274651828507, -122.370964388499) | |
| 2430 | 2430 | 201600 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 Kirkwood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020594.26008 | 2092766.53995 | 37.7274900446232 | -122.371012172182 | (37.7274900446232, -122.371012172182) | |
| 80292 | 80292 | 93212 | Permitted Site 1 | Tree(s) :: 17 | 655 Innes Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.729376996017606 | -122.371154647854 | (37.7293769960176, -122.371154647854) | ||
| 81510 | 81510 | 93211 | Permitted Site 1 | Tree(s) :: 17 | 655 Innes Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.729376996017606 | -122.371154647854 | (37.7293769960176, -122.371154647854) | ||
| 84352 | 84352 | 93214 | Permitted Site 1 | Tree(s) :: 17 | 655 Innes Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.729376996017606 | -122.371154647854 | (37.7293769960176, -122.371154647854) | ||
| 99680 | 99680 | 93208 | Permitted Site 1 | Tree(s) :: 17 | 655 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.729376996017606 | -122.371154647854 | (37.7293769960176, -122.371154647854) | ||
| 111669 | 111669 | 93209 | Permitted Site 1 | Tree(s) :: 17 | 655 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.729376996017606 | -122.371154647854 | (37.7293769960176, -122.371154647854) | ||
| 113795 | 113795 | 93213 | Permitted Site 1 | Tree(s) :: 17 | 655 Innes Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.729376996017606 | -122.371154647854 | (37.7293769960176, -122.371154647854) | ||
| 146160 | 146160 | 93210 | Permitted Site 1 | Tree(s) :: 17 | 655 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.729376996017606 | -122.371154647854 | (37.7293769960176, -122.371154647854) | ||
| 82128 | 82128 | 39988 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 702 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | Permit Number 41246 | 6020313.39222717 | 2093680.55714076 | 37.729984337867705 | -122.37204636190701 | (37.7299843378677, -122.372046361907) | ||
| 53060 | 53060 | 39989 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 710 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 12 | Permit Number 41247 | 6020263.29136 | 2093725.43573 | 37.73010481357829 | -122.372222673141 | (37.7301048135783, -122.372222673141) | |
| 73500 | 73500 | 39990 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 714 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 10 | Permit Number 41248 | 6020251.6051199995 | 2093735.0931099998 | 37.730130688869295 | -122.372263742486 | (37.7301306888693, -122.372263742486) | |
| 51306 | 51306 | 39991 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 724 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 10 | Permit Number 41249 | 6020211.31416 | 2093764.16933 | 37.730208312959995 | -122.372405046655 | (37.73020831296, -122.372405046655) | |
| 181388 | 181388 | 39992 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 744 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 10 | Permit Number 41250 | 6020175.81777 | 2093790.38567 | 37.7302783476475 | -122.372529577584 | (37.7302783476475, -122.372529577584) | |
| 77552 | 77552 | 50767 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Innes Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | Permit Number 47301 | 6019786.72970778 | 2094070.44918577 | 37.73102596117 | -122.373894113437 | (37.73102596117, -122.373894113437) | |||
| 81095 | 81095 | 50764 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Innes Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | Permit Number 47301 | 6019786.72970778 | 2094070.44918577 | 37.73102596117 | -122.373894113437 | (37.73102596117, -122.373894113437) | |||
| 142095 | 142095 | 50766 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Innes Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | Permit Number 47301 | 6019786.72970778 | 2094070.44918577 | 37.73102596117 | -122.373894113437 | (37.73102596117, -122.373894113437) | |||
| 143984 | 143984 | 50765 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Innes Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | Permit Number 47301 | 6019786.72970778 | 2094070.44918577 | 37.73102596117 | -122.373894113437 | (37.73102596117, -122.373894113437) | |||
| 175526 | 175526 | 50769 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | 5 | Permit Number 47301 | 6019759.98299 | 2094100.60005 | 37.7311072788765 | -122.373988670067 | (37.7311072788765, -122.373988670067) | ||
| 147101 | 147101 | 50770 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | 5 | Permit Number 47301 | 6019742.9176 | 2094113.11365 | 37.7311407003688 | -122.374048535228 | (37.7311407003688, -122.374048535228) | ||
| 123411 | 123411 | 50768 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | 5 | Permit Number 47301 | 6019728.52002 | 2094123.20714 | 37.7311676233867 | -122.374099009669 | (37.7311676233867, -122.374099009669) | ||
| 33756 | 33756 | 44524 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2001 12:00:00 AM | 7 | Permit Number 43824 | 6019592.367330001 | 2094224.8297299999 | 37.73143917097 | -122.37457675743799 | (37.73143917097, -122.374576757438) | ||
| 65032 | 65032 | 44522 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2001 12:00:00 AM | 7 | Permit Number 43824 | 6019580.98035 | 2094232.6652900001 | 37.731460059529795 | -122.37461666754601 | (37.7314600595298, -122.374616667546) | ||
| 61890 | 61890 | 44521 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2001 12:00:00 AM | 7 | Permit Number 43824 | 6019557.73451 | 2094250.2049099999 | 37.731506941191 | -122.37469824864999 | (37.731506941191, -122.37469824865) | ||
| 53030 | 53030 | 44523 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Innes Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2001 12:00:00 AM | 6 | Permit Number 43824 | 6019546.1676 | 2094257.53708 | 37.7315264375989 | -122.37473874602101 | (37.7315264375989, -122.374738746021) | ||
| 132075 | 132075 | 39994 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 863 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2005 12:00:00 AM | 12 | 3x3 | Permit Number 41252 | 6019434.68731 | 2094262.5096 | 37.731533957726796 | -122.375124503897 | (37.7315339577268, -122.375124503897) |
| 131343 | 131343 | 39995 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 869 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2004 12:00:00 AM | 6 | 3x3 | Permit Number 47551 | 6019405.77873 | 2094282.05396 | 37.7315860320638 | -122.375225801726 | (37.7315860320638, -122.375225801726) |
| 166526 | 166526 | 39997 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 871 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 5 | Permit Number 41255 | 6019390.137999999 | 2094293.5520799998 | 37.731616743009795 | -122.375280672083 | (37.7316167430098, -122.375280672083) | |
| 163542 | 163542 | 40000 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 881 Innes Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 14 | Permit Number 41257 | 6019376.91864 | 2094304.0292599997 | 37.7316447838739 | -122.375327100491 | (37.7316447838739, -122.375327100491) | |
| 167480 | 167480 | 40003 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 881 Innes Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 8 | Permit Number 41257 | 6019368.47353 | 2094309.06128 | 37.7316581360927 | -122.375356645916 | (37.7316581360927, -122.375356645916) | |
| 176782 | 176782 | 40001 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 881 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 12 | Permit Number 41257 | 6019355.96693 | 2094318.55144 | 37.7316835059849 | -122.375400541805 | (37.7316835059849, -122.375400541805) | |
| 151822 | 151822 | 39999 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 881 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 13 | Permit Number 41257 | 6019347.79521 | 2094325.03679 | 37.731700863794295 | -122.37542924278799 | (37.7317008637943, -122.375429242788) | |
| 168045 | 168045 | 40002 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 881 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 8 | Permit Number 41257 | 6019340.13593 | 2094332.72798 | 37.731721560802 | -122.375456255711 | (37.731721560802, -122.375456255711) | |
| 135633 | 135633 | 88041 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 895 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51054 | 6019312.19901 | 2094352.0099400003 | 37.7317729678294 | -122.375554176579 | (37.7317729678294, -122.375554176579) | |
| 37358 | 37358 | 88040 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 895 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51054 | 6019291.73542 | 2094366.52239 | 37.731811689946795 | -122.37562592991199 | (37.7318116899468, -122.375625929912) | |
| 29494 | 29494 | 84619 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 895 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767653 | 6019276.35845 | 2094378.9880400002 | 37.7318450718732 | -122.37567995576799 | (37.7318450718732, -122.375679955768) |
| 76811 | 76811 | 50621 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 820 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2003 12:00:00 AM | Permit Number 47218 | 6019242.65386152 | 2094476.11509562 | 37.7321099088197 | -122.375803212343 | (37.7321099088197, -122.375803212343) | |||
| 120515 | 120515 | 40005 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 911 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | Permit Number 41258 | 6019178.20708985 | 2094459.30382263 | 37.7320602007089 | -122.376024856319 | (37.7320602007089, -122.376024856319) | ||
| 122101 | 122101 | 39993 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 860 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | Permit Number 41251 | 6019175.31340513 | 2094526.32452806 | 37.73224406729229 | -122.376039506051 | (37.7322440672923, -122.376039506051) | ||
| 86628 | 86628 | 39996 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 870 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | Permit Number 41254 | 6019158.47829216 | 2094538.87688533 | 37.7322776068337 | -122.376098579608 | (37.7322776068337, -122.376098579608) | ||
| 117097 | 117097 | 39998 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 880 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | Permit Number 41256 | 6019141.64317919 | 2094551.4292426002 | 37.732311146345296 | -122.376157653218 | (37.7323111463453, -122.376157653218) | ||
| 183664 | 183664 | 40006 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 930 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 12 | Permit Number 41259 | 6019126.39744 | 2094573.6221900003 | 37.7323712445238 | -122.376211900284 | (37.7323712445238, -122.376211900284) | |
| 160223 | 160223 | 40004 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 911 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 2 | Permit Number 41258 | 6019111.21169 | 2094496.3329 | 37.7321581870346 | -122.376259043617 | (37.7321581870346, -122.376259043617) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");