trees
143 rows where qSpecies_id = 304
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6845 | 31172 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 100 Shields St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1995 12:00:00 AM | Permit Number 34871 | 5993759.19888335 | 2089860.63162869 | 37.7180012684503 | -122.463569614328 | (37.7180012684503, -122.463569614328) | 9 | 8 | 6 | 64 | 24 | |||
7405 | 27583 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 1781 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2015 12:00:00 AM | 5 | 3X3 | 6001531.97079 | 2112100.50741 | 37.7795114663002 | -122.438294983579 | (37.7795114663002, -122.438294983579) | 15 | 5 | 11 | 29490 | 41 | ||
7625 | 31171 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 100 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1995 12:00:00 AM | Permit Number 34871 | 5993759.19888335 | 2089860.63162869 | 37.7180012684503 | -122.463569614328 | (37.7180012684503, -122.463569614328) | 9 | 8 | 6 | 64 | 24 | |||
8617 | 72845 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 2625 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5989234.0157 | 2097465.6374 | 37.7386209048407 | -122.479767197253 | (37.7386209048407, -122.479767197253) | 1 | 8 | 3 | 29491 | 35 | |||
10760 | 31310 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 577 Birch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 0 | Permit Number 34948 | 6005032.34705274 | 2111420.35666119 | 37.7778424079953 | -122.4261372481 | (37.7778424079953, -122.4261372481) | 7 | 9 | 11 | 28852 | 10 | |
14501 | 31307 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 569 Birch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 0 | Permit Number 34947 | 6005068.91365842 | 2111425.45669453 | 37.7778584781223 | -122.426011114528 | (37.7778584781223, -122.426011114528) | 7 | 9 | 11 | 28852 | 10 | |
15804 | 250985 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 169 Seal Rock Dr | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5981053.81587 | 2112927.80421 | 37.7805969621145 | -122.509197833038 | (37.7805969621145, -122.509197833038) | 11 | 6 | 2 | 55 | 26 | |||
16628 | 43623 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 210 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2000 12:00:00 AM | Permit Number 43272 | |||||||||||||
19386 | 193544 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 900x Carolina St | 10 | Median : Yard | Tree | DPW 1 | 22 | 6012476.68739 | 2103624.07862 | 37.7568535209843 | -122.399836927655 | (37.7568535209843, -122.399836927655) | 10 | 3 | 8 | 28856 | 29 | ||||
24353 | 34824 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 3607 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1998 12:00:00 AM | 10 | Permit Number 38713 | 5984365.3802 | 2113132.09169 | 37.7813525599643 | -122.49775681803 | (37.7813525599643, -122.49775681803) | 11 | 6 | 2 | 55 | 26 | |
25778 | 39830 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 1900 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41153 | 5981364.12857436 | 2102124.06115885 | 37.7509513011754 | -122.507322554156 | (37.7509513011754, -122.507322554156) | 1 | 8 | 3 | 29491 | 35 | ||
25925 | 210093 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 1x Minerva St | 16 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 5996144.00036 | 2089001.40747 | 37.715779161942 | -122.455264383739 | (37.715779161942, -122.455264383739) | 9 | 8 | 6 | 28861 | 24 | |||
26551 | 40541 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 389 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/2005 12:00:00 AM | Permit Number 48035 | 5992634.70647519 | 2093966.0670834 | 37.7292089323345 | -122.467754881103 | (37.7292089323345, -122.467754881103) | 9 | 8 | 4 | 59 | 40 | ||
26585 | 39836 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 2048 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41158 | 5981224.57274912 | 2101126.86261798 | 37.7482050538241 | -122.507731152524 | (37.7482050538241, -122.507731152524) | 1 | 8 | 3 | 29491 | 35 | ||
28700 | 119904 | Undocumented 4 | Melaleuca nesophila :: Pink Melaleuca 304 | 517 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003302 | 2096146 | 37.7358047110715 | -122.431032679091 | (37.7358047110715, -122.431032679091) | 2 | 7 | 5 | 63 | 7 | ||||
29792 | 24841 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 200X Alemany Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 01/12/1996 12:00:00 AM | 8 | 3X3 | 6009416.6826304 | 2095906.0445619 | 37.7354904326241 | -122.409874802768 | (37.7354904326241, -122.409874802768) | 10 | 7 | 7 | 28859 | 2 | ||
32466 | 39815 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 2090 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | 6 | Permit Number 41146 | 5982333.7204 | 2100889.1498 | 37.7476176430491 | -122.503878215538 | (37.7476176430491, -122.503878215538) | 1 | 8 | 3 | 29491 | 35 | |
34109 | 27505 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 1761 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2x2 | 6001633.12831 | 2112159.85861 | 37.7796801826881 | -122.437949289652 | (37.7796801826881, -122.437949289652) | 15 | 5 | 11 | 29490 | 41 | |||
34851 | 98357 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 4201 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5981815.8 | 2104809.3 | 37.7583508013597 | -122.505959722614 | (37.7583508013597, -122.505959722614) | 1 | 8 | 3 | 56 | 35 | |||
36692 | 31305 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 561 Birch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 0 | Permit Number 34946 | 6005105.48028119 | 2111430.55673025 | 37.7778745481219 | -122.425884980842 | (37.7778745481219, -122.425884980842) | 7 | 9 | 11 | 28852 | 10 | |
39168 | 184530 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 4045 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5981394.5999 | 2102116.7749 | 37.7509330899515 | -122.507216642728 | (37.7509330899515, -122.507216642728) | 1 | 8 | 3 | 29491 | 35 | |||
41611 | 31640 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 2594 Great Hwy | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1995 12:00:00 AM | Permit Number 35156 | 5981541.24493631 | 2097437.52256583 | 37.738093803256 | -122.506362582222 | (37.738093803256, -122.506362582222) | 1 | 8 | 3 | 29491 | 35 | ||
42380 | 15073 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 30X Minerva St | 5 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5996426.1222644 | 2089040.1488729 | 37.7159017196126 | -122.454292042688 | (37.7159017196126, -122.454292042688) | 9 | 8 | 6 | 28861 | 24 | |||
42680 | 114672 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 85X Peralta Ave | 2 | Side Yard : Yard | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 775155 | 6010502.29579 | 2100335.12269 | 37.7477125069204 | -122.406433397576 | (37.7477125069204, -122.406433397576) | 2 | 7 | 7 | 28859 | 2 | |||
45362 | 193542 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 610 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6016043.65792 | 2103986.82395 | 37.7580477514291 | -122.387526213378 | (37.7580477514291, -122.387526213378) | 10 | 3 | 8 | 28856 | 29 | |||
45790 | 46376 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 2231 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | 6 | Permit Number 44613 | 5982943.5226 | 2099924.3833 | 37.7450044993486 | -122.501698223647 | (37.7450044993486, -122.501698223647) | 1 | 8 | 3 | 29491 | 35 | |
47196 | 232034 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 5 Clarendon Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 2ft | 5998231.75186 | 2104660.34285 | 37.7588944118522 | -122.449175639859 | (37.7588944118522, -122.449175639859) | 15 | 5 | 4 | 28862 | 38 | |||
47245 | 37087 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 1431 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39687 | 5981822.5647819 | 2105347.10091721 | 37.7598278475269 | -122.50597620053 | (37.7598278475269, -122.50597620053) | 1 | 8 | 3 | 56 | 35 | ||
47286 | 40218 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 139 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1999 12:00:00 AM | Permit Number 41397 | 5981206.29115693 | 2112930.16439571 | 37.7806124308083 | -122.508670533035 | (37.7806124308083, -122.508670533035) | 11 | 6 | 2 | 55 | 26 | ||
47427 | 40023 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 1571 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 5 | Permit Number 41268 | 6015526.3634 | 2095776.2911 | 37.7354746704031 | -122.388742090508 | (37.7354746704031, -122.388742090508) | 10 | 3 | 8 | 58 | 1 | |
48044 | 43824 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 2539 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2000 12:00:00 AM | Permit Number 43452 | 5985490.59688758 | 2097934.34218836 | 37.7396896615859 | -122.492744480822 | (37.7396896615859, -122.492744480822) | 1 | 8 | 3 | 29491 | 35 | ||
50023 | 87297 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 4227 Lincoln Way | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773956 | 5982573 | 2106897.6 | 37.7641292203973 | -122.50349567213 | (37.7641292203973, -122.50349567213) | 1 | 8 | 3 | 56 | 35 | ||
50721 | 31638 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 2562 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1995 12:00:00 AM | Permit Number 35155 | 5981524.37597425 | 2097644.9749882 | 37.7386624172308 | -122.506436285686 | (37.7386624172308, -122.506436285686) | 1 | 8 | 3 | 29491 | 35 | ||
50778 | 193546 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 900x Carolina St | 56 | Median : Yard | Tree | DPW 1 | 14 | 6012511.31155 | 2102952.51316 | 37.7550114792069 | -122.399670032347 | (37.7550114792069, -122.399670032347) | 10 | 3 | 8 | 28856 | 29 | ||||
50838 | 31635 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 2538 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1995 12:00:00 AM | Permit Number 35152 | 5981511.7242527 | 2097800.56430497 | 37.7390888776464 | -122.506491564023 | (37.7390888776464, -122.506491564023) | 1 | 8 | 3 | 29491 | 35 | ||
50900 | 28136 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 412 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4X4 | 6006951.93492 | 2097890.14157 | 37.7407998823106 | -122.41853703365 | (37.7407998823106, -122.41853703365) | 2 | 7 | 7 | 28859 | 2 | |||
52097 | 120897 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 3760 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2016 12:00:00 AM | 3 | 2x5 | Permit Number 778876 | 6002560.418 | 2121574.39052 | 37.8055827492151 | -122.435415043973 | (37.8055827492151, -122.435415043973) | 13 | 9 | 1 | 57 | 17 | |
53392 | 193547 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 900x Carolina St | 65 | Median : Yard | Tree | DPW 1 | 11 | 6012516.83998 | 2102871.66546 | 37.7547897972265 | -122.399645237145 | (37.7547897972265, -122.399645237145) | 10 | 3 | 8 | 28856 | 29 | ||||
53444 | 31642 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 3601 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1995 12:00:00 AM | Permit Number 35157 | 5982065.15070434 | 2098736.73871701 | 37.7416919237879 | -122.504647444825 | (37.7416919237879, -122.504647444825) | 1 | 8 | 3 | 29491 | 35 | ||
53998 | 250991 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 418 45th Ave | 2 | : | Tree | Private 2 | 7 | Width 3ft | 5981922.93947 | 2112926.15087 | 37.7806436252297 | -122.506191049582 | (37.7806436252297, -122.506191049582) | 11 | 6 | 2 | 55 | 26 | |||
56030 | 183035 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 2522 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5981504.4178 | 2097898.5163 | 37.7393573965741 | -122.506524088332 | (37.7393573965741, -122.506524088332) | 1 | 8 | 3 | 29491 | 35 | |||
57721 | 15081 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 80X Minerva St | 2 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5996060.1066716 | 2089044.9734463 | 37.7158939701237 | -122.455557504311 | (37.7158939701237, -122.455557504311) | 9 | 8 | 6 | 28861 | 24 | |||
58613 | 232033 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 517 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003277.43124 | 2096153.40981 | 37.7358236645184 | -122.431118151596 | (37.7358236645184, -122.431118151596) | 2 | 7 | 5 | 63 | 7 | |||
60249 | 39996 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 870 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | Permit Number 41254 | 6019158.47829216 | 2094538.87688533 | 37.7322776068337 | -122.376098579608 | (37.7322776068337, -122.376098579608) | 10 | 3 | 8 | 58 | 1 | ||
60427 | 38919 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 739 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/25/2002 12:00:00 AM | Permit Number 40729 | 5994644.0321122 | 2089899.68618843 | 37.7181594465135 | -122.460513981509 | (37.7181594465135, -122.460513981509) | 9 | 8 | 6 | 28861 | 24 | ||
60730 | 114671 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 85X Peralta Ave | 1 | Side Yard : Yard | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 775155 | 6010502.29579 | 2100335.12269 | 37.7477125069204 | -122.406433397576 | (37.7477125069204, -122.406433397576) | 2 | 7 | 7 | 28859 | 2 | |||
60747 | 31627 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 2430 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1995 12:00:00 AM | 0 | Permit Number 35144 | 5981797.10260903 | 2098537.8771738 | 37.7411301336904 | -122.505559512184 | (37.7411301336904, -122.505559512184) | 1 | 8 | 3 | 29491 | 35 | |
61579 | 37484 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 1246 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39953 | 5990822.12261544 | 2106914.97361747 | 37.7646584370326 | -122.474965909131 | (37.7646584370326, -122.474965909131) | 11 | 8 | 11 | 56 | 12 | ||
61763 | 37119 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 4731 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 0 | Permit Number 39709 | 5981101.19035238 | 2106191.54023256 | 37.7621039464825 | -122.508533725105 | (37.7621039464825, -122.508533725105) | 1 | 8 | 3 | 56 | 35 | |
63875 | 43626 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 2222 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | 7 | Permit Number 43275 | 5985464.7649 | 2100074.5033 | 37.7455644571804 | -122.49299140272 | (37.7455644571804, -122.49299140272) | 1 | 8 | 3 | 29491 | 35 | |
63876 | 37113 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 4523 IRVING ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 0 | Permit Number 39706 | 5981665.2 | 2106185.8 | 37.7621214108202 | -122.506582640723 | (37.7621214108202, -122.506582640723) | 1 | 8 | 3 | 56 | 35 | |
64173 | 37248 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 3038 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | Permit Number 39801 | 5985578.39129143 | 2101634.00517992 | 37.7498530704582 | -122.492713344722 | (37.7498530704582, -122.492713344722) | 1 | 8 | 3 | 29491 | 35 | ||
64734 | 47907 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 746 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2002 12:00:00 AM | 7 | Permit Number 45646 | 6000056.4472 | 2111499.7732 | 37.7777779701242 | -122.4433562713 | (37.7777779701242, -122.4433562713) | 15 | 5 | 11 | 29490 | 16 | |
65169 | 43610 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 2174 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43264 | 5986078.58326706 | 2100441.09799391 | 37.746606905592 | -122.490895913514 | (37.746606905592, -122.490895913514) | 1 | 8 | 3 | 29491 | 35 | ||
68371 | 80263 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 2074 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50734 | 5982335.751 | 2100990.6763 | 37.7478965259448 | -122.503878712284 | (37.7478965259448, -122.503878712284) | 1 | 8 | 3 | 29491 | 35 | |
71119 | 193543 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 610 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6016026.74063 | 2103985.73325 | 37.7580438195766 | -122.387584645024 | (37.7580438195766, -122.387584645024) | 10 | 3 | 8 | 28856 | 29 | |||
71928 | 210096 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 300 Junipero Serra Blvd | 45 | : | Tree | Private 2 | 4 | Width 0ft | 5991386.50066 | 2094355.85884 | 37.7302070503046 | -122.472098393852 | (37.7302070503046, -122.472098393852) | 9 | 8 | 4 | 64 | 40 | |||
72716 | 139625 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 1761 TURK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6001622.1557 | 2112159.8649 | 37.779679575976 | -122.437987249049 | (37.779679575976, -122.437987249049) | 15 | 5 | 11 | 29490 | 41 | |||
73709 | 31634 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 2526 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1995 12:00:00 AM | Permit Number 35151 | 5981505.3983929 | 2097878.35895124 | 37.7393021077999 | -122.506519203426 | (37.7393021077999, -122.506519203426) | 1 | 8 | 3 | 29491 | 35 | ||
74167 | 218220 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 300 Claremont Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 5993448.22771 | 2098043.70132 | 37.7404520434185 | -122.465238556823 | (37.7404520434185, -122.465238556823) | 1 | 8 | 4 | 59 | 40 | |||
74428 | 46398 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 2363 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/2002 12:00:00 AM | Permit Number 44628 | 5982038.69993379 | 2099019.08157606 | 37.7424656032555 | -122.504759817001 | (37.7424656032555, -122.504759817001) | 1 | 8 | 3 | 29491 | 35 | |||
79028 | 210098 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 400 Junipero Serra Blvd | 18 | : | Tree | Private 2 | 17 | Width 0ft | 5991367.91013 | 2094058.78209 | 37.7293902761378 | -122.472141017221 | (37.7293902761378, -122.472141017221) | 9 | 8 | 4 | 64 | 40 | |||
79593 | 37811 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 354 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40131 | 6004085.30799236 | 2091240.01678916 | 37.7223783311972 | -122.427974988755 | (37.7223783311972, -122.427974988755) | 9 | 7 | 6 | 28861 | 5 | ||
81575 | 38360 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 1610 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41156 | 5980983.59087853 | 2104088.99570474 | 37.7563240309044 | -122.508784338324 | (37.7563240309044, -122.508784338324) | 1 | 8 | 3 | 56 | 35 | ||
87453 | 183353 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 3542 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5982133.0347 | 2100158.2902 | 37.7455991034071 | -122.504518023708 | (37.7455991034071, -122.504518023708) | 1 | 8 | 3 | 29491 | 35 | |||
87467 | 37114 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 4540 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 0 | Permit Number 39707 | 5981688.69009077 | 2106263.69511954 | 37.7623366715481 | -122.506507175967 | (37.7623366715481, -122.506507175967) | 1 | 8 | 3 | 56 | 35 | |
89838 | 49454 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 277@ BLANKEN Wheeler Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/02/2003 12:00:00 AM | 7 | Permit Number 46388 | 6012179.13947 | 2087360.93121 | 37.7121817262883 | -122.399724079808 | (37.7121817262883, -122.399724079808) | 10 | 3 | 8 | 309 | 1 | |
90919 | 38370 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 4245 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | 4 | Permit Number 41159 | 5981126.11155374 | 2104152.1959616 | 37.7565059606627 | -122.508296152224 | (37.7565059606627, -122.508296152224) | 1 | 8 | 3 | 56 | 35 | |
92457 | 27582 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 1777 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2015 12:00:00 AM | 5 | 3X3 | 6001533.8276 | 2112150.0507 | 37.7796476052413 | -122.438292110376 | (37.7796476052413, -122.438292110376) | 15 | 5 | 11 | 29490 | 41 | ||
92789 | 193545 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 900x Carolina St | 16 | Median : Yard | Tree | DPW 1 | 14 | 6012471.27665 | 2103561.30428 | 37.7566808547541 | -122.399851232248 | (37.7566808547541, -122.399851232248) | 10 | 3 | 8 | 28856 | 29 | ||||
93100 | 35511 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 3484 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38913 | 6005154.64040446 | 2103144.1330954 | 37.75512478765 | -122.42512515814 | (37.75512478765, -122.42512515814) | 2 | 4 | 5 | 28859 | 19 | ||
95363 | 210092 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 261 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995627.09016 | 2091704.91878 | 37.7231726926508 | -122.457246512943 | (37.7231726926508, -122.457246512943) | 9 | 8 | 4 | 28861 | 24 | |||
98777 | 210095 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 1x Minerva St | 47 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 5996479.95925 | 2088997.21564 | 37.7157869222034 | -122.454102858955 | (37.7157869222034, -122.454102858955) | 9 | 8 | 6 | 28861 | 24 | |||
98783 | 183354 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 3544 Rivera St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5982117.2654 | 2100157.6466 | 37.7455964086946 | -122.504572502943 | (37.7455964086946, -122.504572502943) | 1 | 8 | 3 | 29491 | 35 | |||
98812 | 31632 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 2518 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1995 12:00:00 AM | Permit Number 35149 | 5981501.18115239 | 2097930.22205683 | 37.7394442612499 | -122.506537629785 | (37.7394442612499, -122.506537629785) | 1 | 8 | 3 | 29491 | 35 | ||
98951 | 35513 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 3488 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/2006 12:00:00 AM | Permit Number 38915 | 6005128.06949501 | 2103142.26204564 | 37.755118149138 | -122.425216915019 | (37.755118149138, -122.425216915019) | 2 | 4 | 5 | 28859 | 19 | ||
101248 | 24770 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 201X Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1998 12:00:00 AM | 12 | 5982138.31917 | 2112600.73174 | 37.7797627971082 | -122.505421833339 | (37.7797627971082, -122.505421833339) | 11 | 6 | 2 | 55 | 26 | |||
102262 | 210099 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 700 Junipero Serra Blvd | 70 | : | Tree | Private 2 | 12 | Width 0ft | 5991230.12075 | 2092291.98484 | 37.7245311168111 | -122.472488607856 | (37.7245311168111, -122.472488607856) | 9 | 8 | 4 | 64 | 40 | |||
103136 | 30671 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 39 McCoppin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1995 12:00:00 AM | Permit Number 34597 | 6006368.06236527 | 2109117.19408355 | 37.7715938820876 | -122.421352936259 | (37.7715938820876, -122.421352936259) | 8 | 2 | 9 | 28853 | 19 | |||
103246 | 31306 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 561 Birch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 0 | Permit Number 34946 | 6005105.48028119 | 2111430.55673025 | 37.7778745481219 | -122.425884980842 | (37.7778745481219, -122.425884980842) | 7 | 9 | 11 | 28852 | 10 | |
105967 | 184532 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 4041 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5981429.119 | 2102119.1438 | 37.7509416273735 | -122.507097450181 | (37.7509416273735, -122.507097450181) | 1 | 8 | 3 | 29491 | 35 | |||
106419 | 37107 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 4501 Irving St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39705 | 5981809.38189346 | 2106215.79884963 | 37.7622122675222 | -122.506086203855 | (37.7622122675222, -122.506086203855) | 1 | 8 | 3 | 56 | 35 | ||
107796 | 183355 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 3546 Rivera St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5982088.9451 | 2100155.7156 | 37.7455894408142 | -122.504670285508 | (37.7455894408142, -122.504670285508) | 1 | 8 | 3 | 29491 | 35 | |||
109582 | 210097 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 300 Junipero Serra Blvd | 46 | : | Tree | Private 2 | 6 | Width 0ft | 5991383.70914 | 2094347.6763 | 37.7301844215576 | -122.472107448217 | (37.7301844215576, -122.472107448217) | 9 | 8 | 4 | 64 | 40 | |||
110012 | 47074 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 106 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | 0 | Permit Number 45062 | 5996796.88091549 | 2112360.28017641 | 37.7799542788822 | -122.454694357616 | (37.7799542788822, -122.454694357616) | 15 | 6 | 2 | 54 | 16 | |
111078 | 40210 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 418 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1999 12:00:00 AM | Permit Number 41392 | 5981924.63262302 | 2112926.84029829 | 37.7806456178699 | -122.506185243392 | (37.7806456178699, -122.506185243392) | 11 | 6 | 2 | 55 | 26 | ||
113261 | 38927 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 30 Lunado Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40735 | 5991530.3910798 | 2091455.54556163 | 37.7222518366051 | -122.471389705232 | (37.7222518366051, -122.471389705232) | 9 | 8 | 4 | 59 | 40 | ||
114045 | 43057 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 1922 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53821 | 5981365.4957 | 2101971.9303 | 37.7505336732727 | -122.507306541093 | (37.7505336732727, -122.507306541093) | 1 | 8 | 3 | 29491 | 35 |
118942 | 39832 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 1900 48th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41153 | 5981364.12857436 | 2102124.06115885 | 37.7509513011754 | -122.507322554156 | (37.7509513011754, -122.507322554156) | 1 | 8 | 3 | 29491 | 35 | ||
120686 | 31636 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 2542 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37115 | 5981513.83287394 | 2097774.63274006 | 37.7390178008812 | -122.506482350919 | (37.7390178008812, -122.506482350919) | 1 | 8 | 3 | 29491 | 35 | ||
121147 | 250982 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 145 Seal Rock Dr | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5981196.97714 | 2112934.78303 | 37.7806245632172 | -122.508703097089 | (37.7806245632172, -122.508703097089) | 11 | 6 | 2 | 55 | 26 | |||
122211 | 40219 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 165 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1999 12:00:00 AM | Permit Number 41398 | 5981062.91201163 | 2112924.76539407 | 37.7805891547083 | -122.509166139987 | (37.7805891547083, -122.509166139987) | 11 | 6 | 2 | 55 | 26 | ||
122318 | 210100 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 700 Junipero Serra Blvd | 125 | : | Tree | Private 2 | 6 | Width 0ft | 5991216.87042 | 2091758.40738 | 37.7230652785221 | -122.472495529943 | (37.7230652785221, -122.472495529943) | 9 | 8 | 4 | 64 | 40 | |||
123040 | 46397 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 2363 46th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/2002 12:00:00 AM | Permit Number 44628 | 5982038.69993379 | 2099019.08157606 | 37.7424656032555 | -122.504759817001 | (37.7424656032555, -122.504759817001) | 1 | 8 | 3 | 29491 | 35 | |||
123996 | 31643 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 3601 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1995 12:00:00 AM | Permit Number 35157 | 5982065.15070434 | 2098736.73871701 | 37.7416919237879 | -122.504647444825 | (37.7416919237879, -122.504647444825) | 1 | 8 | 3 | 29491 | 35 | ||
126706 | 37633 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 793 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40051 | 5990357.97842308 | 2109989.05024853 | 37.7730721073475 | -122.476795862973 | (37.7730721073475, -122.476795862973) | 11 | 6 | 2 | 55 | 26 | ||
127757 | 39831 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 1900 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41153 | 5981364.12857436 | 2102124.06115885 | 37.7509513011754 | -122.507322554156 | (37.7509513011754, -122.507322554156) | 1 | 8 | 3 | 29491 | 35 | ||
128193 | 27691 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 1765 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2015 12:00:00 AM | 7 | 3X3 | 6001581.2067 | 2112155.8038 | 37.779666096456 | -122.438128618136 | (37.779666096456, -122.438128618136) | 15 | 5 | 11 | 29490 | 41 | ||
128694 | 46380 | DPW Maintained 1 | Melaleuca nesophila :: Pink Melaleuca 304 | 2491 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | 9 | Permit Number 44617 | 5983004.0718 | 2098197.5632 | 37.7402666818538 | -122.501361148049 | (37.7402666818538, -122.501361148049) | 1 | 8 | 3 | 29491 | 35 | |
130269 | 31641 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 2594 Great Hwy | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1995 12:00:00 AM | Permit Number 35156 | 5981541.24493631 | 2097437.52256583 | 37.738093803256 | -122.506362582222 | (37.738093803256, -122.506362582222) | 1 | 8 | 3 | 29491 | 35 |
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) );